12.Linux下libmysql库开发MySQL

• 安装依赖

sudo apt install libmysqlclient-dev

• demo code

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


int main() {

    MYSQL *conn;
    MYSQL_RES *res;
    MYSQL_ROW row;
    char server[] = "localhost";
    char user[] = "root";
    char password[] = "test";
    char database[] = "test";
    unsigned int port = 3306;

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

    if (mysql_query(conn, "select * from goods")) {
        fprintf(stderr, "%s\n", mysql_error(conn));
        exit(1);
    }

    res = mysql_use_result(conn);

    while ((row = mysql_fetch_row(res)) != NULL) {
        printf("%s\t%s\t%s \n", row[0], row[1], row[2]);
    }

    mysql_free_result(res);
    mysql_close(conn);

    printf("finish!\n");
    
    return 0;
}

• 编译

gcc mysql_demo.c -o mysql_demo -lmysqlclient