2013-03-19, 23:39
What am I doing wrong !?
The databases appear to have been made, but I cannot get a count from them.
Help!
Code:
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| master usermusic32 |
| master uservideo75 |
| mysql |
| performance_schema |
| test |
+--------------------+
6 rows in set (0.08 sec)
mysql> select count(*) from master uservideo75.movie;
ERROR 1046 (3D000): No database selected
mysql> select count(*) from master uservideo75.tvshow;
ERROR 1046 (3D000): No database selected
mysql> select count(*) from master usermusic32;
ERROR 1046 (3D000): No database selected
mysql>
The databases appear to have been made, but I cannot get a count from them.
Help!