C连接MYSQL源码
http://download.csdn.net/detail/qixing1115/4037327
最近学习数据库,就在网上找了段C连接MYSQL的源码稍加整理了下。
上面资源里有C的源码和MYSQL的安装图解
有兴趣的就给我点分下载去吧
主要代码如下:
说明:该资源非本人原创
int main(void){ MYSQL mysql; MYSQL_RES *result; MYSQL_ROW rows; /*init the connected handle*/ mysql_init(&mysql); /* Connect to database */ if (!mysql_real_connect(&mysql,"localhost","root","123456","test", 0, NULL, 0)) { fprintf(stderr,"Can not connect:%s\n"); exit(0); } else { printf("connection successful\n"); } /* send SQL query */ if((mysql_query(&mysql,"SELECT id,name from persons"))) { fprintf(stdout,"Error in query\n"); exit(0); } if(!(result=mysql_store_result(&mysql))) { fprintf(stderr,"Error reading result set\n"); } while((rows = mysql_fetch_row(result))) { fprintf(stdout,"%s - %s\n",rows[0],rows[1]); } mysql_free_result(result); mysql_close(&mysql); return 0;}