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]

Reply via email to