Re: mysql sql query size limit

The closest thing to an absolute limit on query size is the value of the configuration variable max_allowed_packet which defaults to 1 meg. - michael On 4/10/07, Anil D <[EMAIL PROTECTED]> wrote: Hi List, What is the practical limit on size of the sql query in mysql 4.1.x

mysql sql query size limit

Hi List, What is the practical limit on size of the sql query in mysql 4.1.x Anil

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

query size

In the Crash me, it says MySQL support a little more than 1 Million for query size. Is this the max number of records can be retrived from 1 single query? Is there a way to change this? Different setting? Thanks, Vh

Re: Max query size

pgrade to the lastest 3.23.x stable (3.23.33 I guess). Now to your question: The query size is mainly limited by the packet size and that is 1MB, if I remember correctly, but can be changed at compile time (again, IIRC). There is more info in the fine manual about that. Bye,

Max query size

Hello! I was wondering if anyone knows how big a qury can be in MySQL 2.23.14??? Rune Lanton - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archi