SQL:UPDATE [Table]...BETWEEN...AND

更新資料表資料內容與限定條件範圍:

範例01:

UPDATE multimedias
SET noid01 = 39
WHERE id BETWEEN 124 AND 127;
--------------------------------------
UPDATE 4

範例02:

update table set "col_name"='1221' where id='1111';