最近一人说这段代码老报错
CREATE TABLE IF NOT EXISTS `ims_xiye_sailongzhou_userinfo` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT=1, `openid` varchar(50) NOT NULL, `grade` varchar(50) NOT NULL COMMENT '最高分数', `number` varchar(50) NOT NULL COMMENT '默认次数', `share_num` varchar(50) NOT NULL COMMENT '分享次数', `create_time` int(10) unsigned NOT NULL PRIMARY KEY (`id`) ) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '=1, `openid` varchar(50) NOT NULL, `grade` varchar(50) NOT NULL COMME' at line 2
后面一句一句测试后发现特么少打了个,
`create_time` int(10) unsigned NOT NULL PRIMARY KEY (`id`)
两句中间没打,