MySQL Lists: mysql: DROP TABLE IF EXISTS

List:	General Discussion	« Previous Message Next Message »
From:	roger.maynard	Date:	August 15 2008 9:20am
Subject:	DROP TABLE IF EXISTS - doesnt??
View as plain text

I am finding that 

 

DROP TABLE IF EXISTS mytable;

 

Works fine if the table exists - but if it doesn't exist I get an error?


 

Surely it should not error and just not try to drop the table.

 

Is it me?

Thread
• DROP TABLE IF EXISTS - doesnt??	roger.maynard	15 Aug
• Re: DROP TABLE IF EXISTS - doesnt??	Fish Kungfu	15 Aug
• RE: DROP TABLE IF EXISTS - doesnt??	roger.maynard	15 Aug
• RE: DROP TABLE IF EXISTS - doesnt??	Martin Gainty	15 Aug
• RE: DROP TABLE IF EXISTS - doesnt??	Fish Kungfu	15 Aug