LinuxC -- MySQL

/*  *  file name: mysql.c  *  function: mysqlConnect,mysqlInsert,mysqlUpdate,mysqlDelete *  compile: gcc &(mysql_config --cflags) mysql.c -o mysql $(mysql_config --libs) *  the compiling way works under Ubuntu, others not tested */#include <stdio.h>#include <mysql.h>int main(){/* create a MYSQL connection object */MYSQL *mysql;MYSQL_RES *res;MYSQL_ROW row;/* mysql parameters */char *svr = "localhost";/* mysql server */char *usr = "root";/* login user */char *pwd = "joyboy";/* password */char *db = "information_schema";/* database *//* initialize connection */mysql = mysql_init(NULL);/* connect mysql */if (!mysql_real_connect(mysql,svr,usr,pwd,db,0,NULL,0)){fprintf(stderr, "%s\n",mysql_error(mysql));/* connect failed */exit(1);} else {printf("Connecting mysql successful!\n");/* connect succss */}/* show tables of database */if (mysql_query(mysql,"show tables")){fprintf(stderr,"%s\n",mysql_error(mysql));exit(1);}res = mysql_use_result(mysql);printf("MySQL Tables in mysql database:\n");while((row = mysql_fetch_row(res))!=NULL){printf("%s\n",row[0]);}mysql_free_result(res);/* show top 2 records of table: TABLES */char * sql = "select * from TABLES limit 0,2";if(mysql_query(mysql,sql)){fprintf(stderr,"%s\n",mysql_error(mysql));exit(1);}res = mysql_use_result(mysql);printf("Top 2 records of table TABLES:\n");while((row = mysql_fetch_row(res))!=NULL){printf("%s\n",row[1]);}mysql_free_result(res);/* close connection */mysql_close(mysql);return 0;}