[Phpmyadmin-devel] AUTO_INCREMENT next value and MySQL 5.0.23+
michal at cihar.com
Mon Jul 31 16:10:26 CEST 2006
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...
Michal Čihař | http://cihar.com | http://blog.cihar.com
-------------- next part --------------
A non-text attachment was scrubbed...
Size: 189 bytes
Desc: not available
More information about the Developers