On 16 Nov 2016, at 3:16pm, Andrew Stewart <[email protected]> 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
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
