List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:July 4 1999 4:12am
Subject:Re: select * from database.table doesn't work
View as plain text  
At 12:08 AM -0400 7/4/1999, Jon E. Mitchiner wrote:
>Im having some problems with mysql and selecting from a different
>database.table.
>
>For instance, Im opening mysql from the command line and doing something
>like:
>
>$ mysql database
>Reading table information for completion of table and column names
>You can turn off this feature to get a quicker startup with -A
>
>Welcome to the MySQL monitor.  Commands end with ; or \g.
>Your MySQL connection id is 14 to server version: 3.21.33b
>
>Type 'help' for help.
>
>mysql> select * from mysql.user;
>ERROR 1017: Can't find file: 'user.frm' (errno: 2)
>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 user;
>+-------------------+-----------+------------------+-------------+----------
>---+-------------+-------------+-------------+-----------+-------------+----
>-----------+--------------+-----------+
>| Host              | User      | Password         | Select_priv |
>Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv |
>Reload_priv | Shutdown_priv | Process_priv | File_priv |
>+-------------------+-----------+------------------+-------------+----------
>---+-------------+-------------+-------------+-----------+-------------+----
>-----------+--------------+-----------+
>
>It then displays the user list without any problems.
>
>So naturally I'm a bit confused here why the first command doesnt work, but
>if I use the 'use mysql' and then manually switch, it then works.
>
>What can I do in order to be able to use "select * from database.table"?


Use a newer version of MySQL.

--
Paul DuBois, paul@stripped
Northern League Chronicles: http://www.snake.net/nl/
Thread
select * from database.table doesn't workJon E. Mitchiner4 Jul
  • Re: select * from database.table doesn't workPaul DuBois4 Jul
  • Re: select * from database.table doesn't workDarrell Shifflett4 Jul