0
Besvaret

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

Chris Matus 9 år siden opdateret af Adam Mościcki 7 år siden 4
I have not figured out how do I auto increment after making a primary key an int.
GOD, JEG ER TILFREDS
Thanks a lot!
Tilfredshedsangivelse af Chris Matus 9 år siden
+2
  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.

Hello,


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



Hope this helps.


Kundesupport af UserEcho