Z odpowiedzią

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

Chris Matus 7 lat temu Ostatnio zmodyfikowane przez Adam Mościcki 5 lat temu 4
I have not figured out how do I auto increment after making a primary key an int.
Thanks a lot!
Znak zadowolenia przez Chris Matus 7 lat temu
  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.