On 16 Nov 2016, at 3:16pm, Andrew Stewart <astew...@arguscontrols.com> wrote:
> Forgot to ask 1 thing. What is a quick way to copy an entire table > from database1 to database2? If they are open in different connections you cannot do it. If they are open in the same connection using ATTACH then you can do it like this: open ('new.sqlite') ATTACH 'corrupt.sqlite' AS corrupt; CREATE TABLE myTable (... same structure as the old one ...); INSERT INTO myTable (SELECT * FROM corrupt.myTable) Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users