为什么创建mysql数据库表格不成功呢
//选择创建后的数据库
if (mysql_select_db(&mysql,database) != NULL)
{
MessageBox(NULL,"Select DataBase Failed!","Error",MB_OK);
return -1;
}
//在创建的数据库里创建数据表
cSQL = "CREATE TABLE IF NOT EXISIS equipment_table(id int(11) not null auto_increment,\
channel_num int(16),\
enable int,\
equipment_name varchar(30),\
manufacturer varchar(30),\
ip varchar(20),\
mac varchar(30),\
tcp_port int,\
rtsp_port int,\
http_port int,\
user varchar(30),\
primary key (id))";
if (mysql_query(&mysql,cSQL)!=NULL)
{
MessageBox(NULL,"create equipment_table table failed!","Error",MB_OK);
return -1;
}
[解决办法]
EXISTS拼写错误，修改
cSQL = "CREATE TABLE IF NOT EXISTS equipment_table(id int(11) not null auto_increment,\
...
