On 20 Dec 2016, at 8:19pm, jic...@yahoo.com wrote:

> sqlite> INSERT INTO Years VALUES(4);
> Error: table YEARS has 2 columns but 1 values were supplied
> 
> […]
> 
> How can I make DEFAULT work?

INSERT INTO Years (IDYear) VALUES (4);

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to