[Phpmyadmin-devel] AUTO_INCREMENT next value and MySQL 5.0.23+
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...
Size: 189 bytes
Desc: not available
More information about the Developers