«

Can someone explain why this might be happening:

parser_beta.py:129: Warning: Can't drop database 'foobar'; database
doesn't exist
self.cursor.execute("DROP DATABASE IF EXISTS "+name)

But the whole point about the "IF EXISTS" bit is (I thought) that it
will only drop it if it exists, if it doesn't do nothing and don't
throw an error.

I'm using MySQL 5.024 and python 2.4.3

It still works, but the unneccesary error is annoying Any ideas?

Cheers,

Ben

Ah well - I turned off warnings as a solution. Its a bit f a bodge, but
it works


Ben wrote:

> Can someone explain why this might be happening:
>
> parser_beta.py:129: Warning: Can't drop database 'foobar'; database
> doesn't exist
> self.cursor.execute("DROP DATABASE IF EXISTS "+name)
>
> But the whole point about the "IF EXISTS" bit is (I thought) that it
> will only drop it if it exists, if it doesn't do nothing and don't
> throw an error.
>
> I'm using MySQL 5.024 and python 2.4.3
>
> It still works, but the unneccesary error is annoying Any ideas?
>
> Cheers,
>
> Ben

Ben wrote:

> Ah well - I turned off warnings as a solution. Its a bit f a bodge, but
> it works

according to the documentation, the database does generate a "note" when
you do this:

http://dev.mysql.com/doc/refman/5.0/en/drop-table.html

and notes can be turned off independently of warnings, it seems:

http://dev.mysql.com/doc/refman/5.0/...-warnings.html

</F>