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

[Craig Morrison]

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:' ?

--
Craig Morrison
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
http://pse.2cah.com
  Controlling pseudoephedrine purchases.

http://www.mtsprofessional.com/
  A Win32 email server that works for You.