test/tools/csql/exp.test003.ksh

   1 echo UPDATE and DELETE testing;
   2 Statement Executed
   3 Statement Executed: Rows Affected = 1
   4 Statement Executed: Rows Affected = 1
   5 Statement Executed: Rows Affected = 1
   6 Statement Executed: Rows Affected = 1
   7 Statement Executed: Rows Affected = 1
   8 Statement Executed: Rows Affected = 1
   9 echo select * from t1;
  10 ---------------------------------------------------------
  11         t1.f1   t1.f2
  12 ---------------------------------------------------------
  13         10      20
  14         11      21
  15         12      22
  16         13      23
  17         14      24
  18         50      50
  19
  20 echo select * from t1 where f1 = 100;
  21 ---------------------------------------------------------
  22         t1.f1   t1.f2
  23 ---------------------------------------------------------
  24         50      50
  25
  26 echo update t1 set f2 = 100;
  27 Statement Executed: Rows Affected = 6
  28 echo select * from t1;
  29 ---------------------------------------------------------
  30         t1.f1   t1.f2
  31 ---------------------------------------------------------
  32         10      100
  33         11      100
  34         12      100
  35         13      100
  36         14      100
  37         50      100
  38
  39 echo update t1 set f2 = 200 where f1 =50;
  40 Statement Executed: Rows Affected = 1
  41 echo select * from t1;
  42 ---------------------------------------------------------
  43         t1.f1   t1.f2
  44 ---------------------------------------------------------
  45         10      100
  46         11      100
  47         12      100
  48         13      100
  49         14      100
  50         50      200
  51
  52 echo delete from t1 where f1 = 50;
  53 Statement Executed: Rows Affected = 1
  54 echo select * from t1;
  55 ---------------------------------------------------------
  56         t1.f1   t1.f2
  57 ---------------------------------------------------------
  58         10      100
  59         11      100
  60         12      100
  61         13      100
  62         14      100
  63
  64 echo delete from t1;
  65 Statement Executed: Rows Affected = 5
  66 echo select * from t1;
  67 ---------------------------------------------------------
  68         t1.f1   t1.f2
  69 ---------------------------------------------------------
  70
  71 Statement Executed