Recently, an error was reported in a large table query as follows: error 1104 (42000): the select would examine more than max_ JOIN_ SIZE rows; check your WHERE and use SET SQL_ BIG_ SELECTS=1 or SET MAX_ JOIN_ SIZE=# if the SELECT is okay
Large table 2.8 million lines. The prompt is very clear
I query show variables like ‘% max’_ JOIN_ Size% ‘is 1 million
After modifying according to the prompt, you can query.