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

This article will explain in detail about the characteristics of the mysql logo, the editor thinks it is very practical, so share it with you for reference. I hope you can get something after reading this article.

1. The identity column does not have to be matched with the primary key, but it is required to be key.

2. A table has at most one identity column.

3. The type of identity column can only be numeric.

With SET auto_increment_increment=3, the identity column can set the step size.

4. The starting value can be set by manual insertion.

Example

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'); # repeatable insert INSERT INTO tab_id (NAME) VALUES ('lucy'); SELECT * FROM tab_id; # self-increment step SET auto_increment_increment=3 This is the end of this article on "what are the characteristics of the mysql logo". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it for more people to see.

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.