网站建设知识
Mysql创建表实现主键自增并且初始值为1000
2025-07-22 11:15  点击:0

Mysql创建表实现主键自增并且初始值为1000,具体sql语句为如下:

CREATE TABLE `seckill` (  `seckill_id` bigint(20) NOT NULL AUTO_INCREMENT comment '商品库存id' ,  `name` varchar(120) NOT NULL comment '商品名称' ,  `number` int(11) NOT NULL  comment '库存数量',  `start_time` timestamp NOT NULL  comment '秒杀开启时间',  `end_time` timestamp NOT NULL  comment '秒杀结束时间',  `create_time` timestamp NOT NULL  DEFAULT CURRENT_TIMESTAMP on update 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 DEFAULT CHARSET=utf8 AUTO_INCREMENT=1000 comment '秒杀库存表';