linux+c程序+mysql_linux下C程序连接MySQL

MySQL有很多C语言的API，其中可以参考：MySQL的API和库。

网上的C语言连接MySQL例程：用C语言操作MySQL数据库。

代码示例：

#include

#include

#include

#include

#include "mysql.h"

//#include "mysql/mysql.h"

int main(int argc, char **argv)

{

MYSQL *sql;

sql = mysql_init(NULL);

if (!sql) {

printf("mysql_init error\n");

exit(1);

}

if (!mysql_real_connect(sql, "192.168.1.150", "teamtalk", "test@123", "test", 0, NULL, 0)) {

printf("mysql_real_connect error\n");

printf("%s\n", mysql_error(sql));

exit(2);

}

printf("connect mysql ok\n");

const char *str = "select * from persion";

if (mysql_real_query(sql, str, strlen(str))) {

printf("mysql_real_query failed: %s, sql: %s\n", mysql_error(sql), str);

exit(3);

}

MYSQL_RES *res = mysql_store_result(sql);

if (!res) {

printf("mysql_store_result failed: %s", mysql_error(sql));

exit(4);

}

// 输出查询的结果

MYSQL_ROW row, end_row;

int columns = mysql_num_fields(res);

while ((row = mysql_fetch_row(res))) {

for (end_row = row + columns; row < end_row; ++row) {

printf("%s\t", row ? (char *)*row : "NULL");

}

printf("\n");

}

printf("----------------------\n");

char sql_update[512];

snprintf(sql_update, sizeof(sql_update), "%s", "insert persion (name, age) values ('luoxn28', 24)");

if (mysql_real_query(sql, sql_update, strlen(sql_update))) {

printf("mysql_real_query failed: %s, sql: %s\n", mysql_error(sql), str);

exit(3);

}

if (mysql_real_query(sql, str, strlen(str))) {

printf("mysql_real_query failed: %s, sql: %s\n", mysql_error(sql), str);

exit(3);

}

res = mysql_store_result(sql);

if (!res) {

printf("mysql_store_result failed: %s\n", mysql_error(sql));

exit(4);

}

// 输出查询的结果

columns = mysql_num_fields(res);

while ((row = mysql_fetch_row(res))) {

for (end_row = row + columns; row < end_row; ++row) {

printf("%s\t", row ? (char *)*row : "NULL");

}

printf("\n");

}

mysql_close(sql);

return 0;

}

编译时命令：gccmain.c –I/usr/include/mysql –lmysqlclient

centos7下需安装mysql的C接口库，yum install mysql-devel

gcc –I/usr/include/mysql–L/usr/local/mysql/lib –lmysqlclient main.c