SQL

INSERT

CautionInsert rows

INSERT INTO <table> (...) VALUES (...);

Adds new rows to a table.

Examples

Syntax

INSERT INTO <table> (<cols>) VALUES (<vals>);

Before you run it

Writes data; use a transaction/backup.

Related commands

The same reference, with no signal at all

Every command and flow from this site, held on your device and searchable with no connection. Free to install, no ads.

Get it free on the App Store