List:General Discussion« Previous MessageNext Message »
From:Martin Gainty Date:August 15 2008 1:58pm
Subject:RE: DROP TABLE IF EXISTS - doesnt??
View as plain text  
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: roger.maynard@stripped
> To: mysql@stripped
> 
> 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:fish.kungfu@stripped] 
> Sent: 15 August 2008 12:43
> To: mysql@stripped
> 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/mysql?unsub=1
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
> 

_________________________________________________________________
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
Thread
DROP TABLE IF EXISTS - doesnt??roger.maynard15 Aug
  • Re: DROP TABLE IF EXISTS - doesnt??Fish Kungfu15 Aug
RE: DROP TABLE IF EXISTS - doesnt??roger.maynard15 Aug
  • RE: DROP TABLE IF EXISTS - doesnt??Martin Gainty15 Aug
RE: DROP TABLE IF EXISTS - doesnt??Fish Kungfu15 Aug