Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2003
    Posts
    3

    Unanswered: limit to length of an sql statement

    Does MySQL impose a limit to the length of an sql statement?

    I seem to be hitting a limit of 255 characters. Can this be changed?

  2. #2
    Join Date
    Jan 2003
    Location
    Paris, France
    Posts
    320

    Re: limit to length of an sql statement

    Originally posted by MarionMck
    Does MySQL impose a limit to the length of an sql statement?

    I seem to be hitting a limit of 255 characters. Can this be changed?
    There no limit like this (255 char) perhaps this is your tool that make the limit
    Olivier Miossec
    --
    http://www.lasso-developpeur.net/
    --

  3. #3
    Join Date
    Jul 2003
    Posts
    3

    Re: limit to length of an sql statement

    If I use the command line tool mysql.exe, it seems to block key entry after 254 characters. I was originally doing the query via JDBC and this also seemed to fail, which was why I was trying it in the command line tool.

    The query I am doing is quite complex - it must be failing for a different reason. The query is

    select date_format(xx_start, '%d %b %Y %H:%i'), xx_userid, xx_link, date_format(xx_due_date, '%d %b %Y %H:%i'), xx_synopsis, xx_workflowid, xx_tasks.xx_taskid, xx_tasks.xx_elementid, xx_tasks.xx_cdocid
    from xx_tasks, xx_task_recipients
    where ( xx_tasks.xx_workflowid = '1012858233' ) and xx_tasks.xx_taskid = xx_task_recipients.xx_taskid and xx_completedby = null

    I will split it up and check it in the command line tool.

  4. #4
    Join Date
    Jul 2003
    Posts
    3

    Re: limit to length of an sql statement

    Oops! Sorry, should be 'is null' rather than '= null'.

    The command line tool was hitting the limit without keying 'return' to build up a single query.

    Thanks for your input - it's stopped me going off on the wrong track!

  5. #5
    Join Date
    Jun 2003
    Location
    México
    Posts
    5

    Re: limit to length of an sql statement

    Maybe you should change to phpMySQL is a any web-base tool to manage a MySQL server.

    www.phpmyadmin.net

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •