MySQL from python - dropping a database IF EXISTS

[Ben]

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]

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

[Fredrik Lundh]

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>