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