Emi, it appears in 3.23 your limit is 16 MB.  In 4.0 and later, it is 1 GB.

http://dev.mysql.com/doc/refman/4.1/en/packet-too-large.html

Dan



On 8/23/06, Emi Lu <[EMAIL PROTECTED]> wrote:
Hello,

Just curious to know whether Mysql 3.23 has any length constraint about
where part, such as


Query =
[
select col1, col2, ... coln
from table 1, table2,
where

constraint1 + constraint2 +................................constraintN
]

Is there any length arrange for the Query str such as 500M, 1G, etc? Or
the query can be as long as it is.

Thanks a lot!


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to