本页尚未翻译

本页内容仍为英文原文，源自官方文档 sql/dml/insert。中文翻译正在分批进行中。

Insert

INSERT INTO, including INSERT ... SELECT to move rows server-side.

Applies to: Embedded ❌, Enterprise ✅

INSERT INTO documents (id, title) VALUES (1, 'Merlin'), (2, 'Arthur')

INSERT INTO archive
SELECT * FROM documents
WHERE created_at < '2026-01-01'

INSERT ... SELECT is the form worth knowing: it moves rows between tables server-side, without a round trip through your process.

Commits a new table version, so versioning and the write guarantees apply, including that the version advances even when the statement affects zero rows.

What to read next

InsertThe SDK equivalent.Merge InsertUpsert (matching incoming rows against existing keys) has no SQL form.