Re: Update Table By ID Ranges

2003-08-01 Thread Cybot
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

Re: Update Table By ID Ranges

2003-07-31 Thread Jeff Mathis
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

Update Table By ID Ranges

2003-07-31 Thread Mike Doanh Tran
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