#include<stdio.h>
#include<string.h>
//MYSQL suppport on Windows
#include<WinSock2.h>
#include<mysql.h>
#pragma comment(lib,"libmysql")
int main()
{
if(mysql_library_init(0,NULL,NULL))
{
printf("could not initialize MYSQL library\n");
return -1;
}
//连接服务器
MYSQL conn;
mysql_init(&conn);
MYSQL* ret = mysql_real_connect(&conn,
"127.0.0.1","root","123456","student"
,0,NULL,0);
if(!ret)
{
printf("Failed to connect to database %s\n",
mysql_error(&conn));
}
char* str = "INSERT INTO `info`"
"(`id`,`name`,`phone`)"
"VALUES"
"('11','b3','00000000011')";
int x = mysql_query(&conn,str);
if(x)
{
printf("error:%s\n",mysql_error(&conn));
}
mysql_close(&conn);
mysql_library_end();
return 0;
}