linux-mysql-insert1_linux mysql 执行insert-优快云博客

本文链接：https://blog.youkuaiyun.com/deerleaper/article/details/50441210

本文介绍了一个简单的C程序示例，该程序使用MySQL C API连接到MySQL数据库，并执行SQL插入语句。程序首先初始化MySQL连接结构，设置主机名、用户名、密码及数据库名称，然后尝试建立连接。若连接成功，则执行插入语句并将受影响的行数输出。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

//simple_mysql_insert.c

#include <stdlib.h>
#include <stdio.h>
#include <mysql.h>


int main(int argc, char *argv[]){

	MYSQL my_connection;
	mysql_init(&my_connection);

	const char* host = "localhost";
	const char* user = "root";
	const char* password = "!QAZ2wsx";
	const char* dbname = "rick";

	if(argc==2){
		password = argv[1];
	}

	int ret = -1;

	MYSQL*  conn_ptr= mysql_real_connect(&my_connection ,host, user, password,dbname,0,NULL,0);

	if(conn_ptr){

		printf("Connection succeed!\n");

		const char* sql = "insert into children(fname, age) values('Kinder', 10)";
		ret = mysql_query(&my_connection, sql);
		if(!ret){
			printf("Inserted %lu rows\n", (unsigned long)mysql_affected_rows(&my_connection));
		}else{
			fprintf(stderr, "Insert error %d : %s \n", mysql_errno(&my_connection), mysql_error(&my_connection));
		}
		mysql_close(&my_connection);

	}else{

		fprintf(stderr, "Connection failed!\n");
		if(mysql_errno(&my_connection)){
			fprintf(stderr, "Connection error %d: %s\n", mysql_errno(&my_connection), mysql_error(&my_connection));
		}
	}
	return 0;
}

运行：

xx@ubuntu:~/workspace/mysql-test$ g++ -o test-insert simple_mysql_insert.c -I/usr/include/mysql -L/usr/lib/mysql -lmysqlclient
xx@ubuntu:~/workspace/mysql-test$ ./test-insert
Connection succeed!
Inserted 1 rows