1 create table t1(f1 int,f2 int,f3 int,f4 char(10),primary key(f1));
2 insert into t1 values(98,1,10,'AAA');
3 insert into t1 values(99,2,20,'BBB');
4 insert into t1 values(100,3,30,'CCC');
5 insert into t1 values(101,4,40,'AAA');
6 insert into t1 values(102,5,50,'BBB');