Data Changes

Insert Rows

Adding Data

INSERT adds new rows to an existing table.

Program

Play the script to watch the task list grow.

insert_rows.sql 
CREATE TABLE tasks (id INTEGER, title TEXT, done INTEGER);
INSERT INTO tasks VALUES (1, 'write', 0);
INSERT INTO tasks VALUES (2, 'review', 0);
SELECT id, title FROM tasks ORDER BY id;
mutation A mutation changes stored table data.
row Each `VALUES` tuple becomes one row.
read after write A later `SELECT` sees earlier inserts.