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
