Lines Matching refs:test1
24 create table test1(id integer primary key,a);
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);
35 select * from test1;
48 select * from test1;
61 update test1 set a=NEW.a where id=NEW.id;
65 select * from test1;
78 select * from test1;
107 select * from test1;
114 select * from test1;