Skip to main content
Create new records using the CREATE operation.

Basic Syntax

Create Single Record

Data Types

Multiple Fields

With Timestamps

Bulk Insert

Insert multiple records at once. Each record is wrapped in square brackets with = assignments.

Upsert

Insert or update if exists. Specify conflict field(s) with ON.

Upsert with Composite Key

Replace

Delete and insert (MySQL-specific behavior).

Complete Examples

User Registration

E-commerce Order

Bulk Product Import

Next Steps

Update Data

Modify existing records

Delete Data

Remove records