I need to cater for a situation where i want to process multiple inserts onto a mysql table. There are 4 columns on the table and 2 of the columns will always take the same data for the insert eg.

column1, column2, column3, column4
joebloggs,london,1234,ABC
joebloggs,london,1564,Akfr
joebloggs,london,19354,kjf
joebloggs,london,1354,AHC

Is there a mysql command i can use to do the insert as one package of work or do I need to loop in the php code until all the inserts are done?

If the latter, i'd need to checkpoint and commit. is this easy to do?