错误代码 1146 表 '<table_name>'不存在 MySql 错误 [英] Error code 1146 Table &#39;&lt;table_name&gt;&#39; doesn&#39;t exist MySql error

问题描述

我正在尝试运行这个查询 3-4 次，但突然间它的执行抛出错误 -

I am trying to run this query which worked 3-4 times but all of a sudden its execution is throwing errors -

Error Code: 1146
Table 'bugs.PROFILES' doesn't exist

突然出现什么问题?

我也做了RESET QUERY CACHE 但没有成功.

I also did RESET QUERY CACHE but no luck.

下面是查询 -

SELECT b.bug_id                           AS Bug_Id, 
       b.bug_status                       AS STATUS, 
       b.resolution                       AS Resolution, 
       q.realname                         AS Reporter, 
       p.realname                         AS Assigned_To, 
       b.short_desc                       AS Summary, 
       DATE_FORMAT(b.deadline, '%m/%d/%Y')AS Deadline 
FROM   bugs b 
       INNER JOIN PROFILES p 
               ON b.assigned_to = p.userid 
       INNER JOIN PROFILES q 
               ON b.reporter = q.userid 
WHERE  ( bug_status IN ( 'RESOLVED', 'VERIFIED', 'INTEST', 'REOPENED' ) 
         AND short_desc NOT LIKE '%Program:%' 
         AND deadline BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 30 DAY) 
       ) 
        OR ( bug_status IN ( 'RESOLVED', 'VERIFIED', 'INTEST' ) 
             AND short_desc NOT LIKE '%Program:%' 
             AND deadline BETWEEN DATE_SUB(CURDATE(), INTERVAL 30 DAY) AND 
                                  CURDATE() ) 
ORDER  BY bug_status ASC 

有什么建议吗?

表 bugs.profiles 确实存在.

The table bugs.profiles does exist.

推荐答案

它告诉你 bugs.PROFILES 表不存在.在bugs 数据库、PROFILES 表中手动检查.或者通过使用 SHOW TABLES

It's tell you that bugs.PROFILES table doesn't exist. Check it manually in bugs database, PROFILES table. Or by using SHOW TABLES

当您将数据库移动到新位置或更新您的 mysql 服务器时，您的表可能会丢失.

There are possibility your tables missing when you are moving database to new location or updating your mysql server.

这篇关于错误代码 1146 表 '<table_name>'不存在 MySql 错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！