Does SQLite care about the use of double quotes instead of single quotes? RobR
-----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] 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 <yanhong...@mpsa.com> 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 sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users