How to obtain next id in mysql

SELECT Auto_increment FROM information_schema.tables WHERE table_name='the_table_you_want';