执行查询报: Incorrect key file for table ‘test’; try to repair it
报错信息如下:程序没有错误,但执行会报错,错误定在执行语句上
查了一下资料
网上的解决办法,亲试可用:
mysql> use news;
Database changed
mysql> repair table news_detail;
+------------------+--------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+------------------+--------+----------+----------+
| news.news_detail | repair | status | OK |
+------------------+--------+----------+----------+
1 row in set (0.37 sec)
mysql> repair table news_category;
+--------------------+--------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+--------------------+--------+----------+----------+
| news.news_category | repair | status | OK |
+--------------------+--------+----------+----------+
1 row in set (0.02 sec)
如果您认为阅读这篇博客让您有些收获,不妨点击一下右下角的【推荐】
本文版权归作者和博客园共有,欢迎转载