How to view auto_increment value for a table

Question

The only way I know is show create table MyTable

Answer 1

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

Answer 2

 SHOW TABLE STATUS LIKE "tablename"; 

the auto_increment column will display the score.

Answer 3

You can use LAST_INSERTED_ID .