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

[Marc Delisle]

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...

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.

Marc