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

Attachment: [application/x-pkcs7-signature] S/MIME Cryptographic Signature smime.p7s
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