發現了一篇文章，感覺還不錯，不過沒測試，是不是在linux下能用
http://www.unix-cd.com/unixcd12/article_view.asp?id=4138貼一段以前在windows上使用mysql的代碼。
?1
#include?<stdio.h>
?2#include?<string.h>
?3#include?<winsock2.h>
?4#include?"mysql.h"
?5
?6#pragma?comment(lib,"libmySQL.lib")
?7
?8
void?main()
{
?9
???MYSQL?*mysql;
10???MYSQL_RES?*res;
11???MYSQL_ROW?row;
12???char?*query;
13???int?t,r;
14???
15
16???mysql=mysql_init(mysql);
17???if?(!mysql_real_connect(mysql,"localhost","root","","ceshi",0,NULL,0))
18
???{
19???????printf(?"Error?connecting?to?database:?%s\n",mysql_error(mysql));
20
???}
21???else
22???????printf("Connected\n");
23
24???query="Insert?Into?admin(username,password)?values('whoami','iampf')";
25???t=mysql_real_query(mysql,query,(unsigned?int)strlen(query));
26???if(t)
27???{
28???????printf("Insert?Error:%s\n",mysql_error(mysql));
29???}
30
31???query="select?*?from?admin";
32???t=mysql_real_query(mysql,query,(unsigned?int)?strlen(query));
33???if?(t)
34???{
35??????printf("Error?making?query:?%s\n",
36??????????????mysql_error(mysql));
37???}
38???else?printf("Query?made\n");
39???res=mysql_use_result(mysql);
40???for(r=0;r<mysql_field_count(mysql);r++){
41???????????row=mysql_fetch_row(res);
42???????????if(row<0)?break;
43???????????for(t=0;t<mysql_num_fields(res);t++){
44???????????????????printf("%s?",row[t]);
45???????????}
46???????????printf("\n");
47???}
48???mysql_close(mysql);
49
}
50
51