On 27 Jun 2017, at 22:11, David Raymond wrote: > Single quotes should be used for strings, so DEFAULT '-'
I thought it doesn't matter if I use " or ' for strings. What's the difference?
> So there is no method to do something like...
>
> INSERT INTO test VALUES ('field a', DEFAULT, 'field c', 'field d');
That's what I want to do.
> PS: Simon: Specifying NULL will just put a NULL value in there, it won't use
> the default.
I tried NULL and as you said, that doesn't work because NULL is put in.
--
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
signature.asc
Description: OpenPGP digital signature
_______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
