Re: temporary table issue

[Jigal van Hemert]

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