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);
}