mysql -c_C语言操作mysql

//main.c//gcc main.c -o test -lmysqlclient//@linkhttp://dev.mysql.com/doc/refman/5.6/en/c-api-function-overview.htm

//libmysqlclient library

#include#include#includeMYSQL*get_conn()

{//连接配置

char *host = "127.0.0.1";char *user = "root";char *passwd = "";char *db = "test";int port = 3306;

my_bool reconnect= 1;

MYSQL*my_con = (MYSQL *)malloc( sizeof(MYSQL) ); //数据库连接句柄//连接数据库

mysql_init(my_con);

mysql_options(my_con, MYSQL_OPT_RECONNECT,&reconnect);

mysql_real_connect(my_con, host, user, passwd, db, port, NULL, CLIENT_FOUND_ROWS);

mysql_query(my_con,"set names utf8");returnmy_con;

}/**

* 释放空间，关闭连接

*

* @param mysql

* @return*/

void free_conn(MYSQL *mysql)

{

mysql_close(mysql);free(mysql);

}