1 echo Create table t1
(f1 int
, f2 varchar
(15) default
'CSQL');
3 echo insert into t1 values
(1,'Lakshya1');
4 Statement Executed
: Rows Affected
= 1
5 echo insert into t1 values
(2,NULL
);
6 Statement Executed
: Rows Affected
= 1
7 echo insert into t1 values
(3,'Lakshya3');
8 Statement Executed
: Rows Affected
= 1
9 echo insert into t1 values
(4,NULL
);
10 Statement Executed
: Rows Affected
= 1
11 echo insert into t1
(f1
) values
(5);
12 Statement Executed
: Rows Affected
= 1
13 echo select * from t1
;
14 ---------------------------------------------------------
16 ---------------------------------------------------------
23 echo select * from t1 where f2
='CSQL';
24 ---------------------------------------------------------
26 ---------------------------------------------------------
29 echo update t1
set f2
=NULL where f2
='Lakshya3';
30 Statement Executed
: Rows Affected
= 1
31 echo select * from t1
;
32 ---------------------------------------------------------
34 ---------------------------------------------------------
41 echo select * from t1 where f2 IS NULL
;
42 ---------------------------------------------------------
44 ---------------------------------------------------------
49 <Table Information of all tables
>
51 <TableName
> t1
</TableName
>
53 <FieldName
> f1
</FieldName
>
56 <Primary
> 0 </Primary
>
58 <Default
> 0 </Default
>
59 <DefaultValue
> </DefaultValue
>
62 <FieldName
> f2
</FieldName
>
65 <Primary
> 0 </Primary
>
67 <Default
> 1 </Default
>
68 <DefaultValue
> CSQL
</DefaultValue
>
71 </Table Information of all tables
>
72 <Index Information of all Indexs
>
73 </Index Information of all Indexs
>