test/tools/csql/exp.test070.ksh

   1 echo create table t1(f1 int not null,f2 int,f3 int);
   2 Statement Executed
   3 echo insert into t1 values(1,2,3);
   4 Statement Executed: Rows Affected = 1
   5 echo insert into t1 values(10,20,30);
   6 Statement Executed: Rows Affected = 1
   7 echo insert into t1 values(100,200,300);
   8 Statement Executed: Rows Affected = 1
   9 echo insert into t1 values(1000,2000,3000);
  10 Statement Executed: Rows Affected = 1
  11 echo select * from t1;
  12 ---------------------------------------------------------
  13         t1.f1   t1.f2   t1.f3
  14 ---------------------------------------------------------
  15         1       2       3
  16         10      20      30
  17         100     200     300
  18         1000    2000    3000
  19
  20 echo update t1 set f2=3333, f3=4444 where f1>=100;
  21 Statement Executed: Rows Affected = 2
  22 echo select * from t1;
  23 ---------------------------------------------------------
  24         t1.f1   t1.f2   t1.f3
  25 ---------------------------------------------------------
  26         1       2       3
  27         10      20      30
  28         100     3333    4444
  29         1000    3333    4444
  30
  31 Statement Executed