When adding an item to my mysql table, I needed to get the ID for the next inserted row. \u00a0The ID is just an auto increment column in the table. \u00a0At first I had:<\/p>\n
select max(table_id) + 1 as next_table_id from tablename<\/pre>\nI quickly realized how wrong that was. \u00a0When inserting ids 1, 2, 3, 4 and then deleting ID 4, my “next ID” query would return 4 instead of 5. \u00a0The MAX ID for a table\u00a0varies depending on what is currently in the table and is not a reliable source for the next inserted ID.<\/p>\n
<\/p>\n
Solution:<\/h2>\n
The query to use is:<\/p>\n
select auto_increment\nfrom information_schema.TABLES\nwhere TABLE_NAME='tablename'\nand TABLE_SCHEMA='basename'<\/pre>\n<\/p>\n
An alternative solution is to use<\/p>\n
SHOW TABLE STATUS WHERE name='tablename'<\/pre>\n