SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 09:18 PM
| ||||
| ||||
 Re: How to delete all rows.... 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 Doug@Apley.com On Sep 20, 2006, at 2:55 AM, Peter Lauri wrote: > 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=DSims@apley.com      |
Linear Mode
