Large insert.
Posted by: Kevin D
Date: May 17, 2011 05:51PM

Hi,

I am using 'mysql_real_query' to execute a sql query that consists of a large number of insert statements (2000) that each have a lot of LONGTEXT fields. The total query is 2MB. The query executes successfully under MySQL workbench. But returns a 'MySQL server has gone away' error when executed programatically.
Does 'mysql_real_query' have limits to the size of the query that it can execute?

Thanks,

Kevin.

Options: ReplyQuote


Subject
Views
Written By
Posted
Large insert.
1215
May 17, 2011 05:51PM
784
August 07, 2011 11:39PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.