I am certain the SQLBrowser program authors want to hear about this error It may be due to the fact that MYSQL procedures need to have a different delimiter (//) instead of ;
e.g. use DBNAME; DROP PROCEDURE IF EXISTS TABLE_NAME; delimiter //; Anyone? Martin ______________________________________________ Disclaimer and confidentiality note Everything in this e-mail and any attachments relates to the official business of Sender. This transmission is of a confidential nature and Sender does not endorse distribution to any party other than intended recipient. Sender does not necessarily endorse content contained within this transmission. > Subject: RE: DROP TABLE IF EXISTS - doesnt?? > Date: Fri, 15 Aug 2008 14:50:16 +0100 > From: [EMAIL PROTECTED] > To: mysql@lists.mysql.com > > I am getting this problem when I am calling this from within a stored > procedure and from the command line area but from MySQLQueryBrowser > Windows package. > > I have tried the DROP TABLE IF EXISTS from the mysql "DOS-type" command > line and it doesn't error - I do notice that (also in your example) that > there is a Warning provided. > > Maybe what I am seeing in the Query Browser area is in fact a Warning > message and not an error!! > > If so, sorry to have wasted anyone's time > > Regards > > Roger > > > > > > -----Original Message----- > From: Fish Kungfu [mailto:[EMAIL PROTECTED] > Sent: 15 August 2008 12:43 > To: mysql@lists.mysql.com > Subject: Re: DROP TABLE IF EXISTS - doesnt?? > > Hmmm. It works okay for me, without an error when the tabel doesn't > exist. > I'm using mysql Server version 5.0.51a-3ubuntu5.1 > > For example: > ************************************************* > mysql> use lsldatabase; > Reading table information for completion of table and column names > You can turn off this feature to get a quicker startup with -A > > Database changed > mysql> show tables; > +-----------------------+ > | Tables_in_lsldatabase | > +-----------------------+ > | lslstore | > +-----------------------+ > 1 row in set (0.00 sec) > > mysql> drop table if exists recipes; > Query OK, 0 rows affected, 1 warning (0.00 sec) > ************************************************* > As you see, the table "recipes" doesn't already exist, and I don't get > an error. > > > > > > roger.maynard wrote: > > 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? > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > _________________________________________________________________ Talk to your Yahoo! Friends via Windows Live Messenger. Find out how. http://www.windowslive.com/explore/messenger?ocid=TXT_TAGLM_WL_messenger_yahoo_082008
