问题描述: 用 root 用户名 进入操作,显示所有的表,没问题,但是查询就会报Table '*******' doesn't exist该库中所有表均是如此.新建表,再查询没有问题,如我新建的表myseal.test其它库不存在这个问题.操作如下:mysql> use myseal;
Database changed
mysql> show tables;
+----------------------+
| Tables_in_myseal |
+----------------------+
| cert_tbl |
| corpinfo_tbl |
| log_tbl |
| newuser |
| printinfo_tbl |
| purview_sealuser_tbl |
| seal_mag |
| seal_sign |
| seal_tbl |
| sign_tbl |
| sys_user_mag |
| test |
| user |
| user_info |
| user_order |
| userinfo_tbl |
+----------------------+
16 rows in set (0.00 sec)mysql> select * from test
-> ;
+------+------+
| a | b |
+------+------+
| 1 | 1 |
+------+------+
1 row in set (0.00 sec)mysql> describe user;
ERROR 1146 (42S02): Table 'myseal.user' doesn't exist
mysql> select * from user;
ERROR 1146 (42S02): Table 'myseal.user' doesn't exist请大家帮忙.根据大家的建议的贡献程度我会给相应的分数!谢谢
Database changed
mysql> show tables;
+----------------------+
| Tables_in_myseal |
+----------------------+
| cert_tbl |
| corpinfo_tbl |
| log_tbl |
| newuser |
| printinfo_tbl |
| purview_sealuser_tbl |
| seal_mag |
| seal_sign |
| seal_tbl |
| sign_tbl |
| sys_user_mag |
| test |
| user |
| user_info |
| user_order |
| userinfo_tbl |
+----------------------+
16 rows in set (0.00 sec)mysql> select * from test
-> ;
+------+------+
| a | b |
+------+------+
| 1 | 1 |
+------+------+
1 row in set (0.00 sec)mysql> describe user;
ERROR 1146 (42S02): Table 'myseal.user' doesn't exist
mysql> select * from user;
ERROR 1146 (42S02): Table 'myseal.user' doesn't exist请大家帮忙.根据大家的建议的贡献程度我会给相应的分数!谢谢
解决方案 »
- 多表连接查询,求助,使用树形结构。
- mysql的主从问题 从服务器对数据库修改不会影响主的数据库么?
- MySQL 执行SQL语句时 ,显示query ok,1 warning.如何显示warning具体内容
- 高分!!!linux先忙mysql重启问题,报错:Starting MySQL../etc/init.d/mysql: line 159: kill: (4267) - No such process。
- 两表联查的一个问题
- mysql 下遇到unauthenticated user的问题
- 如何把mysql的数据导入postgresql中
- mysql 连接查询的问题
- 请问你的PHP是应用在WIN平台还是UNIX平台,MYSQL在WIN平台上不是要付费的吗?
- 程序定时查询mysql,时间长报错10060错误
- Postgresql 性能和SQL SERVER比怎么样?
- 100分跪求如何mysql全文索引查询所用关键词最小长度限制
mysql>SELECT * FROM `user`;
chown mysql:mysql var -R