Trying to learn or understand constraints. Please take a look at the following…
sqlite> PRAGMA foreign_keys=1; sqlite> BEGIN TRANSACTION; sqlite> DROP TABLE IF EXISTS Years; sqlite> CREATE TABLE Years ...> ( ...> IDYear INTEGER PRIMARY KEY, ...> Year TEXT DEFAULT '1980' ...> ); sqlite> INSERT INTO Years VALUES(1,'1982'); sqlite> INSERT INTO Years VALUES(2,'1992'); sqlite> INSERT INTO Years VALUES(3,'2016'); sqlite> INSERT INTO Years VALUES(4); Error: table YEARS has 2 columns but 1 values were supplied sqlite> COMMIT; I also tried just a plain insert, sqlite> INSERT INTO Years VALUES(); Error: near ")": syntax error How can I make DEFAULT work? Thanks. josé _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
