It incorrect in the manual.
On Sep 24, 10:27 am, Johann Spies <[email protected]> wrote: > 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
