Home  >  Article  >  Database  >  批改mysql中的auto_increment

批改mysql中的auto_increment

WBOY
WBOYOriginal
2016-06-07 16:16:091071browse

修改mysql中的auto_increment 1.sql语句 ALTER TABLE table_name AUTO_INCREMENT=1 2截断表,truncate 截断表自动增量值自动复位为0。TRUNCATE TABLE table_name

修改mysql中的auto_increment

1.sql语句

ALTER TABLE table_name AUTO_INCREMENT=1

2截断表,truncate

截断表自动增量值自动复位为0。TRUNCATE TABLE table_name

Statement:
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 admin@php.cn