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

Michal Čihař michal at cihar.com
Wed Aug 2 12:28:43 CEST 2006

On Tue, 01 Aug 2006 11:20:19 -0400
Marc Delisle <Marc.Delisle at cegepsherbrooke.qc.ca> wrote:

> Michal Čihař a écrit :
> > On Mon, 31 Jul 2006 10:47:29 -0400
> > Marc Delisle <Marc.Delisle at cegepsherbrooke.qc.ca> wrote:
> > 
> >> So you see a situation in export where a user would not want to see the 
> >> AUTO_INCREMENT next value in the exported file?
> > 
> > Well it would be useful not to export auto incremented column at all,
> Ok I'll try to implement the removal of AUTO_INCREMENT clause generated 
> by 5.0.23+ SHOW CREATE TABLE.
> > but will full export there won't be much use for it...
> Sorry I don't follow your point about full export.

Sorry for mess, I will try to rephrase this:

When you export table with all columns, you will most likely want
AUTO_INCREMENT to be included.

However if we'd provide option to export table without auto incremented
column, not exporting AUTO_INCREMENT would be logical.

So I think that it's okay to have AUTO_INCREMENT clause.

	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/20060802/34ad3475/attachment.sig>

More information about the Developers mailing list