How to get next auto increment value with query on MySQL September 17, 2015 by admin The following select query returns next auto increment value: SELECT AUTO_INCREMENT FROM information_schema.TABLES WHERE TABLE_SCHEMA = "db_name" AND TABLE_NAME = "table_name"