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='' WHERE
test_id in (100:1000);
> how about
>
> UPDATE testTable set testField='' WHERE
> test_id >= 100 and test_id <= 1000;
or just:
expr BET
how about
UPDATE testTable set testField='' WHERE
test_id >= 100 and test_id <= 1000;
Mike Doanh Tran wrote:
>
> Hi,
>
> 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='' WHE
Hi,
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='' WHERE
test_id in (100:1000);
Thanks in advance for any comments,
Mike
--
MySQL General Mailing List
For list archives: http://lis