I do a mysql query as below

update table set something = something where onecolumn in ("a","b",etc);

It works well when the array ("a","b",etc) after in is less than 1000, but
when the array ("a","b",etc) contains more than 1000 element, it seem the
command doesn't work. I am not sure whether there is a limitation for
array's elements or it is a bug.

Xinkun Wang
Research Assistant                      Northampton Square
Information Science Dept                London,UK  EC1V 0HB 
City University                         TEL: 0044-20-74778380


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to