List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:August 9 2001 11:10pm
Subject:Re: how to erase all data in database (table)
View as plain text  
In the last episode (Aug 09), Dmitry Kashlev said:
> How can I erase all data except for the fields in mysql table? I just want
> to fill all data again in the same table.

TRUNCATE TABLE tablename
or
DELETE * FROM tablename
 



-- 
	Dan Nelson
	dnelson@stripped
Thread
how to erase all data in database (table)Dmitry Kashlev9 Aug
  • Re: how to erase all data in database (table)Bennett Haselton10 Aug
  • Re: how to erase all data in database (table)Dan Nelson10 Aug
  • Re: how to erase all data in database (table)Gerald R. Jensen10 Aug