如何从表中获得增量值

Question

I need to get next id from table (auto_increment).

I could just use SELECT * from table ORDER BY id DESC LIMIT 1;

For example I get 50. But if we delete from table two items I will get 48 but correct one

will be 51. How get correct value even we something delete from table ?

Answer 1

show table status like 'table_name'

next id value is in 'Auto_increment' field