mysql查看表当前自增id的值

想要mysql查看表当前自增id的值,以俺所知其方式有三

  1. show table status where name = ‘表名’;

  2. SHOW CREATE TABLE `表名`;

  3. SELECT auto_increment FROM information_schema.TABLES WHERE TABLE_SCHEMA = ‘库名’ AND TABLE_NAME = ‘表名’