23,121
社区成员
发帖
与我相关
我的任务
分享怎么在linux上用c程序调用mysql数据库，可以给一段例子么？
怎么在linux上用c程序调用mysql数据库，可以给一段例子么？
...全文
请发表友善的回复…
发表回复
icedust 2004-03-18
- 打赏
- 举报
MYSQL *my = NULL;
MYSQL_RES *result = NULL;
unsigned int num_fields;
MYSQL_ROW row;
my = mysql_init(NULL);
if(my == mysql_real_connect(my, NULL, "root", NULL, "DBname", 0, NULL, 0))
qDebug("Connected to mysql!\n");
if(mysql_query(my, "select * from Tablename;"))
{
qDebug("Failed to select");
mysql_close(my);
}
if((result = mysql_store_result(my)) == NULL)
{
fprintf(stderr, "Failed to store result. Error: %s\n",mysql_error(my));
mysql_close(my);
}
while(row = mysql_fetch_row(result))
{
//读取得到的数据
}
mysql_close(my);//关闭
具体请参看mysql上的帮助
MYSQL_RES *result = NULL;
unsigned int num_fields;
MYSQL_ROW row;
my = mysql_init(NULL);
if(my == mysql_real_connect(my, NULL, "root", NULL, "DBname", 0, NULL, 0))
qDebug("Connected to mysql!\n");
if(mysql_query(my, "select * from Tablename;"))
{
qDebug("Failed to select");
mysql_close(my);
}
if((result = mysql_store_result(my)) == NULL)
{
fprintf(stderr, "Failed to store result. Error: %s\n",mysql_error(my));
mysql_close(my);
}
while(row = mysql_fetch_row(result))
{
//读取得到的数据
}
mysql_close(my);//关闭
具体请参看mysql上的帮助
