Hi there, I used very likely statement last week to update one table. My IN value is around 20. I checked the manual and there is nothing about any limitation on IN values. However, when i was running it, it worked very well sometimes, while sometimes, the query crashed in the middle and i have to REPAIR table. I've not figure out the reason of the crash yet. but i think you should be aware of it.
Monet --- Oliver Hirschi <[EMAIL PROTECTED]> wrote: > 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] > > _______________________________ Do you Yahoo!? Declare Yourself - Register online to vote today! http://vote.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
