Inserting multiple rows in one single SQL statement MySql

 INSERT INTO {table_name} (col1,col2) VALUES (val1,val2), (val3,val4),(val5,val6);

This would insert three rows.

Great for relatively short inserts, larger amounts of data can cause MySql server to lock up and possibly abort.