How to select the value of the current auto_increment of a table?

Question

PHP

Hello. Tell me please. Here is a table. The current value of Auto_increment = 30. This is the value I need to get. How can this be done using sql query or yii framework?

Answer 1

SELECT `AUTO_INCREMENT`
FROM  INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'DatabaseName'
AND   TABLE_NAME   = 'TableName';

Answer 2

$auto = mysql_fetch_assoc(mysql_query("SHOW TABLE STATUS LIKE 'table'"));
echo $auto['auto_increment'];
Where 'table' is the name of the table.

Answer 3

if in YII, then Yii::app()->db->lastInsertID is possible;
if in MySQL, then you can use the SELECT LAST_INSERT_ID() function;