linux下C程序连接MySQL

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

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

代码示例：

#include <stdio.h>
#include <stdlib.h>
#include <stdarg.h>
#include <string.h>
#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