You might also look at TRUNCATE table...
http://dev.mysql.com/doc/refman/5.0/en/truncate.html
I believe that DELETE will not reclaim the storage space while
TRUNCATE does, although I didn't see that in the documentation when I
looked just now... ?
Douglas Sims
[EMAIL PROTECTED]
On Sep 20, 2006, at 2:55 AM, Peter Lauri wrote:
DELETE FROM table
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
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/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]