How can I add AUTO INCREMENT to primary key in my MySQL model in Vertabelo?

Chris Matus 7 лет назад обновлен Adam Mościcki 5 лет назад 4
I have not figured out how do I auto increment after making a primary key an int.
Thanks a lot!
Оценка удовлетворенности от Chris Matus 7 лет назад
  1. Add column in your table.

  2. Mark column as primary key.

  3. Expand column properties by clicking on the down arrow next to the column name.

  4. Set "Auto_increment" property to "Yes".

Is this really available on all databases that support it? I can't get it the show on  a PostgreSQL example, which has the SERIAL notation to support it.


Please write in the `Type` field keyword `serial`. I have checked it and it works as expected.

Hope this helps.

Сервис поддержки клиентов работает на платформе UserEcho