>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) Cheers....Fish ----------------------- ~~Second Life addict ~~ -----Original Message----- >From: "roger.maynard" <[EMAIL PROTECTED]> >Sent: Aug 15, 2008 9:50 AM >To: [email protected] >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: [email protected] >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]
