MYSQL my_connection;
int res;
int id;
char nam;
int num;
char sql[100];mysql_init(&my_connection);
if (mysql_real_connect(&my_connection, "localhost", "root", "111111","test",0,NULL,CLIENT_FOUND_ROWS))
{
printf("Connection success\n");
printf("insert id\n");
scanf("%d",&id);
printf("insert name\n");
scanf("%s",&nam);
printf("insert num\n");
scanf("%d",&num);
sprintf(sql,"insert into stu values('%d','%s','%d');",id,nam,num);(节选部分程序)
编译后有错误:
insert.c:27:5: 警告: 格式 ‘%s’ expects argument of type ‘char *’, but argument 4 has type ‘int’ [-Wformat]而且id在数据库中显示的与输入的值不相符。
求各路大神的帮助mysqlc
int res;
int id;
char nam;
int num;
char sql[100];mysql_init(&my_connection);
if (mysql_real_connect(&my_connection, "localhost", "root", "111111","test",0,NULL,CLIENT_FOUND_ROWS))
{
printf("Connection success\n");
printf("insert id\n");
scanf("%d",&id);
printf("insert name\n");
scanf("%s",&nam);
printf("insert num\n");
scanf("%d",&num);
sprintf(sql,"insert into stu values('%d','%s','%d');",id,nam,num);(节选部分程序)
编译后有错误:
insert.c:27:5: 警告: 格式 ‘%s’ expects argument of type ‘char *’, but argument 4 has type ‘int’ [-Wformat]而且id在数据库中显示的与输入的值不相符。
求各路大神的帮助mysqlc
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货