mysql - SELECT 将检查超过 MAX_JOIN_SIZE 行

Question

当运行一个连接来自 3 个大表的数据的查询时，我收到一条错误消息

   The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay  

Answer 1

您可以简单地发出包含 SET 命令的查询:

 $this->db->query('SET SQL_BIG_SELECTS=1');