On Sat, Apr 26, 2003 at 01:54:10PM -0500, Raymond Norton wrote: > > > If you delete all the entries from the table, your next insert > > will start with id "1". > > I thought that too. I had 39 entries. Deleted 38. Changed the remaining id > to "1", but the next entry had a number 0f "40" > Yes, that's the behavior I see too. [a little googling happens] OK, try "set insert_id = 2;", this works for me. -- trammell at el-swifto.com 9EC7 BC6D E688 A184 9F58 FD4C 2C12 CC14 8ABA 36F5 Twin Cities Linux Users Group (TCLUG) Minneapolis/St. Paul, Minnesota _______________________________________________ TCLUG Mailing List - Minneapolis/St. Paul, Minnesota http://www.mn-linux.org tclug-list at mn-linux.org https://mailman.real-time.com/mailman/listinfo/tclug-list