How do i use the UPDATE statement to update a range of Primary Key id
numbers. (let say 100 through 1000).
Example,
UPDATE testTable set testField='9999' WHERE
test_id in (100:1000);
> how about
>
> UPDATE testTable set testField='9999' WHERE
> test_id >= 100 and test_id <= 1000;
or just:
expr BETWEEN min AND max
http://www.mysql.com/doc/en/Comparison_Operators.html#IDX1156
--
Sebastian Mendel
www.sebastianmendel.de
www.tekkno4u.de
www.nofetish.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]