c 的mysql操作_C操作mysql

#include

#include

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", "", "", "test",0,NULL,0))

{

printf( "Error connecting to database: %s/n",mysql_error(&mysql));

}

else

printf("Connected.../n");

query = "select * from student";

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

{

printf("%s ",row[t]);

}

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