Completed

MySQL: Display an error if there are multiple AUTO_INCREMENT fields defined in a table.

7 years ago • updated by 7 years ago • 2

If there are multiple fields defined with AUTO_INCREMENT set, MySQL (and maybe other databases) throw an error:
CREATE TABLE test (

id int NOT NULL AUTO_INCREMENT,
otherthing int NOT NULL AUTO_INCREMENT
)

#1075 - Incorrect table definition; there can be only one auto column and it must be defined as a key

Vote

GOOD, I'M SATISFIED

Satisfaction mark

Satisfaction mark by 7 years ago

Planned

You're right. We'll add this validation.

Completed

The validation is now available in Vertabelo.