Hello Kim, beside deleting, dropping any tips to do this very quickly Friday, November 28, 2003, 1:37:20 AM, you wrote: KS> As said yes, you just launch your old fashioned delete from statement, KS> without KS> any where clause, mySQL will interpret this as everything (which is infact KS> what KS> it does, it maches everything and therefor deletes everything). KS> -- KS> Kim Steinhaug KS> --------------------------------------------------------------- KS> There are 10 types of people when it comes to binary numbers: KS> those who understand them, and those who don't. KS> --------------------------------------------------------------- KS> "Rasmus Lerdorf" <rasmus@xxxxxxx> wrote in message KS> news:Pine.WNT.4.56.0311262104180.3676@xxxxxxx >> delete from table_name >> >> On Wed, 26 Nov 2003, Chris Payne wrote: >> >> > Hi there everyone, >> > >> > Just a quick question which I can't for the life of me find the answer KS> for on MySQL's website (Probably as i'm looking for the wrong term?) I want KS> to know how to empty a table, is there an empty command or should I just KS> tell it to delete everything? >> > >> > Chris -- Best regards, npguy mailto:npguy@xxxxxxxxxxxxxxxx -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php