Lines Matching refs:id

24     create table test1(id integer primary key,a);
25     create table test2(id integer,b);
27       select test1.id as id,a as a,b as b
28       from test1 join test2 on test2.id =  test1.id;
31         insert into test1 (id,a) values (NEW.id,NEW.a);
32         insert into test2 (id,b) values (NEW.id,NEW.b);
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;
112     create table test2(id,b);
126     update test set b=99 where id=7;