#查询自增步长
show VARIABLES like 'auto_inc%';
#修改自增步长
set @@auto_increment_increment=2;
#修改起始值
set @@auto_increment_offset=5;
DROP TABLE IF EXISTS `ordernumber`;
CREATE TABLE `ordernumber` (
`order-number` int auto_increment primary key,
KEY `order-number` (`order-number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
#插入3条数据
insert into orderNumber value(null);
insert into orderNumber value(null);
insert into orderNumber value(null);