发现了一篇文章,感觉还不错,不过没测试,是不是在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