Lines Matching refs:test1
19 create table test1(id integer primary key,a);
22 select test1.id as id,a as a,b as b
23 from test1 join test2 on test2.id = test1.id;
26 insert into test1 (id,a) values (NEW.id,NEW.a);
30 select * from test1;
43 select * from test1;
56 update test1 set a=NEW.a where id=NEW.id;
60 select * from test1;
73 select * from test1;
102 select * from test1;
109 select * from test1;