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]

Reply via email to