Try it Yourself: SQL Insert Into

SQL Insert Into

Language: SQL

-- Form 1: name the columns you are filling
INSERT INTO Employees (first_name, last_name, department, salary)
VALUES ('Amara', 'Okafor', 'Engineering', 72000);

-- Form 2: supply a value for every column, in table order
INSERT INTO Employees
VALUES (101, 'Amara', 'Okafor', 'Engineering', 72000, '2026-03-01');

-- Form 1: name the columns you are filling
INSERT INTO Employees (first_name, last_name, department, salary)
VALUES ('Amara', 'Okafor', 'Engineering', 72000);

-- Form 2: supply a value for every column, in table order
INSERT INTO Employees
VALUES (101, 'Amara', 'Okafor', 'Engineering', 72000, '2026-03-01');

Output

Click Run to execute this code.