Dynamic result in select statement mysql
I could not understand your requirement. Hope it works :

select t.table_schema,t.table_name,t.AUTO_INCREMENT 
from information_schema.TABLES t,information_schema.COLUMNS c
where c.EXTRA = 'auto_increment' and t.table_schema=c.table_schema and t.table_name=c.table_name