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
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