#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", "", "", "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<mysql_num_fields(res);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