c里面调用mysql

4k-Rn

数据库：personal

表：contact

mysql> select * from contact;

+--------+----------------+--------+-------+------------+-----------------------------------------------------------------+

| name   | email          | tel    | qq    | birthday   | note                                                            |

+--------+----------------+--------+-------+------------+-----------------------------------------------------------------+

| Petter | abc@gmail.com  | 12345  | 54321 | 2008-11-14 | Loves sweet very much!                                          |

| Marry  | aa@163.com     | 13456  | 65431 | 2008-03-05 | Hates Sanlu milk powder!                                        |

| Jack   | zz@163.net     | 13221  | 3422  | 2007-10-02 | Has been in Heaven because of the magic powder mentioned above! |

| Rose   | rr@hotmail.com | 343232 | 2321  | 2007-12-08 | Jack's lover. Suffering from the damn powder                    |

+--------+----------------+--------+-------+------------+-----------------------------------------------------------------+

4 rows in set (0.01 sec)

Want to fetch the content.

Code:

见 下面

编译C程序

Compiling command:

gcc -lmysqlcliet my.c -o query

./query

运行结果如下：

Running result:

================================================

Name: Petter

Email: abc@gmail.com

Tel: 12345

QQ: 54321

Birthday: 2008-11-14

Note: Loves sweet very much!

================================================

================================================

Name: Marry

Email: aa@163.com

Tel: 13456

QQ: 65431

Birthday: 2008-03-05

Note: Hates Sanlu milk powder!

================================================

================================================

Name: Jack

Email: zz@163.net

Tel: 13221

QQ: 3422

Birthday: 2007-10-02

Note: Has been in Heaven because of the magic powder mentioned above!

================================================

================================================

Name: Rose

Email: rr@hotmail.com

Tel: 343232

QQ: 2321

Birthday: 2007-12-08

Note: Jack's lover. Suffering from the damn powder

================================================

C程序代码如下：my.c

Code:

#include stdio.h>

#include mysql/mysql.h>

int main()

{

    MYSQL db;/*connector*/

    MYSQL_RES* result;/*result buffer*/

    MYSQL_ROW row;/*one row of the result*/

    int i;

    if(mysql_init(&db) ==NULL)

    {

      fprintf(stderr,"Fail to initialize the db.\n");

      return -1;

    }

    if(!mysql_real_connect(&db,"localhost","root",NULL,"personal",3306,NULL,0))

    {

      fprintf(stderr,"Fail to connect to the server");

      return -1;

    }

    if(mysql_query(&db,"SELECT * FROM contact") != 0)

    {

      fprintf(stderr,"Fail to query the db for information.\n");

      return -1;

    }

    if ((result = mysql_store_result(&db)) == NULL)

    {

      fprintf(stderr,"Fail to get the result.\n");

      return -1;

    }

    while((row=mysql_fetch_row(result)) != NULL)/*fetching each row*/

    {

      puts("================================================");

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

      printf("Email: %s\n",row[1]);

      printf("Tel: %s\n",row[2]);

      printf("QQ: %s\n",row[3]);

      printf("Birthday: %s\n",row[4]);

      printf("Note: %s\n",row[5]);

      puts("================================================");

    }

mysql_free_result(result);

    mysql_close(&db);

    return 0;

}