#if defined(_WIN32) || defined(_WIN64)  //為了支持windows平臺上的編譯

include <windows.h>
endif
include <stdio.h>
include <stdlib.h>
include "mysql.h"
//定義數據庫操作的宏，也可以不定義留著后面直接寫進代碼
define SELECT_QUERY "show tables;"
int main(int argc, char argv) //char argv 相當于 char argv[]
{
    MYSQL mysql,handle;        //定義數據庫連接的句柄，它被用于幾乎所有的MySQL函數
    MYSQL_RES result;          //查詢結果集，結構類型
    MYSQL_FIELD field ;        //包含字段信息的結構
    MYSQL_ROW row ;             //存放一行查詢結果的字符串數組
    char  querysql[160];        //存放查詢sql語句字符串
    //初始化
    mysql_init(&mysql);
    //連接數據庫
    if (!(handle = mysql_real_connect(&mysql,"localhost","user","pwd","dbname",0,NULL,0))) {
        fprintf(stderr,"Couldn't connect to engine!\n%s\n\n",mysql_error(&mysql)); 
    }
    sprintf(querysql,SELECT_QUERY,atoi(argv[1]));
    //查詢數據庫
    if(mysql_query(handle,querysql)) {
        fprintf(stderr,"Query failed (%s)\n",mysql_error(handle));
    }
    //存儲結果集
    if (!(result=mysql_store_result(handle))) {
        fprintf(stderr,"Couldn't get result from %s\n", mysql_error(handle));
    }
    printf("number of fields returned: %d\n",mysql_num_fields(result));
    //讀取結果集的內容
    while (row = mysql_fetch_row(result)) {
        printf("table: %s\n",(((row[0]==NULL)&&(!strlen(row[0]))) ? "NULL" : row[0]) ) ; 
    } 
    //釋放結果集
    mysql_free_result(result);
    //關閉數據庫連接
    mysql_close(handle);

system("PAUSE");  
//為了兼容大部分的編譯器加入此行
return 0;   

}</pre>