kaj,
I bow to your sql-fu! I've never seen a SQL statement that large. (I've
written a few stored procedures that big but good God, not a single
statement.)
To answer your question, I've never seen anything in the documentation that
indicates that such a limit exists. The only thing I can say is try it and
see. But please, by all means, post your results here so we all know if
this works.
=C=
* Cal Evans
* http://www.christianperformer.com
* Stay plugged into your audience
* The measure of a programmer is not the number of lines of code he writes
but the number of lines he does not have to write.
*
----- Original Message -----
From: "Kaj Didriksen" <kaj@stripped>
To: <mysql@stripped>
Sent: Tuesday, May 06, 2003 8:22 AM
Subject: How big can a SELECT be?
Hi
I have a tablestructure that in rare circumstances must be searched via
a SELECT statement that will be of 30-35Kb in size.
I was wondering if this is possible or if I have a max. SELECT size
that cant be expanded. Im using PHP 4.3 by the way to send the SELECT
on an FreeBSD
Regards
Kaj Schermer Didriksen
------------------------------------------------------------------------
----
"New media applications"
macron ApS Telephone: 87959650
Østervænget 5, Assentoft
8900 Randers Web: http://www.macron.dk
Denmark
------------------------------------------------------------------------
---
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=1
