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

Marc Delisle Marc.Delisle at cegepsherbrooke.qc.ca
Mon Jul 31 16:47:29 CEST 2006

Marc Delisle a écrit :
> Michal Čihař a écrit :
>> Hi Marc and others
>> On Sun, 30 Jul 2006 08:00:03 -0400
>> Marc Delisle <Marc.Delisle at cegepsherbrooke.qc.ca> wrote:
>>> 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 
>>> operations.
>>> 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.
>> The problem is that we reuse the code from export and there we probably
>> want checkbox for AUTO_INCREMENT...
> You mean, even if MySQL 5.0.23+ now already adds AUTO_INCREMENT? So you 
> see a situation in export where a user would not want to AUTO_INCREMENT 
> next value?

So you see a situation in export where a user would not want to see the 
AUTO_INCREMENT next value in the exported file?


More information about the Developers mailing list