![](https://cdn.userecho.com/characters/74.png?1)
0
Завершен
MySQL: Display an error if there are multiple AUTO_INCREMENT fields defined in a table.
If there are multiple fields defined with AUTO_INCREMENT set, MySQL (and maybe other databases) throw an error:
CREATE TABLE test (
CREATE TABLE test (
id int NOT NULL AUTO_INCREMENT,
otherthing 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
![](/s/cache/ab/93/ab9307c606031eb0328e808837dbde37.png)
0
Запланирован
Agnieszka Kozubek-Krycuń (Chief Scientist) 10 лет назад
You're right. We'll add this validation.
![](/s/cache/ab/93/ab9307c606031eb0328e808837dbde37.png)
0
Завершен
Agnieszka Kozubek-Krycuń (Chief Scientist) 10 лет назад
The validation is now available in Vertabelo.
Сервис поддержки клиентов работает на платформе UserEcho