Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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: Today @ 9:21 AM
Points: 14,308, Visits: 37,376
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

--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
Post #691853
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse