MySQL 编程

示例

一个并不健壮的示例：

//=====================================================================
// 连接 MySQL 的测试
//=====================================================================
#include<stdio.h>
#include<string.h>
#include<mysql.h>
//---------------------------------------------------------------------
int main(){
  MYSQL mysql;
  mysql_init(&mysql);
  mysql_real_connect(&mysql, "localhost", "lilydjwg", "***",
      "demo", 0, NULL, 0);
  const char *q = "select * from words";
  mysql_real_query(&mysql, q, strlen(q));
  MYSQL_RES *res;
  res = mysql_store_result(&mysql);
  MYSQL_ROW row;
  int t;
  while(row = mysql_fetch_row(res)){
    for(t = 0; t < mysql_num_fields(res); t++){
      printf("%s ", row[t]);
    }
    putchar('\n');
  }

  mysql_free_result(res);
  mysql_close(&mysql);

  return 0;
}
//=====================================================================

编译

gcc -o mysql mysql.c -I/usr/include/mysql -L/usr/lib/mysql -lmysqlclient

参见

• MySQL

外部链接

• CSDN: The MySQL C API 编程实例