FYI, the syntax of the INSERT statement is described here:
http://www.sqlite.org/lang_insert.html <http://www.sqlite.org/lang_insert.html>
and this paragraph describes your situation exactly:
• The first form (with the "VALUES" keyword) creates one or more new
rows in an existing table. If the column-name list after table-name is omitted
then the number of values inserted into each row must be the same as the number
of columns in the table. In this case the result of evaluating the left-most
expression from each term of the VALUES list is inserted into the left-most
column of each new row, and so forth for each subsequent expression. If a
column-name list is specified, then the number of values in each term of the
VALUE list must match the number of specified columns. Each of the named
columns of the new row is populated with the results of evaluating the
corresponding VALUES expression. Table columns that do not appear in the column
list are populated with the default column value (specified as part of the
CREATE TABLE statement), or with NULL if no default value is specified.
—Jens
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
