MySQL连接取值
MySQL连接取值#include <mysql.h>
#include <stdio.h>
int main()
{
MYSQL mysql; // need a instance to init
MYSQL_RES *res;
MYSQL_ROW row;
char *query;
int t,r;
mysql_init(&mysql);
if(!mysql_real_connect(&mysql,"localhost", "username", "password", "test",0,NULL,0))
{
printf( "Error connecting to database: %s\n",mysql_error(&mysql));
}
else
printf("Connected...\n");
query = "select * from t1";
t = mysql_real_query(&mysql,query,(unsigned int) strlen(query));
if (t)
{
printf("Error making query: %s\n",
mysql_error(&mysql));
}
else
printf("[%s] made...\n", query);
res = mysql_store_result(&mysql);
while(row = mysql_fetch_row(res))
{
for(t=0;t<mysql_num_fields(res);t++)
printf("%s ",row);
printf("\n");
}
printf("mysql_free_result...\n");
mysql_free_result(res);
mysql_close(&mysql);
return 0;
}
test数据库和t1表均已建立.用如下命令编译:
gcc -o testsql testsql.c -I/usr/include/mysql -L/usr/lib/mysql -lmysqlclient 我又回来看我们的论坛了
页:
[1]