TalkPHP - View Single Post - Handling a large number of inserts on a mysql table

captainmerton · 07-16-2009, 11:30 AM

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?

07-16-2009, 11:30 AM	#1 (permalink)
captainmerton The Acquainted Join Date: May 2009 Posts: 178 Thanks: 9	Handling a large number of inserts on a mysql table 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?