Hi Folks
Under MySQL V 4.1.* I have found that:
$dbh -> do('drop database x')
$dbh -> do('create database x')
leads - via DBIx::SQLEngine (at least) - to losing the connexion to the
database, so after the drop & crete, it is not possible to create tables.
The create fails with:
Error: DBIx::SQLEngine Query failed ...
DBD::mysql::st execute failed: No database selected ...
where the ... means I have chopped some text.
At MySQL's web site, I went thru the changes for all versions 4.1.0 .. 4.1.8
and 4.1.x, but did not see anything relating to this change in behaviour.
This is with DBD::mysql V 2.9003.
You have been warned ;-).
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 16/11/2004
http://savage.net.au/index.html
