search

Home >Database >Mysql Tutorial >修改mysql的主键默认值

修改mysql的主键默认值

WBOY
WBOYOriginal
2016-06-07 14:57:401952browse

当你测试的数据被删除时，主键id就会有间隔，可以修改主键的默认值消除间隔 无 alter TABLE syxg_user AUTO_INCREMENT=21

当你测试的数据被删除时，主键id就会有间隔，可以修改主键的默认值消除间隔 
alter TABLE syxg_user AUTO_INCREMENT=21
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
Previous article：最近自动产生的序列的编号Next article：MySQL实现简单row_number()的模拟

Related articles

See more