c mysql ubuntu_ubuntu下c调用mysql的简单例子

#include

#include

int main()

{

MYSQL * conn;

MYSQL_RES * res;

MYSQL_ROW row;

char * server = "localhost";

char * user = "root";

char * password = "19890207";

char * database = "bit";

conn = mysql_init(NULL);

if (!mysql_real_connect(conn, server,

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

{

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

exit(1);

}

if (mysql_query(conn, "select * from users"))

{

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

exit(1);

}

res = mysql_use_result(conn);

printf("the data of users\n");

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

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

mysql_free_result(res);

mysql_close(conn);

return 0;

}

ps：改代码运行需要安装了

mysql-client

libmysqlclient15-dev

mysql-server:

gcc, make and other development libs

编译命令如下：

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

对应的数据库名称和密码修改为自己对应的即可