How do I view the auto_increment value for a table

Question

The only way I know is show create table MyTable

Answer 1

SHOW TABLE STATUS LIKE "tablename";

the auto_increment column will show the count.

Answer 2

You can use LAST_INSERTED_ID function.

Answer 3

SELECT `AUTO_INCREMENT`
  FROM `information_schema`.`TABLES`
 WHERE `TABLE_SCHEMA` = SCHEMA()
   AND `TABLE_NAME` = 'tbl_name';