MySQL_C操作
// need a instance to initMYSQL mysql;
char *query;
int t;
// connect the database
mysql_init(&mysql);
if (!mysql_real_connect(&mysql, "localhost", "", "", "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);
MYSQL_RES *res = mysql_store_result(&mysql);
MYSQL_ROW row;
while(row = mysql_fetch_row(res))
{
for(t=0;t<mysql_num_fields(res);t++)
{
printf("%s ",row);
}
printf("\n");
}
printf("mysql_free_result...\n");
mysql_free_result(res); //free result after you get the result
// 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);
页:
[1]