Hi Walt, all!
walt wrote:
Is this something new with mysql 5, a bug, or something I'm missing? I'm not able to switch databases.
A known bug (#14504 and others) in handling the separator at the end of a "use" statement, see
http://bugs.mysql.com/bug.php?id=14504
mysql> CREATE DATABASE FOO; Query OK, 1 row affected (0.00 sec) [[...]] mysql> use FOO; ERROR 1049 (42000): Unknown database 'FOO;' mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | FOO | | mysql | | test | +--------------------+ 4 rows in set (0.06 sec)
Do without the semicolon (for now): use FOO HTH, Joerg -- Joerg Bruehe, Senior Production Engineer MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]