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');
