Why is mysql adding a postfix to my USE request? I know that test.test 
doesn't exist, i don't want it to, i'm not asking for anything.anything why 
will it append this suffix to my request?

mysql> show databases;
+----------+
| Database |
+----------+
| mysql    |
| test     |
+----------+
2 rows in set (0.00 sec)

mysql> use test;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> select * from test;
ERROR 1146: Table 'test.test' doesn't exist
mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> select * from mysql
    -> ;
ERROR 1146: Table 'mysql.mysql' doesn't exist


The database directories do exist and are populated:
/var/lib/mysql/mysql
/var/lib/mysql/test

I have searched the mysql site for a listing for error 1146 with no luck, 
probably an oversight on my part but any insight is appreciated.

-david

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to