mysql.rar_MySQL Visual C++_MySql查询_c语言mysql_mysql c语言_mysql操作

#include <mysql.h> #include <stdio.h> int main(int argc, char **argv) { MYSQL mysql; // need a instance to init MYSQL_RES *res; MYSQL_ROW row; char *query; int t,r; mysql_init(&mysql); // connect the database if (!mysql_real_connect(&mysql,"localhost", "mmim", "mmim", "test",0,NULL,0)) { printf( "Error connecting to database: %s\n",mysql_error(&mysql)); } else printf("Connected...\n"); // get the result from the executing select query query = "select * from t1"; t = mysql_real_query(&mysql,query,(unsigned int) strlen(query)); if (t) { printf("Error making query: %s\n", mysql_error(&mysql)); } else printf("[%s] made...\n", query); res = mysql_store_result(&mysql); while(row = mysql_fetch_row(res)) { for(t=0;t<mysql_num_fields(res);t++) { printf("%s ",row[t]); } printf("\n"); } printf("mysql_free_result...\n"); mysql_free_result(res); //free result after you get the result sleep(1); // execute the insert query query = "insert into t1(id, name) values(3, 'kunp')"; t = mysql_real_query(&mysql,query,(unsigned int) strlen(query)); if (t) { printf("Error making query: %s\n", mysql_error(&mysql)); } else printf("[%s] made...\n", query); mysql_close(&mysql); return 0; }