查看MySQL自增当前值 修改MySQL自增当前值

-- 查看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;