Lines Matching refs:where

61         update test1 set a=NEW.a where id=NEW.id;
62         update test2 set b=NEW.b where id=NEW.id;
64     update test set a=22 where id=1;
77     update test set b=66 where id=4;
102     update test set a=222 where id=1;
126     update test set b=99 where id=7;
141 	  delete from tbl where a = old.a;
144 	  update tbl set a=new.a, b=new.b where a = old.a;
161     execsql {select a, b from vw where a<103 or a>226 order by a}
166     catchsql {delete from vw where a>101 and a<2000}
190     catchsql {update vw set b=b+1000 where a>101 and a<2000}
193     execsql {select a, b from vw where a<=102 or a>=227 order by a}