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

[Marc Delisle]

Michal Čihař a écrit :
> 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.

OK I am working on this. 5.0.24 has been released but not yet on the 
mirrors.