Home > Database > Mysql Tutorial > body text

What are the characteristics of mysql identity columns?

Release: 2023-05-26 23:55:04
4125 people have browsed it

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

2. A table has at most one identity column.

3. The type of the identification column can only be numeric.

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

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


INSERT INTO tab_id VALUES(NULL,'john');#可重复执行插入
INSERT INTO tab_id(NAME) VALUES('lucy');
SELECT * FROM tab_id;
SET auto_increment_increment=3;
Copy after login

The above is the detailed content of What are the characteristics of mysql identity columns?. For more information, please follow other related articles on the PHP Chinese website!

Related labels:
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact [email protected]
Popular Tutorials
Latest Downloads
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!