I should also mention that this error is only happening using the mysql C API ( mysql_query() ). If i use mysql client and paste the exact same query, i get the proper result everything.
thanks, paul > hello, > > When I perform a large union query with 11 tables I often get this error: > > Lost connection to MySQL server during query > > If I shorten the query to say, 3 or 4 tables, I never get that error. The > thing is, the large 11 table union query works sometimes, probably 3 out of > 5. > > Any ideas? > > Regards, > > paul > > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php