0

MySQL中怎样重置AUTO_INCREMENT?

lee created at5 years ago view count: 2379

MySQL中怎样重置AUTO_INCREMENT,改变自增ID?

report
回复
0

ALTER TABLE tablename AUTO_INCREMENT = 1000 AUTO_INCREMENT一定要比表中的最大ID都要大,不然后面会主键冲突。

5 years ago 回复