MySQL from python - dropping a database IF EXISTS

2006-12-04 Thread 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

Re: MySQL from python - dropping a database IF EXISTS

2006-12-04 Thread 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

Re: MySQL from python - dropping a database IF EXISTS

2006-12-04 Thread 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