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

[Michal Čihař]

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

-- 
	Michal Čihař | http://cihar.com | http://blog.cihar.com
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
URL: <http://lists.phpmyadmin.net/pipermail/developers/attachments/20060731/6f40d507/attachment.sig>