Error while sending QUERY packet

by

You guessed right MySQL have limitation for size of data, you need to break your query in small group of records or you can Change your max_allowed_packet by using SET GLOBAL max_allowed_packet=524288000;

More Related Contents:

  1. Query database then email posts from where user is subbed to
  2. Laravel – only a zero is saved to the database
  3. storing user_id in session variable
  4. I am seeing this error on submitting form Error: query was empty [closed]
  5. Reference: What is a perfect code sample using the MySQL extension? [closed]
  6. Convert from MySQL datetime to another format with PHP
  7. Correct way to use LIKE ‘%{$var}%’ with prepared statements?
  8. Passing an array to a query using a WHERE clause
  9. Whether to use “SET NAMES”
  10. Escaping single quote in PHP when inserting into MySQL [duplicate]
  11. PHP/MySQL Insert null values
  12. How can I get enum possible values in a MySQL database?
  13. Mechanisms for tracking DB schema changes [closed]
  14. Inserting data using mysqli
  15. Import file size limit in PHPMyAdmin
  16. PDO Connection Test
  17. Php : Convert a blob into an image file
  18. Detect mysql update/insertion failure due to violated unique constraint
  19. PHP + MySql + Stored Procedures, how do I get access an “out” value?
  20. How do I construct a cross database query in PHP?
  21. How to bind SQL variables in PHP?
  22. Having issue with matching rows in the database
  23. PHP – Secure member-only pages with a login system
  24. MySQL ORDER BY IN()
  25. mysql – INSERT date range into date columns IF dates don’t overlap with existing ones
  26. PHP mySQL – Insert new record into table with auto-increment on primary key
  27. How does {} affect a MySQL Query in PHP? [duplicate]
  28. When should I close a database connection in PHP?
  29. php connection pooling mysql [duplicate]
  30. Limit pagination page number

Leave a Comment