[SapMan]

Well I'm creating a SQlite property system but I have a problem with the id's when I use the / create home command, the house is created just like in the db, every house is assigned an id (as if it were userid) what happens is that if I delete a property from the db suppose that if I delete the house id 1 then when I recreate a house does not assign an available id this case the id 1 is not created if it does not give the id 3. I hope I have explained well, I hope you can help me, thanks.

what I mean is: that if I create a house and there is an id available then it is created in the id (slot).

Note: I'm using INTEGER PRIMARY KEY AUTOINCREMENT

[Kampott]

If you're using PhpMyAdmin, go to the operations tab and change "AUTO_INCREMENT" to the value you need,
or, if you can only execute sql code, use this:

Код:

ALTER TABLE  `the name of your table` AUTO_INCREMENT =needed auto increment value