How to get the Next Auto Increment number in MySQL

- by admin

In order to get the next Auto Increment number in MySQL just run:
SHOW TABLE STATUS LIKE '$tablename';

The result would be in `Auto_Increment`.

Voila !