Re: can't drop tmp table
| From: | Merlin | Date: | Thu, 17 Apr 2003 20:51:37 +0000 |
| Subject: | Re: can't drop tmp table | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-27150@lists.php.net to get a copy of this message | ||
Hi Peter,
actually the syntax with temporary is ok. However it does not even work with
out the temporary statement!
Merlin
http://www.mysql.com/doc/en/DROP_TABLE.html
6.5.6 DROP TABLE Syntax
DROP [TEMPORARY] TABLE [IF EXISTS] tbl_name [, tbl_name,...] [RESTRICT |
CASCADE]
"Peter Pistorius" <peterp@podbox.co.za> schrieb im Newsbeitrag
news:20030417115726.61066.qmail@pb1.pair.com...
> DROP TABLE IF EXISTS tbl_name
>
> Not:
>
> DROP TEMPORARY TABLE IF EXISTS tbl_name
>
> Regards,
> Peter "Pod" Pistorius
>
> peterp@podbox.co.za
>
>
>