On Wed, 2007-02-07 at 11:12 -0800, Dave Gierok wrote: > I have one :memory: database open and I want to make a copy of it into > another :memory: database.
Ah, I get it now. Misunderstood earlier. A new in-memory database is created each time ':memory:' is attached (using ATTACH) or opened (via sqlite3_open). You cannot currently open a :memory: database via sqlite3_open() and then attach it to another handle. > When I open the 2nd :memory: database and call attach on the first one > specifying ':memory:' as the file name, it allows me to do this. However > when I loop through the tables copying them into the 2nd one, it is still > empty after this has been done. I think the first :memory: database might be > attaching to, uh, itself. > > Is there a way to specify the name of a memory database uniquely? Something > like ':memory:2'? Nothing that I've tried works. > -Dave Gierok > > -----Original Message----- > From: Dan Kennedy [mailto:[EMAIL PROTECTED] > Sent: Wednesday, February 07, 2007 9:56 AM > To: [email protected] > Subject: Re: [sqlite] ATTACH and :memory: databases > > On Wed, 2007-02-07 at 09:37 -0800, Dave Gierok wrote: > > I would like to attach a :memory: database to another :memory: database. > > How is this possible since the ATTACH command requires the database's file > > name? > > > > ATTACH [DATABASE] database-filename AS database-name > > > > -Dave Gierok > > I don't think there are any special issues. Use ':memory:' as the > filename. > > [EMAIL PROTECTED]:~> sqlite3 :memory: > SQLite version 3.2.8 > Enter ".help" for instructions > sqlite> attach ':memory:' as db2; > sqlite> attach ':memory:' as db3; > sqlite> create table db2.abc(a, b, c); > sqlite> select * from sqlite_master; > sqlite> select * from db3.sqlite_master; > sqlite> select * from db2.sqlite_master; > table|abc|abc|2|CREATE TABLE abc(a, b, c) > sqlite> > > > > ----------------------------------------------------------------------------- > To unsubscribe, send email to [EMAIL PROTECTED] > ----------------------------------------------------------------------------- > > > ----------------------------------------------------------------------------- > To unsubscribe, send email to [EMAIL PROTECTED] > ----------------------------------------------------------------------------- > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
