Re: Still can't drop tmp table
| From: | Doug Thompson | Date: | Fri, 18 Apr 2003 14:41:52 +0000 |
| Subject: | Re: Still can't drop tmp table | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-27167@lists.php.net to get a copy of this message | ||
I have seen this on 3.23.x and 4.0.x mysql, too.
DROP TABLE temp_tablename;
works OK.
Any further discussion should go to mysql list.
Good luck,
Doug
On Fri, 18 Apr 2003 09:53:03 +0200, Merlin wrote:
>Hi there,
>
>somehow the syntax explained on mysql to drop a tmp table is wrong. The db
>returns wrong statement.
>
>Has anybody the same problems??
>
>Thanx 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]
>
>
>-------------------------------
>Worldwide Travel Community
>http://www.globosapiens.net
>
>
>
>
>--
>PHP Database Mailing List (http://www.php.net/)
>To unsubscribe, visit: http://www.php.net/unsub.php
>