I’ve been working on a backend for a personal project and it uses sqlite3 with the mattn/go-sqlite3 driver. Basically there’s a table called
tutors created with the following:
CREATE TABLE IF NOT EXISTS tutors( id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, firstname VARCHAR NOT NULL, lastname VARCHAR NOT NULL, email VARCHAR NOT NULL );
And so far I got the
READ functions working. I’ve now been working on the
DELETE request of a tutor. As of now, it does deletes a
tutor; but all the other
tutors aren’t updating their
id's. What can I do to update the
id's of other
tutors after deleting one?
Also, if there are any other general remarks on the project that you would give, please go ahead! I’m super open-minded and constantly looking to learn.