Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

mySQL 4.1.2 Length of query?? Expand / Collapse
Author
Message
Posted Tuesday, April 7, 2009 4:43 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, April 7, 2009 8:57 AM
Points: 1, Visits: 2
I'm creating a query with a lot of AND's after the WHERE, but i've noticed that they are not all working. I dont get an error though, i'm just not getting the result that i need.
Post #691834
Posted Tuesday, April 7, 2009 5:24 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 1:30 PM
Points: 12,918, Visits: 32,089
i had to google this, because i didn't know either;
http://lists.mysql.com/mysql/187971
you can find out your current setting with this comand
SHOW VARIABLES LIKE 'max_allowed_packet'; 
+--------------------+---------+
¦ Variable_name......¦ Value...¦
+--------------------+---------+
¦ max_allowed_packet ¦ 1047552 ¦
+--------------------+---------+


> Does anyone know if there's a maximum query length in mysql 4.1.x?
>
> Thanks!


The max is the length of your "max_allowed_packet" setting. You can up it
permanently or only when needed in order to deal with queries up to either
16MB or 1GB (depending on your version).

http://dev.mysql.com/doc/mysql/en/server-system-variables.html
http://dev.mysql.com/doc/mysql/en/program-options.html




Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #691853
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse