Hi, Jigal
Thanks a lot. It works.
> Xiaobo Chen wrote:
>> Hi, all
>>
>> I am trying to use this with error:
>>
>> drop temporary tabel temp_a if exists 'temp_a';
>>
>> it said syntax error.
>
> Try:
>
> DROP TEMPORARY TABLE IF EXISTS `temp_a`;
>
> ('table' instead of 'tabel'; table name only once; backticks around
> table name instead of quotes)
>
> http://dev.mysql.com/doc/refman/5.0/en/drop-table.html
>
> Regards, Jigal.
>
--
Faculty of Computer Science
Dalhousie University
Halifax, Nova Scotia
Canada
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
