创建数据库时:ERROR 1064 (42000): You have an error in your SQL syntax;

在创建数据库时,出现了以下错误,百度了一下发现是将转义字符`错打成了单引号',记录一下

ERROR 1064 (42000): 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 'baiseckill_id bai bigint NOT NULL AUTO_INCREMENT COMMENT '商品库存id',
name ' at line 1

解决问题:将

'seckill_id' bai bigint NOT NULL AUTO_INCREMENT COMMENT '商品库存id',

中'seckill_id'改成`seckill_id`.问题解决

posted @ 2020-10-11 17:32  干锅  阅读(85)  评论(0)    收藏  举报  来源