自动递增列的设置
alter table member auto_increment=460
创建mysql数据表,设置id列递增、主键
create table running_log
(
id int primary key auto_increment,
routename varchar(255),
log varchar(255),
time datetime
);
往有递增数据列的数据表插入新的数据行
1、INSERT INTO running_log
(id
, routename
, log
, time
) VALUES ('null', 'yunnan-101', '测试文本', '2019-08-15 00:00:00');
2、INSERT INTO running_log
(routename
, log
, time
) VALUES ('yunnan-101', '测试文本', '2019-08-15 00:00:00');