SQLite Forum

FEATURE REQUEST: use of DEFAULT in INSERTs
Login
Exactly, this allows to write one INSERT statement and change the DEFAULTs with NULLs:

~~~
INSERT INTO t1 
  (a      , b      , c      ) VALUES 
  (10     , NULL   , NULL)
, (NULL   , 20     , NULL)
, (NULL   , NULL   , 30     )
;
~~~

I didn't know about the "NOT NULL ON CONFLICT REPLACE" part.
Thank you very much!