Skip to main content

GitHub API docs

Introduction
Getting started
Playground
Migrations
Examples
Recipes
Other runtimes
Dialects
Generating types
Plugin system

Examples
INSERT

INSERT

Short and simple examples of how to write insert queries.

📄️ Insert a single record

To insert a record use .insertInto(table).values(row).

📄️ Insert multiple records

To insert multiple records use .insertInto(table).values(arrayOfRecords).

📄️ Insert complex expressions

In this example the column values are expressions instead of values.

Join a subquery

Insert a single record

Docs

Introduction
Getting started
Playground
Migrations
Generating types

Examples

SELECT
UPDATE
DELETE
INSERT

Community

Discord
Twitter

Other

GitHub
API docs

Sponsors