Lines Matching refs:SET
113 UPDATE tbl SET a = a * 10, b = b * 10;
203 {UPDATE tbl SET b = old.b;}
207 UPDATE tbl SET c = old.c;
213 set statement {UPDATE tbl SET c = 10 WHERE a = 1;}
333 UPDATE log SET a = a + 1;
338 UPDATE tbl SET b = 1, c = 10; -- 2
339 UPDATE tbl SET b = 10; -- 0
340 UPDATE tbl SET d = 4 WHERE a = 0; --1
341 UPDATE tbl SET a = 4, b = 10; --0
370 UPDATE log SET a = 0;
374 UPDATE log SET a = 0;
378 UPDATE log SET a = 0;
517 UPDATE OR IGNORE tbl SET a = new.a, c = 10;
523 UPDATE tbl SET a = 1 WHERE a = 4;
529 UPDATE OR ABORT tbl SET a = 4 WHERE a = 1;
539 UPDATE OR FAIL tbl SET a = 4 WHERE a = 1;
549 UPDATE OR REPLACE tbl SET a = 1 WHERE a = 4;
561 UPDATE OR ROLLBACK tbl SET a = 4 WHERE a = 1;
618 UPDATE abcd SET a = 100, b = 5*5 WHERE a = 1;
634 UPDATE abcd SET a = 100, b = 5*5 WHERE a = 1;
651 UPDATE abcd SET a = 100, b = 5*5 WHERE a = 1;
712 UPDATE v1 SET x=x+100, y=y+200, z=z+300;