如何在MySQL中设置以6000开头的AUTO_INCREMENT字段? [英] How to set an AUTO_INCREMENT field with to start with the value 6000 in mysql?

问题描述

如何在mysql中设置没有自动递增键的字段自动递增，或者如何在mysql中设置起始值为6000的字段自动递增?

How to set a field auto increment without auto increment key in mysql or how set a field auto increment with start value 6000 in mysql?

推荐答案

...如何在mysql中以起始值6000设置字段自动递增?

... how set a field auto increment with start value 6000 in mysql?

如果您的表已经存在:

ALTER TABLE your_table AUTO_INCREMENT = 6000;

如果您要从头开始创建表格:

If you are creating your table from scratch:

CREATE TABLE your_table () AUTO_INCREMENT = 6000;

来源和进一步阅读:

• MySQL 5.1参考手册::使用AUTO_INCREMENT

测试用例:

CREATE TABLE users (
   user_id  int NOT NULL, 
   name     varchar(50),
   PRIMARY KEY (user_id)
);

INSERT INTO users VALUES (1, 'Bob');
INSERT INTO users VALUES (2, 'Joe');
INSERT INTO users VALUES (3, 'Paul');

ALTER TABLE users MODIFY user_id int NOT NULL AUTO_INCREMENT;
ALTER TABLE users AUTO_INCREMENT = 6000;

INSERT INTO users (name) VALUES ('Keith');
INSERT INTO users (name) VALUES ('Steve');
INSERT INTO users (name) VALUES ('Jack');

SELECT * FROM users;
+---------+-------+
| user_id | name  |
+---------+-------+
|       1 | Bob   |
|       2 | Joe   |
|       3 | Paul  |
|    6000 | Keith |
|    6001 | Steve |
|    6002 | Jack  |
+---------+-------+
6 rows in set (0.01 sec)

这篇关于如何在MySQL中设置以6000开头的AUTO_INCREMENT字段?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！