I am going to quote Drake Wilson, from a thread a couple days old
("[sqlite] DELETE only deletes some records, not others"):"Aside from the more immediately relevant aspects the other posters already mentioned, remember that double quotation marks in SQL are normally used for _identifiers_. For string literals, use single quotation marks. SQLite will sort of autocorrect the former into the latter sometimes, but it is not good practice to rely on this." On Wed, Jul 11, 2012 at 2:36 PM, Rob Richardson <[email protected]>wrote: > Does SQLite care about the use of double quotes instead of single quotes? > > RobR > > -----Original Message----- > From: [email protected] [mailto: > [email protected]] On Behalf Of Simon Davies > Sent: Wednesday, July 11, 2012 5:10 AM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] cann't work > > On 11 July 2012 10:00, YAN HONG YE <[email protected]> wrote: > > two same structure tables, when use this sql: > > insert into table2 values(select * from table1 where filename like > "%55"); > > > > but show error: sqlite error 1 - near "select": syntax error > > insert into table2 select * from table1 where filename like "%55"; > > http://www.sqlite.org/lang_insert.html > > Regards, > Simon > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
