Error: 1116 - SQLSTATE: HY000 ER_TOO_MANY_TABLES

March 11th, 2009
Goto solutions Leave a solution
  • Share
  • Share

Description:
Message: Too many tables; MySQL can only use %d tables in a join

MySql-Server , , , ,

  1. admin
    April 8th, 2009 at 15:20 | #1
    Reply | Quote

    Double check your data model. Instead of one big query, try to use multiple queries, fetch the results and place them into a hast list data structure.

  1. No trackbacks yet.