Re: Maximum query size

Mark wrote: Is there an easy way to determine the largest sql query I can pass between a perl/C app to my MySQL database? It seems to wig out around the 1 meg range but without resorting to trial and error I'm not sure how to get an exact figure. the max size would be limited by the variable max_a

Re: Maximum query size

The default maximum packet size is 1 meg. You can check your current server setting with: SHOW VARIABLES LIKE 'max_allowed_packet'; See "A.2.9 Packet too large Error" for directions to change this setting in the server and client. Michael

Maximum query size

Is there an easy way to determine the largest sql query I can pass between a perl/C app to my MySQL database? It seems to wig out around the 1 meg range but without resorting to trial and error I'm not sure how to get an exact figure. Thanks, Mark. -- MySQL General Mailing List For list archiv

MYSQL maximum query size?

-Original Message- From: Phil Schwarzmann [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 4:02 PM To: [EMAIL PROTECTED] Subject: [PHP] MYSQL maximum query size? Is there a maximum number of characters you can use in a query? I have a giant query using the UPDATE command