SQLite 3.39

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select sqlite_version();


sqlite_version()


3.39.1


CREATE TABLE test1(a INTEGER PRIMARY KEY, b TEXT DEFAULT 'b', c TEXT DEFAULT 'c');
✓
INSERT INTO test1 DEFAULT VALUES;
✓
SELECT * FROM test1;


a
b
c


1
b
c


INSERT INTO test1 (b, c) VALUES ('beta', NULL), (NULL, 'cetha');
✓
SELECT * FROM test1;


a
b
c


1
b
c

2
beta
null

3
null
cetha

a	b	c
1	b	c
2	beta	null
3	null	cetha