MySQL 8.0

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

CREATE TABLE test (
 col1 INT DEFAULT 0 NOT NULL,
 col2 INT DEFAULT 0 NULL,
 col3 INT NULL
);
INSERT INTO test VALUES (NULL, NULL, NULL)

Column 'col1' cannot be null


INSERT INTO test (col2, col3) VALUES (NULL, NULL)
SELECT * FROM test;


col1
col2
col3


0
null
null


INSERT INTO test (col2, col3) VALUES (DEFAULT, NULL)
SELECT * FROM test;


col1
col2
col3


0
null
null

0
0
null

col1	col2	col3
0	null	null
0	0	null