Re: [sqlite] insert default values

[Gerry Snyder]

Mario Frasca wrote:

and how do I insert a 'all-default' record?
  
After getting everything else right (see my previous post):

sqlite> insert into test (f) values (NULL);
sqlite> select * from test;
1|1
2|2
3|
4|0

And this answers my previous comment, too. Inserting a NULL into v 
overrides the default.

Gerry