Well, I have sent queries over 4 times as long without difficulty, so I do not think you are coming up against a limit on query length. I would not use MySQL 5 for any production or even development machines, as a development tree is not even guaranteed to work.
Regards, Mike Hillyer www.vbmysql.com > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Monday, July 07, 2003 8:13 AM > To: [EMAIL PROTECTED] > Subject: My query string might be too long > > > Is there a line limit to a query in MySQL? ( I couldn't find > this in the MySQL > manual) > Here is my query: > SELECT a.field_name, b.field_option, c.project_name > FROM field_master a, field_options_master b, project_master c > where a.field_option_id = b.id and > a.project_id=b.project_id and > a.project_id='1' and c.id='1' and > field_name='State' > > If I try to put this all on one line (in MySQL Control > Center), the line stops > at a.project_id=b.project_. > In my Java code, I have this query all on one line, but it > fails. Do I have to > try and put in hard breaks? > > I would prefer to have a stored procedure and send the stored > proc. parameters. > I see that a development tree of 5.0 is available now. 5.0 > has stored procedure > support in it. Maybe I should bite the bullet and install 5.0? > > Do you know when 5.0 is scheduled for production release? > > Thanks, > Kevin > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?> [EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
