On 16 Jan 2019, at 4:59pm, David Raymond <david.raym...@tomtom.com> wrote:
> Also note on quotes, single is for a text literal, double is for identifiers.
> So it should be
> insert into person ("name") values ('hello')...
> or just plain
> insert into person (name) values ('hello')...
though if you're going to quote your identifiers, it should really be
insert into "person" ("name") values ('hello')...
It's better just not to use double quotes at all, unless you have no control
over identifiers and they may have punctuation in.
Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
