[FAQ] 如何撰寫 MySQL C API

[cosa]

Step 1
.利用文字編輯器撰寫以下程式碼
mysqlc.c
#include
#include

 int main (int argc, char *argv[])
{

MYSQL mysql;
MYSQL_RES *res;
MYSQL_ROW row;
if (argc != 2) {
fputs ("Usage: myc ", stderr);
return 1;
 }

if (!(mysql_connect(&mysql,"localhost","root","Your_Password"))) {
fputs ("Error connecting", stderr);
abort();
 }

 if (mysql_select_db(&mysql,argv[1])) {
fputs ("Error selecting database", stderr);
abort();
 }
 if (mysql_query(&mysql,"SELECT * FROM test_table")) {
fputs ("Error processing query", stderr);
abort();
 }
 if (!(res = mysql_store_result(&mysql))) {
fputs ("Error storing results", stderr);
abort();
}
while((row = mysql_fetch_row(res))) {
uint i = 0;
for (i=0 ; i < mysql_num_fields(res); i++)
 printf("%s ",row); printf(" ");
 }
return 0;
 }

 Step 2. Compile
#gcc -I/usr/local/mysql/include -L/usr/local/mysql/lib/mysql mysqlc.c –lm -lmysqlclient
(其中include path與library path取決於你的MySQL安裝路徑)
 如果執行時,發生如下error Run problem:error in loading shared libraries: libmysqlclient.so.X!
將你的MySQL library path(for example:/usr/local/mysql/lib/mysql) 加入/etc/ld.so.conf, and run /sbin/ldconfig -v