mySQL 4.1.2 Length of query??

• pansylea

  Grasshopper

  Points: 17

  More actions

  April 7, 2009 at 4:43 am

  #201797

  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.

• Lowell

  SSC Guru

  Points: 323522

  More actions

  April 7, 2009 at 5:24 am

  #973222

  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!