将数据从一个 SQLite 数据库复制到另一个

Copying data from one SQLite database to another(将数据从一个 SQLite 数据库复制到另一个)

问题描述

我有 2 个 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 数据库复制到另一个的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！