ubuntu下c调用mysql的简单例子

 

      

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

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)

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