本文介绍了将数据从一个SQLite数据库复制到另一个的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有两个SQLite数据库具有共同的数据,但目的不同,我想避免重新插入数据,所以我想知道是否可以将一个整个表从一个数据库复制到另一个?
I have 2 SQLite databases with common data but with different purposes and I wanted to avoid reinserting data, so I was wondering if it was possible to copy a whole table from one database to another?
推荐答案
您必须使用命令,然后对要传输的表运行相应的Insert Into命令。
You'll have to attach Database X with Database Y using the ATTACH command, then run the appropriate Insert Into commands for the tables you want to transfer.
INSERT INTO X.TABLE SELECT * FROM Y.TABLE;
或者,如果列未按顺序匹配:
Or, if the columns are not matched up in order:
INSERT INTO X.TABLE(fieldname1, fieldname2) SELECT fieldname1, fieldname2 FROM Y.TABLE;
这篇关于将数据从一个SQLite数据库复制到另一个的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!