Actually there would be six since you can either specify or omit the columns list for each ...
-- ˙uʍop-ǝpısdn sı ɹoʇıuoɯ ɹnoʎ 'sıɥʇ pɐǝɹ uɐɔ noʎ ɟı > -----Original Message----- > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > On Behalf Of Simon Slavin > Sent: Saturday, 1 July, 2017 17:14 > To: SQLite mailing list > Subject: Re: [sqlite] Documentation bug: lang_insert.html needs examples > > > > On 2 Jul 2017, at 12:08am, 積丹尼 Dan Jacobson <jida...@jidanni.org> > wrote: > > > So near the top of the article add this synopsis of the three basic > forms, > > INSERT INTO moz_cookies VALUES(1,'Bart',12); > > INSERT INTO moz_cookies SELECT ..... ???? > > INSERT INTO moz_cookies DEFAUT_VALUES ??? > > If those are "the" three forms, there are actually four and there needs to > be one for > > INSERT INTO moz_cookies (id_number, name, age) VALUES(1,'Bart',12); > > or whatever the columns are actually called. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
