Since you do not seem to have subqueries available to you (pre 4.1.x), have you looked at modifying your queries to use JOINs, temp tables, or both?
What is it you are trying to accomplish, we can help you to build the appropriate statement(s). Optionally, you can upgrade to a version that supports subqueries (4.1+). Shawn Green Database Administrator Unimin Corporation - Spruce Pine news <[EMAIL PROTECTED]> wrote on 09/13/2004 05:29:28 AM: > Hi people > > Due to MySQL does not support "inner-selects", I generate a string (I > programm java-client) with the values I used in an IN-operator for an > update onto a mySQL database. > > The statement looks like this: > UPDATE layer SET State=1 > WHERE fpObjectID IN (1,3,4,5,20,34,56,24,56,11,45) > > Now, the question came up if there is a maximum of values or length in > an IN operator which can used on mySQL? > > Does anybody know something about that? > > Thanks & Regards > -- > Oliver Hirschi > http://www.FamilyHirschi.ch > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >
