26 Sep 2009
SQL
Insert
Inserting multiple rows in one statement
You can (on DB2 and MySQL) insert multiple rows using only 1 SQL statement.
INSERT INTO tableName (field1, field2, field3) VALUES (record1value1, record1value2, record1value3), (record2value1, record2value2, record2value3) ... (recordnvalue1, recordnvalue2, recordnvalue3);
