Simon Slavin wrote: > On 27 Jun 2017, at 8:13pm, Robert M. Münch <robert.mue...@saphirion.com> > wrote: >> CREATE TABLE test(a, b DEFAULT "-", c, d) >> >> Now I would like to use >> >> INSERT VALUES(a,?,c,d) >> >> Where ? is something that the default value is used and not the provided >> value. Is this possible at all? > > INSERT INTO test VALUES(12, NULL, 84, 'endomorph')
An explicit NULL works only for the autoincrement column, but not for default values. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users