ubuntu mysql开发_ubuntu mysql c api的使用开发实例程序。

1.安装

apt-get install libmysqlclient-dev

2.mysql_config --libs

-Wl,-Bsymbolic-functions -rdynamic -L/usr/lib/mysql -lmysqlclient

3.mysql_config --cflags

-I/usr/include/mysql  -DBIG_JOINS=1  -fno-strict-aliasing   -DUNIV_LINUX -DUNIV_LINUX

/*

See url for more info:

http://www.cyberciti.biz/tips/linux-unix-connect-mysql-c-api-program.html

*/

#include

#include

#include

int main(void) {

MYSQL *conn;

MYSQL_RES *res;

MYSQL_ROW row;

/* Change me */

char *server = "localhost";

char *user = "root";

char *password = "";

char *database = "mysql";

conn = mysql_init(NULL);

/* Connect to database */

if (!mysql_real_connect(conn, server,

user, password, database, 0, NULL, 0)) {

fprintf(stderr, "%s\n", mysql_error(conn));

exit(1);

}

/* send SQL query */

if (mysql_query(conn, "show tables")) {

fprintf(stderr, "%s\n", mysql_error(conn));

exit(1);

}

res = mysql_use_result(conn);

/* output table name */

printf("MySQL Tables in mysql database:\n");

while ((row = mysql_fetch_row(res)) != NULL)

printf("%s \n", row[0]);

/* close connection */

mysql_free_result(res);

mysql_close(conn);

return 0;

}

/LQmysql# gcc -o output-file $(mysql_config --cflags) mysql-c-api.c $(mysql_config --libs)

/LQmysql# ./output-file MySQL Tables in mysql database:

columns_priv

db

event

func

general_log

help_category

help_keyword

help_relation

help_topic

host

ndb_binlog_index

plugin

proc

procs_priv

servers

slow_log

tables_priv

time_zone

time_zone_leap_second

time_zone_name

time_zone_transition

time_zone_transition_type

user

警告： 隐式声明与内建函数 ‘exit’ 不兼容

把stdlib.h包含进来