Post reply

mySQL 4.1.2 Length of query??

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

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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply