SQL Cheat Sheet

To insert more than one record at once, we can do this, with each set of field values separated by a comma:

INSERT INTO example

 (example_id, name, value, other_value)

VALUES

 (100, 'Name 1', 'Value 1', 'Other 1'),
 (101, 'Name 2', 'Value 2', 'Other 2'),
 (102, 'Name 3', 'Value 3', 'Other 3'),
 (103, 'Name 4', 'Value 4', 'Other 4');