RE: DROP TABLE IF EXISTS - doesnt??
>Maybe what I am seeing in the Query Browser area is in fact a Warning >message and not an error!! Ahhh...yes maybe that's it. Just fyi, here is the detail of the warning: mysql> drop table if exists recipes; Query OK, 0 rows affected, 1 warning (0.00 sec) mysql> SHOW WARNINGS; +---+--+-+ | Level | Code | Message | +---+--+-+ | Note | 1051 | Unknown table 'recipes' | +---+--+-+ 1 row in set (0.00 sec) CheersFish --- ~~Second Life addict ~~ -Original Message- >From: "roger.maynard" <[EMAIL PROTECTED]> >Sent: Aug 15, 2008 9:50 AM >To: mysql@lists.mysql.com >Subject: RE: DROP TABLE IF EXISTS - doesnt?? > >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] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: DROP TABLE IF EXISTS - doesnt??
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
RE: DROP TABLE IF EXISTS - doesnt??
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]
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]
DROP TABLE IF EXISTS - doesnt??
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?