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

[omiossec]

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

[MarionMck]

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.

[MarionMck]

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!

[hmaldonado]

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

www.phpmyadmin.net