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] -----------------------------------------------------------------------------
