drizzle-discuss team mailing list archive
Mailing list archive
Re: SHOW CREATE and AUTO_INCREMENT
On Tue, 29 Jun 2010 11:50:09 +0200, Kristian Nielsen <knielsen@xxxxxxxxxxxxxxx> wrote:
> I guess you could argue from this that the current value of AUTO_INCREMENT
> should be shown, not the one from CREATE TABLE. But it is not 100% clear
> (since INSERT/UPDATE can also change it). The main thing I dislike with
> AUTO_INCREMENT is precisely that the semantics are too complicated and/or
> unclear (well, that and the fact that people use it too much).
You know the behaviour differs between engines, right?
I know all that code as good as anyone and I still have no idea about
what the correct semantics should be.