mariadb的C语言开发库

在Fedora里，包名为mariadb-connector-c-devel。可以通过
    sudo dnf install mariadb-connector-c-devel

来安装。

头文件包含

#include<mysql/mysql.h>

主要函数

• 初始化
      MYSQL *        STDCALL mysql_init(MYSQL *mysql);

• 连接

MYSQL *        STDCALL mysql_real_connect(MYSQL *mysql, const char *host,const char *user,const char *passwd,const char *db,unsigned int port,const char *unix_socket,unsigned long clientflag);

• 执行
      int        STDCALL mysql_query(MYSQL *mysql, const char *q);

• 关闭
      void        STDCALL mysql_close(MYSQL *sock);

示例

void
insert_string_to_mysql (const char *dbname, const char *dbuser,const char *dbpass, const char *string)
{MYSQL conn;mysql_init (&conn);if (mysql_real_connect (&conn, "localhost", dbuser, dbpass, dbname, 0, NULL,0)== NULL){fprintf (stderr, "mysql init error: %s.\n", mysql_error (&conn));return;}if (mysql_query (&conn, string) != 0){fprintf (stderr, "mysql insert error: %s.\n", mysql_error (&conn));}mysql_close (&conn);
}