Cheat Sheet logoCheat Sheet Today
SQL DDL and DML/Insert one row

Add a single row to a table.

Back to sheetBrowse commands
Sign in to save
Section: INSERT, UPDATE, and DELETE

Insert one row

sql
sql
INSERT INTO users (user_id, email, created_at)
VALUES (1, 'a@example.com', CURRENT_TIMESTAMP);
Explanation

Specify column names explicitly for clarity and safety.

View in sheet →

Learn the surrounding workflow

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

Compare commandsView fixes

Related commands

Same sheet · prioritizing INSERT, UPDATE, and DELETE
Insert multiple rows
Add several rows in one statement.
OpenIn sheetsqlsame section
Insert from select
Populate a table using query results.
OpenIn sheetsqlsame section
Update matching rows
Modify existing data using a WHERE clause.
OpenIn sheetsqlsame section
Delete matching rows
Remove rows that match a condition.
OpenIn sheetsqlsame section
Merge or upsert data
Insert new rows and update existing ones in one logical operation.
OpenIn sheetsqlsame section
Create table
Define a new table with columns and constraints.
OpenIn sheetsql