Shulou(Shulou.com)06/01 Report--

Editor to share with you the method of setting self-increasing ID in mysql. I hope you will gain a lot after reading this article. Let's discuss it together.

Mysql can set self-incrementing ID by executing [CREATE TABLE empautoinc (ID INT PRIMARY KEY AUTO_INCREMENT) AUTO_INCREMENT = 0;] statement.

The self-incrementing column of MYSQL must be an indexed column, and the seed value should be set at the end of the table.

-- mysql--

Set ID from N to CREATE TABLE empautoinc (ID INT PRIMARY KEY AUTO_INCREMENT) AUTO_INCREMENT = 100;-(set to ID to start at 100) insert into empautoinc (id) values (null); Query OK, 1 row affected (0.00 sec) mysql > select * from empautoinc +-+ | ID | +-+ | 100 | +-+ 1 row in set (0.00 sec) after reading this article, I believe you have some understanding of the method of setting self-increasing ID in mysql. If you want to know more about it, welcome to follow the industry information channel. Thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.