c 和mysql之间的类型

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

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

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

    int c_int = 123;
    char c_str[] = "Hello, MySQL!";

    // 插入整型数据
    char query1[256];
    sprintf(query1, "INSERT INTO table_name (int_column) VALUES (%d)", c_int);
    if (mysql_query(conn, query1)) {
        fprintf(stderr, "%s\n", mysql_error(conn));
    }

    // 插入字符串数据
    char query2[256];
    sprintf(query2, "INSERT INTO table_name (str_column) VALUES ('%s')", c_str);
    if (mysql_query(conn, query2)) {
        fprintf(stderr, "%s\n", mysql_error(conn));
    }

    mysql_close(conn);
    return 0;
}