I read in the manual: You can truncate the table, i.e., delete all records and reset the counter of the id.
My experience is that it deletes all the records but does not resent the counter of the id. I did the following: Export a table to a csv-file. Truncate the table. db.commit() Edit the csv-file, made corrections and set all the id's to 0. Then I imported the csv-file into the empty table. The id-numbers allocated started at one higher than the previous highest. Has something changed? Regards Johann -- May grace and peace be yours in abundance through the full knowledge of God and of Jesus our Lord! His divine power has given us everything we need for life and godliness through the full knowledge of the one who called us by his own glory and excellence. 2 Pet. 1:2b,3a
