将数据从一个SQLite数据库复制到另一个 [英] Copying data from one SQLite database to another

问题描述

我有两个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?

推荐答案

您必须使用 ATTACH 命令，然后对要传输的表运行相应的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数据库复制到另一个的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！