I'm trying to run a MySQL query that attempts to insert data into 40 or so columns in a table. It is to do with property, so apart from address details the table information is mainly entered into y/n enum columns, set as non-null and a default value of n; the form also defaults to n if a drop menu is ignored.
I am getting error 1064, with the following explanation:
"Big Query - Query not stored completely in memory"
I've looked in the MySQL documentation on their website, but a search for "query length" got no hits.
Has anyone encountered this, got any ideas on how to solve the problem. In the interim I guess I'll have to turn all the enum fields to allow nulls and try doing the query in an insert statement followed by an update one.
Blu
