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]
