So I recently deleted some rows of my table from the Cloud Database and using a process model, I tried to enter user values via a form. The primary key in my table is ID and the rows that I deleted had ID's = 4, 5
When I entered new values via a form, the new row generated in my table had an ID = 6 and not ID = 4
So how do I make changes in the XSD file so that my ID value starts again from 4 ?
Discussion posts and replies are publicly visible
You have to make changes in the database table itself. Reset your autoincrement to 4 using the following statement (for MariaDB):
ALTER TABLE table_name AUTO_INCREMENT = 4;
Make this statement part of your delete query