Re: [sqlite] Copy a table across databases

2006-05-03 Thread cstrader232
Thank You!

Re: [sqlite] Copy a table across databases

2006-05-03 Thread Jay Sprenkle
On 5/3/06, Gerry Snyder <[EMAIL PROTECTED]> wrote: cstrader232 wrote: > I guess I should know this, but is there a way to copy a table from one database to another? > > Thanks in advance! > Start SQLite pointing to the file needing the new table. ATTACH otherfile AS f2 CREATE TABLE newtable AS

Re: [sqlite] Copy a table across databases

2006-05-03 Thread Gerry Snyder
cstrader232 wrote: I guess I should know this, but is there a way to copy a table from one database to another? Thanks in advance! Start SQLite pointing to the file needing the new table. ATTACH otherfile AS f2 CREATE TABLE newtable AS SELECT * FROM f2.oldtable HTH, Gerry

Re: [sqlite] Copy a table across databases

2006-05-03 Thread Jay Sprenkle
On 5/3/06, cstrader232 <[EMAIL PROTECTED]> wrote: I guess I should know this, but is there a way to copy a table from one database to another? insert into db1.table1 select * from db2.table1; http://sqlite.org/lang_insert.html -- SqliteImporter: Command line fixed and delimited text impo

[sqlite] Copy a table across databases

2006-05-03 Thread cstrader232
I guess I should know this, but is there a way to copy a table from one database to another? Thanks in advance!