Get next AUTO INCREMENT value from a mysql table

SELECT AUTO_INCREMENT as 'next_id' FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'db_name' AND TABLE_NAME = 'table_name';