C语言中一条sql语句中的多个插入

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

int main() {
    MYSQL *conn;
    MYSQL_RES *res;
    MYSQL_ROW row;

    char *server = "localhost";
    char *user = "root";
    char *password = "password";
    char *database = "testdb";

    conn = mysql_init(NULL);

    if (!mysql_real_connect(conn, server, user, password, database, 0, NULL, 0)) {
        fprintf(stderr, "%s\n", mysql_error(conn));
        return 1;
    }

    // 构造多条插入语句
    char query[255];
    snprintf(query, sizeof(query), "INSERT INTO employees (id, name, salary) VALUES "
                                 "(1, 'Alice', 50000), "
                                 "(2, 'Bob', 60000), "
                                 "(3, 'Charlie', 55000);");

    if (mysql_query(conn, query)) {
        fprintf(stderr, "%s\n", mysql_error(conn));
        return 1;
    }

    mysql_close(conn);
    return 0;
}

mysql_query(conn, "BEGIN");
// 执行多条插入语句
if (mysql_query(conn, query)) {
    mysql_query(conn, "ROLLBACK");
    fprintf(stderr, "%s\n", mysql_error(conn));
    return 1;
}
mysql_query(conn, "COMMIT");