-- 查看MySQL自增当前值
show table status like 'sys_user';
SELECT auto_increment FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'ftf' AND TABLE_NAME = 'sys_user';
-- 修改MySQL自增当前值
alter table sys_user auto_increment=255;
查看MySQL自增当前值 修改MySQL自增当前值
![](https://img-home.csdnimg.cn/images/20240711042549.png)