mysql标识列的特点

DROP TABLE IF EXISTS tab_id;

CREATE TABLE tab_id(

id INT PRIMARY KEY AUTO_INCREMENT,

NAME VARCHAR(20)

);

INSERT INTO tab_id VALUES(NULL,'john');#可重复执行插入

INSERT INTO tab_id(NAME) VALUES('lucy');

SELECT * FROM tab_id;

#自增步长

SET auto_increment_increment=3;