[Phpmyadmin-devel] AUTO_INCREMENT next value and MySQL 5.0.23+
Marc.Delisle at cegepsherbrooke.qc.ca
Mon Jul 31 18:36:14 CEST 2006
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
>> 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...
I just checked in the (not released) 5.0.25 and mysqldump always export
with this AUTO_INCREMENT clause. AFAIK we cannot avoid it in mysqldump.
More information about the Developers