INSERT INTO

Add a new row to a table

Mutation

SQL

INSERT INTO users (name, email, age) VALUES ('Alice', 'alice@example.com', 30);

What each clause does

INSERT INTO specifies the table. The column list (name, email, age) defines which columns receive values. VALUES provides the data.

Related tools

SQL Formatter SQL Syntax Cheatsheet

Other SQL examples

SELECT All Rows SELECT with WHERE UPDATE SET DELETE FROM INNER JOIN LEFT JOIN GROUP BY ORDER BY Subquery CREATE TABLE Common Table Expression (CTE)Window Function UPSERT (ON CONFLICT)LIMIT & OFFSET