Michal Čihař a écrit :
Hi Marc and others
On Sun, 30 Jul 2006 08:00:03 -0400 Marc Delisle Marc.Delisle@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