What are you trying to do here? MySQL is giving this error because the table 'test' does not exist in the 'test' database. Are you mistaking database for tables? I think perhaps you need to take a look more carefully at the manual about creating tables.
Mike ----- Original Message ----- From: "david" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, August 10, 2002 8: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> 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 > > --------------------------------------------------------------------- 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
