C mysql connect_mysql-connect.c

#include

#include

#include

void printResult(MYSQL *mysql);

int main(){

MYSQL * sql;

int res;

sql = mysql_init(NULL);

printf("MySQL client version : %d \n",mysql_get_client_version());

if(!mysql_real_connect(sql,"localhost","root","","tcmu",0,NULL,0)){

puts("Error connecting");

printf("%s\n",mysql_error(sql));

}

else

{

puts("Success connecting\n");

res = mysql_query(sql, "select * from kv");

if (res)

{

printf("query error\n");

}

else

{

printf("Select * from kv\n");

printResult(sql);

}

}

return 0;

}

void printResult(MYSQL *mysqlPrint)

{

printf("Start to print result.\n");

MYSQL_RES * result;

int numFields = 0;

int numRows = 0;

MYSQL_FIELD * field;

MYSQL_ROW row;

int i = 0;

printf("Start to store result\n");

result = mysql_store_result(mysqlPrint);

printf("Start to get the amount of fields and rows!");

numFields = mysql_num_fields(result);

numRows = mysql_num_rows(result);

printf("Fields : %d\n", numFields);

printf("Rows : %d\n", numRows);

while(field = mysql_fetch_field(result))

{

printf("%s\t", field->name);

}

printf("\n");

if(result)

{

while(row = mysql_fetch_row(result))

{

for(i = 0; i < numFields; i++)

{

printf("%s\t", row[i]);

}

printf("\n");

}

}

mysql_free_result(result);

}

一键复制

编辑

Web IDE

原始数据

按行查看

历史