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`;



http://dev.mysql.com/doc/refman/5.0/en/drop-table.html

Regards, Jigal.

('table' instead of 'tabel'; table name only once; backticks around table name instead of quotes)

smime.p7s
Description: S/MIME Cryptographic Signature