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
|• IN operator||Oliver Hirschi||13 Sep|