Re: [sqlite] Re: Copy tables from one memory database to another with no disk access?

[Dennis Cote]

Craig Morrison wrote:

Igor Tandetnik wrote:
did you try the really obvious way?

create table db2.yourtable(...)

insert into db2.yourtable
 select * from db1.yourtable



For that to work, one first needs to attach one database to the 
other. ATTACH command requires a file name. Memory database does not 
have one.


':MEMORY:' ?

The name of the in memory database is case sensitive. It must be 
":memory:", not ":MEMORY:".

I hope that saves someone some trouble.

Dennis Cote