Re: can't drop tmp table

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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
20030417115726.61066.qmail@pb1.pair.com">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
>
>
>



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux