Changing Data

INSERT

Syntax:

INSERT INTO table_name (column1, column2) VALUES (value1, value2);

INSERT INTO students (name, city, marks)
VALUES ('Hina', 'Islamabad', 88);

-- several rows at once
INSERT INTO students (name, city, marks) VALUES
  ('Usman', 'Multan', 71),
  ('Zara', 'Lahore', 95);