Thank You!
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
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
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
I guess I should know this, but is there a way to copy a table from one
database to another?
Thanks in advance!
5 matches
Mail list logo