// /how-to-get-the-next-auto-increment-number-in-mysql

How to get the Next Auto Increment number in MySQL

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 !

/* Nov 21, 2011 */ ~1 min read

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 !