mysql 编程 select_C语言连接mysql（Select功能）

#include

#include

#include

#include

#include

#pragma comment(lib, "libmysql.lib")

int main()

{

MYSQL mysql;     //mysql连接

MYSQL_RES *res; //这个结构代表返回行的一个查询结果集

MYSQL_ROW row; //一个行数据的类型安全(type-safe)的表示

char *query;  //查询语句

int t,r;

mysql_init(&mysql);

if (!mysql_real_connect(&mysql,"localhost", "root", "", "test",3306,NULL,0))

{

printf( "Error connecting to database: %s\n",mysql_error(&mysql));

}  else

printf("Connected\n");

query="SET CHARACTER SET GBK"; //设置编码

t=mysql_real_query(&mysql,query,(unsigned int)strlen(query));

if(t)

{

printf("编码设置失败\n");

}

query=" select * from abing ";

t=mysql_real_query(&mysql,query,(unsigned int)strlen(query));

if(t)

{

printf("执行查询时出现异常: %s",mysql_error(&mysql));

}else

printf("[%s] 构建成功 \n",query);

res=mysql_store_result(&mysql);

while(row=mysql_fetch_row(res))

{

for(t=0;t

{

printf("%s\t",row[t]);

}

printf("\n");

}

mysql_free_result(res);

}