[Phpmyadmin-devel] AUTO_INCREMENT next value and MySQL 5.0.23+

Marc Delisle Marc.Delisle at cegepsherbrooke.qc.ca
Sun Jul 30 14:00:03 CEST 2006

starting with MySQL 5.0.23, SHOW CREATE TABLE includes the 
AUTO_INCREMENT next value, just after the ENGINE clause.

We had a "Add AUTO_INCREMENT value" option in table operations and db 

So I suggest:

- for 5.0.23+, the "Add AUTO_INCREMENT value" checkbox be removed from 
table operations and db operations dialogs. The same functionality is 
now being provided automatically in the CREATE TABLE statement

- for 5.0.22-, I would also prefer to remove these checkboxes

For all MySQL versions, I guess that during a copy, the majority of 
users want to copy also the AUTO_INCREMENT value. If it's not the case, 
they can always go to the copied table on Operations and change the 
value in "Table options".

If we still want to provide this checkbox, well for 5.0.23+ we would 
have to examine the statement and remove the AUTO_INCREMENT clause.


More information about the Developers mailing list