Simon Slavin wrote: > On 27 Jun 2017, at 8:13pm, Robert M. Münch <[email protected]> > 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 [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
