SEO

Sorry, did not read carefully.

Either you loop thru all tables an do "DELETE FROM table"

Or as someone else suggested, dump the structure, drop database, recreate
from dump.

/Peter

-----Original Message-----
From: Peter Lauri [mailto:lists@dwsasia.com]
Sent: Wednesday, September 20, 2006 2:56 PM
To: ravi.karatagi@wipro.com; mysql@lists.mysql.com
Subject: RE: How to delete all rows....

DELETE FROM table

-----Original Message-----
From: ravi.karatagi@wipro.com [mailto:ravi.karatagi@wipro.com]
Sent: Wednesday, September 20, 2006 10:35 AM
To: mysql@lists.mysql.com
Subject: How to delete all rows....


Hi All,

How do I delete all the rows of all the tables(but not
table) in the database at one shot.




Regards,

Ravi K







The information contained in this electronic message and any attachments to
this message are intended for the exclusive use of the addressee(s) and may
contain proprietary, confidential or privileged information. If you are not
the intended recipient, you should not disseminate, distribute or copy this
e-mail. Please notify the sender immediately and destroy all copies of this
message and any attachments.


WARNING: Computer viruses can be transmitted via email. The recipient should
check this email and any attachments for the presence of viruses. The
company accepts no liability for any damage caused by any virus transmitted
by this email.


www.wipro.com


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=lists@dwsasia.com