MySQL method to get the next self-increment (ID) value in a table

Mysql:get Next auto_increment value from/for tablenote to Self:to Get the next auto_increment value from a table run this query: SELECT AUTO_INCREMENT FROM information_schema.TABLES WHERE TABLE_SCHEMA = $dbName AND TABLE_NAME = $tblName. Don ' t forget it ( again).

Take notes for yourself: Get the next self-increment from the table as long as you run the following SQL statement:
AUTO_INCREMENT FROM information_schema.TABLES WHERE TABLE_SCHEMA = $dbName AND TABLE_NAME = $tblName;

For example:
SELECT auto_increment from Information_schema. ' TABLES ' WHERE table_schema= ' my_db_name ' and table_name= ' My_table_name ' ;

MySQL method to get the next self-increment (ID) value in a table