List:General Discussion« Previous MessageNext Message »
From:roger.maynard Date:August 15 2008 1:50pm
Subject:RE: DROP TABLE IF EXISTS - doesnt??
View as plain text  
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

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