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

[Marc Delisle]

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?

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

Marc