本文介绍了将数据从一个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数据库复制到另一个的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

09-06 03:21