![]() ![]() I was wondering now, is there a way to have the database memorize every ID that was set earlier and not set the same ID twice, even when the maximum ID is deleted from the database? That works because deleting the most recent row leads to a lower maximum ID in the column, which makes sense to me. The Column increases in value as desired, but if I delete the row with the maximum ID and then add another entry, it will receive the ID which was set already before. Therefore, I'm using a column "testID integer PRIMARY KEY". I'm starting to work with an SQL Database in python and I want to have multiple tables, where I can reference rows in each other's table by ID.
0 Comments
Leave a Reply. |