How to add data from table of one database into table of another database in SQLite

Question

Suppose I have two database files a.sqlite and other one is b.sqlite. suppose table1 is in a.sqlite and table2 in b.sqlite. I open a.sqlite in read-only mode and b.sqlite in read-write.Suppose both table table1 and table2 has same column name "description".table2 has description column with all null values and table1 has some values.So how can i add the data from table1 into table2.I know through query.But as these r in two different databse,so is there ant problem? Can any one suggest ?

user610650 · Accepted Answer · 2011-09-08 09:55:40Z

1

Not sure if your environment allows it, but ATTACH DATABASE is normally the way to go:

http://www.sqlite.org/lang_attach.html

answered Sep 8, 2011 at 9:55

user610650

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to add data from table of one database into table of another database in SQLite

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related