MySQL: “The SELECT would examine more than MAX_JOIN_SIZE rows”

by

When using PHP, SQL_BIG_SELECTS=1 should be set in a separate query before your main query. For example:

$mysqli = new mysqli("localhost", "root", "password", "db"); 

$mysqli->query("SET SQL_BIG_SELECTS=1");  //Set it before your main query

$results = $mysqli->query("SELECT a, b, c FROM test");
while($row = $results->fetch_assoc()){
    echo '<pre>';
    print_r ($row);
    echo '</pre>';
}

More Related Contents:

  1. How can I do a FULL OUTER JOIN in MySQL?
  2. INNER JOIN ON vs WHERE clause
  3. Join vs. sub-query
  4. Subqueries vs joins
  5. Is there something wrong with joins that don’t use the JOIN keyword in SQL or MySQL?
  6. Why does this SQL code give error 1066 (Not unique table/alias: ‘user’)?
  7. In SQL / MySQL, what is the difference between “ON” and “WHERE” in a join statement?
  8. MySQL – Selecting data from multiple tables all with same structure but different data
  9. MySQL: GROUP_CONCAT with LEFT JOIN
  10. How to display data in JOIN, and return null value? [closed]
  11. You can’t specify target table for update in FROM clause
  12. SQL to LINQ with multiple join, count and left join
  13. How do I make a row generator in MySQL?
  14. MySQL INSERT INTO table VALUES.. vs INSERT INTO table SET
  15. MySQL number of items within “in clause”
  16. Oracle “(+)” Operator
  17. Error 1046 No database Selected, how to resolve?
  18. JOIN two SELECT statement results
  19. What’s the difference between VARCHAR and CHAR?
  20. single fixed table with multiple columns vs flexible abstract tables
  21. Mixing implicit and explicit JOINs
  22. MySQL remove duplicates from big database quick
  23. How to delete Duplicates in MySQL table
  24. Selecting Random Rows in MySQL
  25. Difference between RIGHT & LEFT JOIN vs RIGHT & LEFT OUTER JOIN in SQL [duplicate]
  26. MySQL Inner Join Query Multiple Tables
  27. Error: The used SELECT statements have a different number of columns
  28. Mysql strip time component from datetime
  29. SQL Inner Join On Null Values
  30. How do MySQL views work?

Leave a Comment