Lesson 4 of 9
INSERT
INSERT INTO adds new rows to a table. You specify the table, the columns, and the values. The order of values must match the order of columns.
SQL
-- Insert one row
INSERT INTO users (name, email, age)
VALUES ('Ali', '[email protected]', 25);
-- Insert multiple rows
INSERT INTO users (name, email, age)
VALUES
('Sara', '[email protected]', 30),
('Tom', '[email protected]', 22);