Results 1 to 2 of 2

Thread: MYSQL Error

  1. #1

    Thread Starter
    Fanatic Member
    Join Date
    Mar 2008
    Posts
    790

    MYSQL Error

    I have a query that uses a bunch of joins, and this is the error I get:

    Code:
    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
    I can post the query if it'll help, but I cannot find any info on what the error means or how to resolve it.

    Thanks.

  2. #2
    Frenzied Member
    Join Date
    May 2006
    Location
    some place in the cloud
    Posts
    1,886

    Re: MYSQL Error

    Here is something that could help --->
    http://stackoverflow.com/questions/9...ql-big-selects
    JG


    ... If your problem is fixed don't forget to mark your threads as resolved using the Thread Tools menu ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width