Re: "reset" id of tables - SOLVED

2003-06-23 Thread Petre Agenbag
Nevermind, found it: truncate table; On Mon, 2003-06-23 at 15:59, Petre Agenbag wrote: > Hi List > > Probably a stupid question, but I want to know if there is a quick way > to reset all the id's on my tables to 0? > I ran a whole bunch of "tests" on the app; writing and deleting to the > tables

"reset" id of tables

2003-06-23 Thread Petre Agenbag
Hi List Probably a stupid question, but I want to know if there is a quick way to reset all the id's on my tables to 0? I ran a whole bunch of "tests" on the app; writing and deleting to the tables, and would like to "reset" all tables to start at 0 when I make the app "live". Thanks -- MySQL