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
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



Group: General Forum Members
Last Login: Today @ 4:45 AM
Points: 14,557, Visits: 38,451
i had to google this, because i didn't know either;
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).


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