From: Martin Gainty
Date: August 15 2008 1:58pm
Subject: RE: DROP TABLE IF EXISTS - doesnt??
List-Archive: http://lists.mysql.com/mysql/214121
Message-Id: <BLU142-W20416EFD0CD38FB53998D9AE6D0@phx.gbl>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="_035bd054-1f02-408e-85bb-c3bcf73a9b22_"

--_035bd054-1f02-408e-85bb-c3bcf73a9b22_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


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 de=
limiter=20
(//) instead of =3B

e.g.
use DBNAME=3B
DROP PROCEDURE IF EXISTS TABLE_NAME=3B
delimiter //=3B

Anyone?
Martin=20
______________________________________________=20
Disclaimer and confidentiality note=20
Everything in this e-mail and any attachments relates to the official busin=
ess of Sender. This transmission is of a confidential nature and Sender doe=
s not endorse distribution to any party other than intended recipient. Send=
er does not necessarily endorse content contained within this transmission.=
=20


> Subject: RE: DROP TABLE IF EXISTS - doesnt??
> Date: Fri=2C 15 Aug 2008 14:50:16 +0100
> From: roger.maynard@stripped
> To: mysql@stripped
>=20
> 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.
>=20
> 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. =20
>=20
> Maybe what I am seeing in the Query Browser area is in fact a Warning
> message and not an error!!
>=20
> If so=2C sorry to have wasted anyone's time
>=20
> Regards
>=20
> Roger
>=20
>=20
>=20
>=20
>=20
> -----Original Message-----
> From: Fish Kungfu [mailto:fish.kungfu@stripped]=20
> Sent: 15 August 2008 12:43
> To: mysql@stripped
> Subject: Re: DROP TABLE IF EXISTS - doesnt??
>=20
> Hmmm.  It works okay for me=2C without an error when the tabel doesn't
> exist.
> I'm using mysql Server version 5.0.51a-3ubuntu5.1
>=20
> For example:
> *************************************************
> mysql> use lsldatabase=3B
> Reading table information for completion of table and column names
> You can turn off this feature to get a quicker startup with -A
>=20
> Database changed
> mysql> show tables=3B
> +-----------------------+
> | Tables_in_lsldatabase |
> +-----------------------+
> | lslstore              |
> +-----------------------+
> 1 row in set (0.00 sec)
>=20
> mysql> drop table if exists recipes=3B
> Query OK=2C 0 rows affected=2C 1 warning (0.00 sec)
> *************************************************
> As you see=2C the table "recipes" doesn't already exist=2C and I don't ge=
t=20
> an error.
>=20
>=20
>=20
>=20
>=20
> roger.maynard wrote:
> > I am finding that=20
> >
> > =20
> >
> > DROP TABLE IF EXISTS mytable=3B
> >
> > =20
> >
> > Works fine if the table exists - but if it doesn't exist I get an
> error?
> >
> >
> > =20
> >
> > Surely it should not error and just not try to drop the table.
> >
> > =20
> >
> > Is it me?
> >
> >
>=20
>=20
> --=20
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=3Droger.maynard@stripped
>=20
>=20
> --=20
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=3Dmgainty@stripped=
om
>=20

_________________________________________________________________
Talk to your Yahoo! Friends via Windows Live Messenger.  Find out how.
http://www.windowslive.com/explore/messenger?ocid=3DTXT_TAGLM_WL_messenger_=
yahoo_082008=

--_035bd054-1f02-408e-85bb-c3bcf73a9b22_--