Lines Matching refs:SET

23   set v [catch {execsql {UPDATE test1 SET f2=5 WHERE f1<1}} msg]
31        {execsql {UPDATE sqlite_master SET name='xyz' WHERE name='123'}} msg]
49   set v [catch {execsql {UPDATE test1 SET f1=f3*2 WHERE f2==32}} msg]
53   set v [catch {execsql {UPDATE test1 SET f1=test2.f1*2 WHERE f2==32}} msg]
57   set v [catch {execsql {UPDATE test1 SET f3=f1*2 WHERE f2==32}} msg]
64   execsql {UPDATE test1 SET f2=f2*3}
71   execsql {UPDATE test1 SET f2=f2/3 WHERE f1<=5}
77   execsql {UPDATE test1 SET f2=f2/3 WHERE f1>5}
86   execsql {UPDATE test1 SET F2=f1, F1=f2}
93   execsql {UPDATE test1 SET F2=f1, F1=f2}
113   execsql {UPDATE test1 SET f2=f2+1 WHERE f1==8}
117   execsql {UPDATE test1 SET f2=f2-1 WHERE f1==8 and f2>800}
121   execsql {UPDATE test1 SET f2=f2-1 WHERE f1==8 and f2<800}
125   execsql {UPDATE test1 SET f1=f1+1 WHERE f2==128}
129   execsql {UPDATE test1 SET f1=f1-1 WHERE f1>100 and f2==128}
135     UPDATE test1 SET f1=f1-1 WHERE f1<=100 and f2==128;
152   execsql {UPDATE test1 SET f2=f2+1 WHERE f1==8}
156   execsql {UPDATE test1 SET f2=f2-1 WHERE f1==8 and f2>800}
160   execsql {UPDATE test1 SET f2=f2-1 WHERE f1==8 and f2<800}
164   execsql {UPDATE test1 SET f1=f1+1 WHERE f2==128}
177   execsql {UPDATE test1 SET f1=f1-1 WHERE f1>100 and f2==128}
197     UPDATE test1 SET f1=f1-1 WHERE f1<=100 and f2==128;
228   execsql {UPDATE test1 SET f2=f2+1 WHERE f1==8}
241   execsql {UPDATE test1 SET f2=f2-1 WHERE f1==8 and f2>800}
245   execsql {UPDATE test1 SET f2=f2-1 WHERE f1==8 and f2<800}
258   execsql {UPDATE test1 SET f1=f1+1 WHERE f2==128}
271   execsql {UPDATE test1 SET f1=f1-1 WHERE f1>100 and f2==128}
287   execsql {UPDATE test1 SET f1=f1-1 WHERE f1<=100 and f2==128}
312   execsql {UPDATE test1 SET f2=f2+1 WHERE f1==8}
325   execsql {UPDATE test1 SET f2=f2-1 WHERE f1==8 and f2>800}
329   # explain {UPDATE test1 SET f2=f2-1 WHERE f1==8 and F2<300}
330   execsql {UPDATE test1 SET f2=f2-1 WHERE f1==8 and f2<800}
343   execsql {UPDATE test1 SET f1=f1+1 WHERE f2==128}
356   execsql {UPDATE test1 SET f1=f1-1 WHERE f1>100 and f2==128}
372   execsql {UPDATE test1 SET f1=f1-1 WHERE f1<=100 and f2==128}
392     UPDATE test1 SET x=11 WHERE f1=1025
398     UPDATE test1 SET f1=x(11) WHERE f1=1025
404     UPDATE test1 SET f1=11 WHERE x=1025
410     UPDATE test1 SET f1=11 WHERE x(f1)=1025
435     UPDATE t1 SET a=1, e=9 WHERE f=6;
441     UPDATE t1 SET a=1, e=10 WHERE f=7;
452     UPDATE t1 SET b=2, e=11 WHERE f=6;
458     UPDATE t1 SET b=2, e=12 WHERE f=7;
469     UPDATE t1 SET c=3, d=4, e=13 WHERE f=6;
475     UPDATE t1 SET c=3, d=4, e=14 WHERE f=7;
489     UPDATE t1 SET e=e+1 WHERE b IN (SELECT b FROM t1);
495     UPDATE t1 SET e=e+1 WHERE a IN (SELECT a FROM t1);
532     UPDATE t2 SET rowid=rowid-1;
538     UPDATE t2 SET rowid=rowid+10000;
539     UPDATE t2 SET rowid=rowid-9999;
555     UPDATE t2 SET rowid=rowid-1;