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.

📄️ Single row

Insert a single row:

📄️ Multiple rows

On dialects that support it (for example PostgreSQL) you can insert multiple

📄️ Returning data

On supported dialects like PostgreSQL you need to chain returning to the query to get

📄️ Complex values

In addition to primitives, the values can also be arbitrary expressions.

📄️ Insert subquery

You can create an INSERT INTO SELECT FROM query using the expression method:

Docs

Introduction
Getting started
Playground
Migrations
Generating types

Examples

SELECT
UPDATE
DELETE
INSERT

Community

Discord
Twitter

Other

GitHub
API docs

Sponsors