I have a clarification on autoincrement function in a PK column. I created a data model/table with autoincrement enabled to a PK column and the initial autoincrement is starting from 1.
To test the table in MySQL database, I inserted 10 rows and by default PK column assigned with the sequence number 1 to 10. In turn I tried inserting another row to see if the autoincrement works by selecting the next sequence number 11, instead it picked some other random number. I think I am missing something here while creating data model.
- In Table options I could see a list of Row Format, from the list I picked "Dynamic". Please confirm if this it correct or which option I should pick from the drop down for autoincrement. Screenshot attached.
- Please let me know what needs to be enabled in data model to pick correct sequence number in the autoincrement PK column.