Hi Marc and others
On Sun, 30 Jul 2006 08:00:03 -0400
Marc Delisle <Marc.Delisle(a)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?
Marc