MySql运行情况如下,我的数据库文件是从一台计算机拷贝到另外一台计算机上面的~show tables可以看到表,但是select就提示表不存在,请教怎么回事?Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> use news;
Database changed
mysql> show tables;
+----------------+
| Tables_in_news |
+----------------+
| link |
| manager |
| message |
| news |
| news_agency |
| news_man |
| news_type |
| user |
+----------------+
8 rows in set (0.01 sec)mysql> select * from news;
ERROR 1146 (42S02): Table 'news.news' doesn't exist
mysql> select * from user;
ERROR 1146 (42S02): Table 'news.user' doesn't exist
mysql>
Database changed
mysql> show tables;
+----------------+
| Tables_in_news |
+----------------+
| link |
| manager |
| message |
| news |
| news_agency |
| news_man |
| news_type |
| user |
+----------------+
8 rows in set (0.01 sec)mysql> select * from news;
ERROR 1146 (42S02): Table 'news.news' doesn't exist
mysql> select * from user;
ERROR 1146 (42S02): Table 'news.user' doesn't exist
mysql>
当您的问题得到解答后请及时结贴.
http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html