1 echo create table t1
(f1 varchar
(20),f2 varchar
(30));
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
9 ---------------------------------------------------------
11 ---------------------------------------------------------
18 echo select * from t1 where f1
='CSQL4' or f1
='CSQL2';
19 ---------------------------------------------------------
21 ---------------------------------------------------------
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 ---------------------------------------------------------
30 ---------------------------------------------------------
37 echo delete from t1 where f1
in ('CSQL1','CSQL3','CSQL5');
38 Statement Executed
: Rows Affected
= 3
39 echo select * from t1
;
40 ---------------------------------------------------------
42 ---------------------------------------------------------
46 <Table Information of all tables
>
48 <TableName
> t1
</TableName
>
50 <FieldName
> f1
</FieldName
>
53 <Primary
> 0 </Primary
>
55 <Default
> 0 </Default
>
56 <DefaultValue
> </DefaultValue
>
59 <FieldName
> f2
</FieldName
>
62 <Primary
> 0 </Primary
>
64 <Default
> 0 </Default
>
65 <DefaultValue
> </DefaultValue
>
68 </Table Information of all tables
>
69 <Index Information of all Indexs
>
70 </Index Information of all Indexs
>