Single quotes should be used for strings, so DEFAULT '-' Not quite sure what you're asking. Do you mean how to insert defaults in general?
INSERT INTO test (a, c, d) VALUES ('field a', 'field c', 'field d'); will get you a b c d ---------- ---------- ---------- ---------- field a - field c field d You need to explicitly state which fields you are providing values for, and any field you don't specify/provide will get the default value, either what you defined or null. When using VALUES or bindings there is no way to explicitly say "use the default for this field", you have to not provide anything and exclude the field from the insert. So there is no method to do something like... INSERT INTO test VALUES ('field a', DEFAULT, 'field c', 'field d'); There is also no way to give it 4 values and have it use only 3 of them. Hopefully that answers what you were looking for. PS: Simon: Specifying NULL will just put a NULL value in there, it won't use the default. -----Original Message----- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Robert M. Münch Sent: Tuesday, June 27, 2017 3:13 PM To: SQLite mailing list Subject: [sqlite] INSERT ... VALUES / want to "skip" default values Hi, I have a table like: 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? Viele Grüsse. -- Robert M. Münch, CEO M: +41 79 65 11 49 6 Saphirion AG smarter | better | faster http://www.saphirion.com http://www.nlpp.ch _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users