A3Cw29tN

1.nullvalue NULL
2.headers on
3.mode qbox
4
5DROP TABLE IF EXISTS test;
6
7CREATE TABLE IF NOT EXISTS test (
8	id INTEGER NOT NULL PRIMARY KEY,
9    date TEXT NOT NULL,
10   	numb INTEGER,
11    sub_n TEXT NOT NULL ON CONFLICT REPLACE DEFAULT "",
12	year_n INTEGER NOT NULL,
13	UNIQUE(numb, sub_n, year_n)
14);
15
16INSERT INTO test VALUES(NULL, '2023-12-08', 1, NULL, 2023);
17INSERT INTO test VALUES(NULL, '2023-12-08', 2, NULL, 2023);
18INSERT INTO test VALUES(NULL, '2023-12-09', 3, NULL, 2023);
19INSERT INTO test VALUES(NULL, '2023-12-09', NULL, NULL, 2023);
20INSERT INTO test VALUES(NULL, '2023-12-09', NULL, NULL, 2023);
21--INSERT INTO test VALUES(NULL, '2023-12-09', 3, NULL, 2023);
22INSERT INTO test VALUES(NULL, '2023-12-09', 3, 'A', 2023);
23
24SELECT * FROM test;