MySQL For Beginners: How to Insert multiple rows in an SQL Table

In this tutorial, you will learn how to use a single MySQL INSERT statement to insert multiple rows into a table.

First, specify the name of table that you want to insert after the INSERT INTO keywords.
Second, specify a comma-separated column list inside parentheses after the table name.
Third, specify a comma-separated list of row data in the VALUES clause. Each element of the list represents a row. The number of values in each element must be the same as the number of columns in the column list.