Re[2]: [PHP-DB] Empty Table command?

2003-11-27 Thread npguy
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 K

Re: [PHP-DB] Empty Table command?

2003-11-27 Thread Kim Steinhaug
As said yes, you just launch your old fashioned delete from statement, without any where clause, mySQL will interpret this as everything (which is infact what it does, it maches everything and therefor deletes everything). -- Kim Steinhaug -

Re: [PHP-DB] Empty Table command?

2003-11-26 Thread Rasmus Lerdorf
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 for on > MySQL's website (Probably as i'm looking for the wrong term?) I want to know how to > empty a table, is there an empty command

[PHP-DB] Empty Table command?

2003-11-26 Thread Chris Payne
Hi there everyone, Just a quick question which I can't for the life of me find the answer for on MySQL's website (Probably as i'm looking for the wrong term?) I want to know how to empty a table, is there an empty command or should I just tell it to delete everything? Chris