紧急求助

Question

mysql> show tables;
+-----------------------+
| Tables_in_trainticket |
+-----------------------+
| railway               |
| salereturnticket      |
| surrogatesaleticket   |
| tickettable           |
| trainstage            |
| trainstation          |
| user                  |
+-----------------------+
7 rows in set (0.06 sec)mysql> select * from user;
ERROR 1146 (42S02): Table 'trainticket.user' doesn't exist
这是为什么。。怎么解决大侠们帮帮忙

Answer 1

情况比较复杂http://cache.baidu.com/c?m=9f65cb4a8c8507ed4fece763104e842e400797634b878e482ac3933f94670a071a71e3cc767f4f19d9c7776503ae545debf230713d1765eadb9e871d9dfbcf6838885637731a825612a21fafdc47558037912aebaf0ee7cbe733e0b9d2a29907039404&p=8063c11386cc45ae07fbc7710a0d&user=baidu&fm=sc&query=ERROR+1146+%2842S02%29%3A+Table&qid=f06a3f09474b454b&p1=10

Answer 2

检查你的数据库目录下有些什么文件？ user.frm ? 如果没有user.myd 则说明数据文件不存在。只在表定义文件。