想要mysql查看表当前自增id的值,以俺所知其方式有三
-
show table status where name = ‘表名’;
-
SHOW CREATE TABLE `表名`;
-
SELECT auto_increment FROM information_schema.TABLES WHERE TABLE_SCHEMA = ‘库名’ AND TABLE_NAME = ‘表名’
来源地址:https://blog.csdn.net/qq_43647116/article/details/129463290