当前位置: 技术问答>linux和unix
linux下c编程问题!
来源: 互联网 发布时间:2015-06-23
本文导语: 关于Mysql数据库问题 如何通过c程序显示某个表里的数据! 谢谢! | C连接MYSQL不是有一套专门的函数吗?? | [wwshao@localhost mysql-examp]$ rpm -qa|grep mysql mysql-3.23.58-1.9 mysql-devel-3.23...
关于Mysql数据库问题
如何通过c程序显示某个表里的数据!
谢谢!
如何通过c程序显示某个表里的数据!
谢谢!
|
C连接MYSQL不是有一套专门的函数吗??
|
[wwshao@localhost mysql-examp]$ rpm -qa|grep mysql
mysql-3.23.58-1.9
mysql-devel-3.23.58-1.9
mysql-server-3.23.58-1.9
[wwshao@localhost mysql-examp]$ cat test.c
#define MAXLEN 50
#include
#include "mysql.h"
#include "mysqld_error.h"
#include
#include
int main(int argc ,char **argv)
{
MYSQL mysql;
MYSQL_RES *mysql_result;
MYSQL_FIELD *field;
MYSQL_ROW row;
int count = 0;
int i= 0;
char sQueue[MAXLEN + 1];
memset(sQueue,0,sizeof sQueue);
strcpy(sQueue,"select * from user_name");
mysql_init(&mysql);
if (!mysql_real_connect(&mysql,"localhost","wwshao","wwshao","test",0,N)
{
printf("Failed to connect to database: Error: %sn",
mysql_error(&mysql));
exit(-1);
}
if(mysql_real_query(&mysql, sQueue, strlen(sQueue)))
{
printf("Failed to queue to database: Error: %sn",
mysql_error(&mysql));
exit(-1);
}
mysql_result=mysql_store_result(&mysql);
count=mysql_field_count(&mysql);
while((row=mysql_fetch_row(mysql_result)))
{
for(;i
mysql-3.23.58-1.9
mysql-devel-3.23.58-1.9
mysql-server-3.23.58-1.9
[wwshao@localhost mysql-examp]$ cat test.c
#define MAXLEN 50
#include
#include "mysql.h"
#include "mysqld_error.h"
#include
#include
int main(int argc ,char **argv)
{
MYSQL mysql;
MYSQL_RES *mysql_result;
MYSQL_FIELD *field;
MYSQL_ROW row;
int count = 0;
int i= 0;
char sQueue[MAXLEN + 1];
memset(sQueue,0,sizeof sQueue);
strcpy(sQueue,"select * from user_name");
mysql_init(&mysql);
if (!mysql_real_connect(&mysql,"localhost","wwshao","wwshao","test",0,N)
{
printf("Failed to connect to database: Error: %sn",
mysql_error(&mysql));
exit(-1);
}
if(mysql_real_query(&mysql, sQueue, strlen(sQueue)))
{
printf("Failed to queue to database: Error: %sn",
mysql_error(&mysql));
exit(-1);
}
mysql_result=mysql_store_result(&mysql);
count=mysql_field_count(&mysql);
while((row=mysql_fetch_row(mysql_result)))
{
for(;i