删除表里 的数据
关键字:TRUNCATE
TRUNCATE TABLE id_identiy;
AUTO_INCREMENT
CREATE TABLE id_identiy(
id INT PRIMARY KEY AUTO_INCREMENT,
stuname VARCHAR(20));
INSERT INTO id_identiy(stuname) VALUE('abc');
CREATE TABLE id_identiy(
id INT PRIMARY KEY,
seat INT UNIQUE AUTO_INCREMENT,
stuname VARCHAR(20));
查看步长,默认为1
SHOW VARIABLES LIKE '%auto_increment%';
改变步长
SET auto_increment_increment=3
每次增加为3