How to Insert Multiple Rows with MySQL (insert shortcut)

Below is an example how to insert multiple values/rows into a table using a single insert statement shortcut. Versus individually listing out each insert statement separately.

INSERT INTO table (col1, col2, col3)
VALUES
(value_1),
(value_2),
(value_3);

Leave a Reply

Your email address will not be published. Required fields are marked *