#include <stdio.h>
#include <stdlib.h>
#include "/usr/include/mysql/mysql.h"
 
int main(int argc, char** argv)
{	MYSQL *my_conn;	MYSQL_RES *res;	MYSQL_ROW row;	my_conn=mysql_init(NULL);
 	if(!mysql_real_connect(my_conn,"localhost","root","123","test",0,NULL,0))	{	printf("Connect Error!\n");	exit(1);	}
 	if(mysql_query(my_conn,"select * from songfei"))	{	printf("Query Error!\n");	exit(1);	}
 	res=mysql_use_result(my_conn);
 	printf("The result is:\n");	while((row=mysql_fetch_row(res))!=NULL)	{	printf("%s %s\n",row[0],row[1]);
 	}
 	mysql_free_result(res);	mysql_close(my_conn);
 	return 0;
}