Re: Maybe There is a Problem about auto_increment_increment

[Peter Brawley]

> create table test(id int not null primary key auto_increment unique)

Primary keys are by definition unique. Lose the redundant "unique" from that cmd.

Auto_increment guarantees uniqueness, not exact sequentiality. If you want the latter, follow the standard practice of preparing a table of desired values, use it to pluck keys when needed.