select * table;
mysql_num_conut返回行数
mysql_store_result返回select结果集
mysql_filed_count 返回结果集是多少列
mysql_fetch_row结果集中取一行
MYSQL * dbmysql = mysql_init(NULL);
dbmysql = mysql_real_connection(dbmysql,
"localhost",
"root",
"",
"test_second",
0,
NULL,
0);
if(dbmysql == null)
{
printf("连接失败%d,%s\n",mysql_errno,mysql_error(dbmysql));
}
else
{
printf("连接成功!\n);
int ret = mysql_query(dbmysql,"select * from dept"
if(ret==0){
printf("执行成功!\n");
MYSQL * res_ptr = mysql_store_result(dbmysql);
int cnt= mysql_num_row(res_ptr);
int col=mysql_filed_count(dbmysql);
printf("语句影响了%d行,%d列\n",&cnt,&col);
// 打印查询到的结果
for(int i=0;i
MYSQL_ROW row = mysql_fetch_row(res_ptr);
printf("%s",row[0]);
}
}
else{
pintf("执行失败!\n);
}
mysql_close(dbmysql);
}