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]
