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

Chris Matus 7 year бұрын updated by Adam Mościcki 5 year бұрын 4
I have not figured out how do I auto increment after making a primary key an int.
Thanks a lot!
Satisfaction mark by Chris Matus 7 year бұрын
  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.