>From: david [mailto:[EMAIL PROTECTED]] >Sent: Saturday, August 10, 2002 1:42 PM >Subject: ERROR 1146: Table 'test.test' doesn't exist - Why is mysql adding a postfix to my USE request? > >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 is using the full syntax for accessing a table, which is database.table. So for the database xx , accessing the table yy, it would be xx.yy. >From the commands used below, the reason you're getting an error is probably because you really don't have a table called 'test' in the 'test' database. As you note, you have the database directory for both test and mySQL, but I'd bet you don't have a table file called 'test' under the 'test' directory. Essentially you're trying to select from a non existent table, and mySQL is showing you how it's interpreted the table you wanted from your SQL query, in this case test.test. >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 --------------------------------------------------------------------- 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