List:General Discussion« Previous MessageNext Message »
From:Xiaobo Chen Date:January 10 2006 2:49pm
Subject:Re: temporary table issue
View as plain text  
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

Thread
temporary table issueXiaobo Chen10 Jan
  • Re: temporary table issueJigal van Hemert10 Jan
    • Re: temporary table issueXiaobo Chen10 Jan
    • Re: temporary table issueBen Clewett10 Jan
      • Re: temporary table issueJigal van Hemert10 Jan
        • Re: Geogrphic AdviseBen Clewett10 Jan
  • Re: temporary table issueBill Dodson10 Jan