INSERT

INSERT adds new rows into a table.

Source data — Pattern 12: Data Manipulation (DML)

All queries run against the shared employees table (see schema.sql). This pattern introduces core Data Manipulation Language (DML) statements. Topic 79 introduces an employee_updates table to demonstrate the MERGE / UPSERT operation.

INSERT — source table 1

INSERT — source table 2

What it does

INSERT adds new rows into a table.

Problem

Insert a new employee.

INSERT INTO employees(employee_id,first_name,salary)
VALUES(101,'Rahul',55000);

Result

INSERT — result 3

SQL · Pattern 12 — Data Manipulation (DML)

INSERT

INSERT adds new rows into a table.

Source data — Pattern 12: Data Manipulation (DML)

All queries run against the shared employees table (see schema.sql). This pattern introduces core Data Manipulation Language (DML) statements. Topic 79 introduces an employee_updates table to demonstrate the MERGE / UPSERT operation.

INSERT — source table 1

INSERT — source table 2

What it does

INSERT adds new rows into a table.

Problem

Insert a new employee.

INSERT INTO employees(employee_id,first_name,salary)
VALUES(101,'Rahul',55000);

Result

INSERT — result 3