SQL · Writing data

insert

Adds rows. Always list columns explicitly so schema changes do not break the statement.

sqlRunnable example sql course

Syntax

insert into table (cols) values (…);

Example

Open in the lab

CREATE TEMP TABLE notes (id INTEGER PRIMARY KEY, body TEXT);
INSERT INTO notes (body) VALUES ('first'), ('second');
SELECT * FROM notes;

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.