List:General Discussion« Previous MessageNext Message »
From:Oliver Hirschi Date:September 13 2004 9:29am
Subject:IN operator
View as plain text  
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

IN operatorOliver Hirschi13 Sep