2
DROP TABLE IF EXISTS t1;
4
CREATE TABLE t1(c1 CHAR(100) NULL);
5
INSERT INTO t1 (c1) VALUES('NULL');
6
INSERT INTO t1 (c1) VALUES('');
7
INSERT INTO t1 (c1) VALUES('x');
8
INSERT INTO t1 (c1) VALUES('123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.');
10
SELECT COUNT(c1) AS total_rows FROM t1;
11
SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL;
12
SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL;
14
CREATE TABLE t1(c1 VARCHAR(100) NULL);
15
INSERT INTO t1 (c1) VALUES('NULL');
16
INSERT INTO t1 (c1) VALUES('');
17
INSERT INTO t1 (c1) VALUES('x');
18
INSERT INTO t1 (c1) VALUES('123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.');
20
SELECT COUNT(c1) AS total_rows FROM t1;
21
SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL;
22
SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL;
24
CREATE TABLE t1(c1 BINARY(100) NULL);
25
INSERT INTO t1 (c1) VALUES('NULL');
26
INSERT INTO t1 (c1) VALUES('');
27
INSERT INTO t1 (c1) VALUES('x');
28
INSERT INTO t1 (c1) VALUES('123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.');
30
SELECT COUNT(c1) AS total_rows FROM t1;
31
SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL;
32
SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL;
34
CREATE TABLE t1(c1 VARBINARY(100) NULL);
35
INSERT INTO t1 (c1) VALUES('NULL');
36
INSERT INTO t1 (c1) VALUES('');
37
INSERT INTO t1 (c1) VALUES('x');
38
INSERT INTO t1 (c1) VALUES('123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.');
40
SELECT COUNT(c1) AS total_rows FROM t1;
41
SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL;
42
SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL;
44
CREATE TABLE t1(c1 BLOB(100) NULL);
45
INSERT INTO t1 (c1) VALUES('NULL');
46
INSERT INTO t1 (c1) VALUES('');
47
INSERT INTO t1 (c1) VALUES('x');
48
INSERT INTO t1 (c1) VALUES('123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.');
50
SELECT COUNT(c1) AS total_rows FROM t1;
51
SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL;
52
SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL;
54
CREATE TABLE t1(c1 TEXT(100) NULL);
55
INSERT INTO t1 (c1) VALUES('NULL');
56
INSERT INTO t1 (c1) VALUES('');
57
INSERT INTO t1 (c1) VALUES('x');
58
INSERT INTO t1 (c1) VALUES('123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.');
60
SELECT COUNT(c1) AS total_rows FROM t1;
61
SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL;
62
SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL;