CREATE TABLE seckill( 'seckill_id' bigint NOT NULL AUTO_INCREMENT COMMENT '商品库存id', 'name' varchar(120) NOT NULL COMMENT '商品名称', 'number' int NOT NULL COMMENT '库存数量', 'start_time' timestamp NOT NULL COMMENT '秒杀开启时间', 'end_time' timestamp NOT NULL COMMENT '秒杀结束时间', 'create_time' timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', PRIMARY KEY (seckill_id), KEY idx_start_time(start_time), KEY idx_end_time(end_time), KEY idx_create_time(create_time) )ENGINE=InnoDB AUTO_INCREMENT = 1000 DEFAULT CHARSET=utf8 COMMENT='秒杀库存表';
错误信息是
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''seckill_id' bigint NOT NULL AUTO_INCREMENT COMMENT '商品库存id',
'name'' at line 2
这样应该没错了!
哇,这个原来是`号,我写的是单引号.一直报错整的我头大
建表时字段名的标点符号有问题:
第12行CHARSET=utf-8改成CHARSET=utf8,COMMENT=
"秒杀库存表"改成
COMMENT=‘
秒杀库存表’单引号