The MySQL statement below will allow you to insert multiple rows of data into a table using only one SQL statement.
insert into table1 (First,Last) values ('Fred','Smith'), ('John','Smith'), ('Michael','Smith'), ('Robert','Smith'); # or in one line as insert into table1 (First,Last) values ('Fred','Smith'),('John','Smith'),('Michael','Smith'),('Robert','Smith');