test/sql/Datatype/exp.test010.ksh

   1 echo create table t1(f1 varchar(20),f2 varchar(30));
   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 echo select * from t1;
   9 ---------------------------------------------------------
  10         t1.f1   t1.f2
  11 ---------------------------------------------------------
  12         CSQL1   Lakshya1
  13         CSQL2   Lakshya2
  14         CSQL3   Lakshya3
  15         CSQL4   Lakshya4
  16         CSQL5   Lakshya5
  17
  18 echo select * from t1 where f1='CSQL4' or f1='CSQL2';
  19 ---------------------------------------------------------
  20         t1.f1   t1.f2
  21 ---------------------------------------------------------
  22         CSQL2   Lakshya2
  23         CSQL4   Lakshya4
  24
  25 echo update t1 set f2='LAKSHYA' where f1='CSQL2' or f1='CSQL4';
  26 Statement Executed: Rows Affected = 2
  27 echo select * from t1;
  28 ---------------------------------------------------------
  29         t1.f1   t1.f2
  30 ---------------------------------------------------------
  31         CSQL1   Lakshya1
  32         CSQL2   LAKSHYA
  33         CSQL3   Lakshya3
  34         CSQL4   LAKSHYA
  35         CSQL5   Lakshya5
  36
  37 echo delete from t1 where f1 in ('CSQL1','CSQL3','CSQL5');
  38 Statement Executed: Rows Affected = 3
  39 echo select * from t1;
  40 ---------------------------------------------------------
  41         t1.f1   t1.f2
  42 ---------------------------------------------------------
  43         CSQL2   LAKSHYA
  44         CSQL4   LAKSHYA
  45
  46 <Table Information of all tables>
  47   <TableInfo>
  48     <TableName> t1 </TableName>
  49       <FieldInfo>
  50         <FieldName> f1 </FieldName>
  51         <Type> 32 </Type>
  52         <Length> 20 </Length>
  53         <Primary> 0 </Primary>
  54         <Null> 0 </Null>
  55         <Default> 0 </Default>
  56         <DefaultValue>  </DefaultValue>
  57       </FieldInfo>
  58       <FieldInfo>
  59         <FieldName> f2 </FieldName>
  60         <Type> 32 </Type>
  61         <Length> 32 </Length>
  62         <Primary> 0 </Primary>
  63         <Null> 0 </Null>
  64         <Default> 0 </Default>
  65         <DefaultValue>  </DefaultValue>
  66       </FieldInfo>
  67   </TableInfo>
  68 </Table Information of all tables>
  69 <Index Information of all Indexs>
  70 </Index Information of all Indexs>
  71 Statement Executed