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
