Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- InnoDB + AUTO_INCREMENT questions.
- Phil Latio
April 25, 2006, 9:04 am
rate this thread
Re: InnoDB + AUTO_INCREMENT questions.
False. The next row inserted into a table with an AUTO_INCREMENT column
generates a new value, the next in the sequence higher than the last
value that was generated for that column. Note that this could leave
gaps, if you have deleted rows in the meantime.
The database remembers which value was last generated per table, even
after a reboot.
Note that AUTO_INCREMENT can be declared only for an indexed integer
column, of which columns with PRIMARY KEY or UNIQUE constraints are
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum