用c连接mysql数据库出现段错误为什么
void main()
{
MYSQL mysql;
MYSQL_RES *mysql_result;
MYSQL_ROW mysql_row; /* Row data */
int f1, f2, num_row, num_col;
mysql_init(&mysql);
if(!mysql_real_connect(&mysql,NULL,"root","nrsagroup","nrsa",0,NULL,0))
{
printf("Failed to connect to database : Error: %s\n",
mysql_error(&mysql));
return;
}
if(mysql_query(&mysql, "create table huhe(eventid int not null,eventname text)"))
{
(void) printf("Create table fails: Error: %s\n",mysql_error(&mysql));
}
if(mysql_query(&mysql, "insert into huhe(eventid,eventname) values (1,'go to lunch')"))
{
(void) printf("Insert fails: Error: %s\n",mysql_error(&mysql));
}
if(mysql_query(&mysql, "insert into huhe(eventid,eventname) values (2,'go to supper')"))
{
(void) printf("Insert fails: Error: %s\n",mysql_error(&mysql));
}
if (mysql_query(&mysql, "select * from huhe") == 0)
{
mysql_result = mysql_store_result(&mysql);;
num_row = mysql_num_rows(mysql_result); /* Get the no. of row */
num_col = mysql_num_fields(mysql_result); /* Get the no. of column */
for (f1 = 0; f1 < num_row; f1++)
{
for (f2 = 0; f2 < num_col; f2++)
{
mysql_row = mysql_fetch_row(mysql_result); /* Fetch one by one */
printf("[Row %d, Col %d] ==> [%s]\n", f1, f2, mysql_row[f2]);
}
}
}
else
{
(void) printf("Query fails: Error: %s\n",mysql_error(&mysql));
}
mysql_free_result(mysql_result);
mysql_close(&mysql);
}
运行结果显示
[Row 0, Col 0] ==> [1]
[Row 0, Col 1] ==> [go to lunch]
[Row 2, Col 0] ==> [2]
段错误