ubuntu下c语言访问mysql的小例子

《ubuntu下c语言访问mysql的小例子》由会员上传分享，免费在线阅读，更多相关内容在应用文档-天天文库。

1、#include#include#defineHOST"localhost"#defineUSERNAME"root"#definePASSWD"root"#defineDATABASE"aaa"intmain(){//connecttomysqldatabaseMYSQL*connection;connection=mysql_init(NULL);if(!mysql_real_connect(connection,HOST,USERNAME,PASSWD,DATABASE,0,NULL,0)){perror("mysqlco

2、nnectionfailed");mysql_close(connection);exit(EXIT_FAILURE);}//execsqlqueryMYSQL_RES*res_ptr;MYSQL_FIELD*field;MYSQL_ROWrow;char*sql="SELECT*FROMname";if(mysql_query(connection,sql)!=0){perror("mysqlqueryfailed");exit(EXIT_FAILURE);}//getthequeryresultif((res_ptr=mysql_store_result(con

3、nection))!=NULL){intcol_num=mysql_num_fields(res_ptr);introw_num=mysql_num_rows(res_ptr);//printthefieldsnameinti;for(i=0;iname);}printf("/n");//printqueryresultfor(i=0;i

4、r(j=0;j