mysql生成带初始值的序列号

[笑莫问]

eg:
create table user(
id int auto_increment primary key
);
这样生成的id是从1开始的，我想让它从10000开始递增，怎么写sql语句？

[挨踢直男]

if object_id('tb') is not null
drop table tb

create table tb
(
id int identity(10000,1) primary key,
col int
)

insert tb(col) select 1
union all
select 2

select * from tb


(2 行受影响)
id          col
----------- -----------
10000       1
10001       2

(2 行受影响)

[笑莫问]

是用mysql数据库吗？我的建表出错
mysql> create table tb
-> (
-> id int identity(10000,1) primary key,
-> col int
-> );
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL s
erver version for the right syntax to use near 'identity(10000,1) primary key,
col int
)' at line 3

[笑莫问]

解决了：
可在建表时可用“AUTO_INCREMENT=n”选项来指定一个自增的初始值。

可用alter table table_name AUTO_INCREMENT=n命令来重设自增的起始值。

[peenyking]

我也在找这个呢