다음에 적용될 Auto_increment 값 알아 내기 (计算下一个Auto_increment的值）

Mysql 4.X <------

SHOW TABLE STATUS FROM [DB_NAME] LIKE '[TABLE_NAME]';

 

 

Mysql 5.X -----------

SELECT AUTO_INCREMENT FROM INFORMATION_SCHEMA.TABLES

WHERE TABLE_SCHEMA = '[DB_NAME]' AND TABLE_NAME = '[TABLE_NAME]'