1 echo CREATE TABLE t1
(f1 INT
, f2 VARCHAR
(12));
3 echo INSERT INTO t1 VALUES
(1, 'ABCD');
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, NULL
);
8 Statement Executed
: Rows Affected
= 1
9 echo INSERT INTO t1 VALUES
(4, 'ABCEF');
10 Statement Executed
: Rows Affected
= 1
11 echo INSERT INTO t1
(f1
) VALUES
(5);
12 Statement Executed
: Rows Affected
= 1
13 echo INSERT INTO t1 VALUES
(6, 'ABCFF');
14 Statement Executed
: Rows Affected
= 1
15 echo select * from t1
;
16 ---------------------------------------------------------
18 ---------------------------------------------------------
26 echo select * from t1 where f2 is null
;
27 ---------------------------------------------------------
29 ---------------------------------------------------------
33 echo select * from t1 where f2 is not null
;
34 ---------------------------------------------------------
36 ---------------------------------------------------------