#include<unistd.h>
#include<stdio.h>
#include<stdlib.h>
#include<mysql/mysql.h>
int main()
{
MYSQL selection;
MYSQL_ROW myrow;
MYSQL_RES *result;//结果指针
int value,i;
mysql_init(&selection); //初始化数据库
if( mysql_real_connect(&selection,"localhost","database","password","table",0,NULL,0))//连接数据库
{
printf("connect success !");
value=mysql_query(&selection,"select * from children");//读数据库进行操作,如果成功返回0
if(!value)
{
result=mysql_store_result(&selection);//获取结果
value=mysql_field_count(&selection);//获取字段数
while(myrow=mysql_fetch_row(result))//获取下一行数据
{
for(i=0;i<value;i++)
printf("%s ",myrow[i]);//打印对应的每个字段
printf("\n");
}
mysql_free_result(result);//释放结果指针
mysql_close(&selection);//关闭数据库
}
}else
{
fprintf(stderr,"error ! %lu : %s",mysql_errno(&selection),mysql_error(&selection));
}
exit(EXIT_SUCCESS);
}
#include<stdio.h>
#include<stdlib.h>
#include<mysql/mysql.h>
int main()
{
MYSQL selection;
MYSQL_ROW myrow;
MYSQL_RES *result;//结果指针
int value,i;
mysql_init(&selection); //初始化数据库
if( mysql_real_connect(&selection,"localhost","database","password","table",0,NULL,0))//连接数据库
{
printf("connect success !");
value=mysql_query(&selection,"select * from children");//读数据库进行操作,如果成功返回0
if(!value)
{
result=mysql_store_result(&selection);//获取结果
value=mysql_field_count(&selection);//获取字段数
while(myrow=mysql_fetch_row(result))//获取下一行数据
{
for(i=0;i<value;i++)
printf("%s ",myrow[i]);//打印对应的每个字段
printf("\n");
}
mysql_free_result(result);//释放结果指针
mysql_close(&selection);//关闭数据库
}
}else
{
fprintf(stderr,"error ! %lu : %s",mysql_errno(&selection),mysql_error(&selection));
}
exit(EXIT_SUCCESS);
}