RE: [PHP-DB] How to Erase MySQL table.

2004-04-20 Thread Uzi Klein
Hi everyone, I can not find in my manual a MySQL command which erase permanently a table and it's content from a MySQL database. - DROM TABLE 'tbl_name'; Thanks in advance Charalambos _ MSN 8 helps eliminate e-mail

RE: [PHP-DB] How to Erase MySQL table.

2004-04-20 Thread Lalit Goyal
I hope the following will solve the purpose mysql_query( Drop Table 'Table name'); regards, Lalit Goyal -Original Message- From: Uzi Klein [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 20, 2004 2:44 PM To: 'charalambos nicolaou'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] How to Erase

Re: [PHP-DB] How to Erase MySQL table.

2004-04-19 Thread Daniel Clark
TRUNCATE table xxx will delete all the rows of data. DROP table xxx will delete the table. Hi everyone, I can not find in my manual a MySQL command which erase permanently a table and it?s content from a MySQL database. Thanks in advance Charalambos