1 echo CREATE TABLE t1
(f1 INT
, f2 INT
, f3 INT
, f4 INT
, f5 INT
, f6 INT
, f7 INT
, f8 INT
, f9 INT
, f10 INT
, f11 INT
, f12 INT
, f13 INT
, f14 INT
, f15 INT
, f16 INT
, f17 INT
, f18 INT
, f19 INT
, f20 INT
, f21 INT
, f22 INT
, f23 INT
, f24 INT
, f25 INT
, f26 INT
, f27 INT
, f28 INT
, f29 INT
, f30 INT
, f31 INT
, f32 INT
, f33 INT
, f34 INT
, f35 INT
, f36 INT
, f37 INT
);
3 echo insert into t1 values
(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37);
4 Statement Executed
: Rows Affected
= 1
5 echo insert into t1 values
(2,2,3,4,5,6,7,8,9,10,NULL
,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37);
6 Statement Executed
: Rows Affected
= 1
7 echo insert into t1 values
(3,2,3,4,5,6,7,8,9,10,11,NULL
,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37);
8 Statement Executed
: Rows Affected
= 1
9 echo insert into t1 values
(4,2,3,4,5,6,7,8,9,10,11,12,NULL
,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37);
10 Statement Executed
: Rows Affected
= 1
11 echo insert into t1 values
(5,2,3,4,5,6,7,8,9,10,11,12,13,NULL
,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37);
12 Statement Executed
: Rows Affected
= 1
13 echo insert into t1 values
(6,2,3,4,5,6,7,8,9,10,11,12,13,14,NULL
,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37);
14 Statement Executed
: Rows Affected
= 1
15 echo select * from t1
;
16 ---------------------------------------------------------
17 t1.f1 t1.f2 t1.f3 t1.f4 t1.f5 t1.f6 t1.f7 t1.f8 t1.f9 t1.f10 t1.f11 t1.f12 t1.f13 t1.f14 t1.f15 t1.f16 t1.f17 t1.f18 t1.f19 t1.f20 t1.f21 t1.f22 t1.f23 t1.f24 t1.f25 t1.f26 t1.f27 t1.f28 t1.f29 t1.f30 t1.f31 t1.f32 t1.f33 t1.f34 t1.f35 t1.f36 t1.f37
18 ---------------------------------------------------------
19 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
20 2 2 3 4 5 6 7 8 9 10 NULL
12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
21 3 2 3 4 5 6 7 8 9 10 11 NULL
13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
22 4 2 3 4 5 6 7 8 9 10 11 12 NULL
14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
23 5 2 3 4 5 6 7 8 9 10 11 12 13 NULL
15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
24 6 2 3 4 5 6 7 8 9 10 11 12 13 14 NULL
16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
26 echo select * from t1 where f11 is NOT NULL
;
27 ---------------------------------------------------------
28 t1.f1 t1.f2 t1.f3 t1.f4 t1.f5 t1.f6 t1.f7 t1.f8 t1.f9 t1.f10 t1.f11 t1.f12 t1.f13 t1.f14 t1.f15 t1.f16 t1.f17 t1.f18 t1.f19 t1.f20 t1.f21 t1.f22 t1.f23 t1.f24 t1.f25 t1.f26 t1.f27 t1.f28 t1.f29 t1.f30 t1.f31 t1.f32 t1.f33 t1.f34 t1.f35 t1.f36 t1.f37
29 ---------------------------------------------------------
30 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
31 3 2 3 4 5 6 7 8 9 10 11 NULL
13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
32 4 2 3 4 5 6 7 8 9 10 11 12 NULL
14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
33 5 2 3 4 5 6 7 8 9 10 11 12 13 NULL
15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
34 6 2 3 4 5 6 7 8 9 10 11 12 13 14 NULL
16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
36 echo select * from t1 where f13 is NULL
;
37 ---------------------------------------------------------
38 t1.f1 t1.f2 t1.f3 t1.f4 t1.f5 t1.f6 t1.f7 t1.f8 t1.f9 t1.f10 t1.f11 t1.f12 t1.f13 t1.f14 t1.f15 t1.f16 t1.f17 t1.f18 t1.f19 t1.f20 t1.f21 t1.f22 t1.f23 t1.f24 t1.f25 t1.f26 t1.f27 t1.f28 t1.f29 t1.f30 t1.f31 t1.f32 t1.f33 t1.f34 t1.f35 t1.f36 t1.f37
39 ---------------------------------------------------------
40 4 2 3 4 5 6 7 8 9 10 11 12 NULL
14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
42 echo update t1
set f33
=NULL where f14 is NOT NULL
;
43 Statement Executed
: Rows Affected
= 5
44 echo select * from t1
;
45 ---------------------------------------------------------
46 t1.f1 t1.f2 t1.f3 t1.f4 t1.f5 t1.f6 t1.f7 t1.f8 t1.f9 t1.f10 t1.f11 t1.f12 t1.f13 t1.f14 t1.f15 t1.f16 t1.f17 t1.f18 t1.f19 t1.f20 t1.f21 t1.f22 t1.f23 t1.f24 t1.f25 t1.f26 t1.f27 t1.f28 t1.f29 t1.f30 t1.f31 t1.f32 t1.f33 t1.f34 t1.f35 t1.f36 t1.f37
47 ---------------------------------------------------------
48 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 NULL
34 35 36 37
49 2 2 3 4 5 6 7 8 9 10 NULL
12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 NULL
34 35 36 37
50 3 2 3 4 5 6 7 8 9 10 11 NULL
13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 NULL
34 35 36 37
51 4 2 3 4 5 6 7 8 9 10 11 12 NULL
14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 NULL
34 35 36 37
52 5 2 3 4 5 6 7 8 9 10 11 12 13 NULL
15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
53 6 2 3 4 5 6 7 8 9 10 11 12 13 14 NULL
16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 NULL
34 35 36 37
55 echo update t1
set f3
=NULL where f13 is NULL
;
56 Statement Executed
: Rows Affected
= 1
57 echo select * from t1
;
58 ---------------------------------------------------------
59 t1.f1 t1.f2 t1.f3 t1.f4 t1.f5 t1.f6 t1.f7 t1.f8 t1.f9 t1.f10 t1.f11 t1.f12 t1.f13 t1.f14 t1.f15 t1.f16 t1.f17 t1.f18 t1.f19 t1.f20 t1.f21 t1.f22 t1.f23 t1.f24 t1.f25 t1.f26 t1.f27 t1.f28 t1.f29 t1.f30 t1.f31 t1.f32 t1.f33 t1.f34 t1.f35 t1.f36 t1.f37
60 ---------------------------------------------------------
61 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 NULL
34 35 36 37
62 2 2 3 4 5 6 7 8 9 10 NULL
12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 NULL
34 35 36 37
63 3 2 3 4 5 6 7 8 9 10 11 NULL
13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 NULL
34 35 36 37
64 4 2 NULL
4 5 6 7 8 9 10 11 12 NULL
14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 NULL
34 35 36 37
65 5 2 3 4 5 6 7 8 9 10 11 12 13 NULL
15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
66 6 2 3 4 5 6 7 8 9 10 11 12 13 14 NULL
16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 NULL
34 35 36 37