想要mysql查看表当前自增id的值,以俺所知其方式有三
-
show table status where name = ‘表名’;
-
SHOW CREATE TABLE `表名`;
-
SELECT auto_increment FROM information_schema.TABLES WHERE TABLE_SCHEMA = ‘库名’ AND TABLE_NAME = ‘表名’
想要mysql查看表当前自增id的值,以俺所知其方式有三
show table status where name = ‘表名’;
SHOW CREATE TABLE `表名`;
SELECT auto_increment FROM information_schema.TABLES WHERE TABLE_SCHEMA = ‘库名’ AND TABLE_NAME = ‘表名’