Section: Insert, update, delete, and upsert

Insert one row

sql
sql
INSERT INTO users (email, display_name) VALUES ('ava@example.com', 'Ava');
Explanation

Explicit column lists make inserts safer as schemas evolve.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Related commands

Same sheet · prioritizing Insert, update, delete, and upsert
Insert multiple rows
Add several records in one statement.
OpenIn sheetsqlsame section
Update matching rows
Modify one or more records.
OpenIn sheetsqlsame section
Delete matching rows
Remove records by condition.
OpenIn sheetsqlsame section
Upsert with ON CONFLICT
Insert or update on a uniqueness collision.
OpenIn sheetsqlsame section
Ignore duplicates on conflict
Keep the existing row when a unique key collides.
OpenIn sheetsqlsame section
Select all columns
Read rows from a table.
OpenIn sheetsql1 tag match