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, and would like to "reset" all tables to start at 0 when I make > the app "live". > > Thanks > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]