16 May 2018

To insert multiple rows with a single query you can use regular insert with multiple value rows. You can also use update if you have primary key set.

Source code viewer
  1. /* Table and column names.*/
  2. INSERT INTO my_table (column_1, column_2)
  3. /* Rows to insert. */
  4.     VALUES
  5.     (0, 'Value 1'),
  6.     (1, 'Value 2'),
  7.     (2, 'Value 3'),
  8.     (3, 'Value 4'),
  9.     (4, 'Value 5')
  10. /* When the primary key exists, update the value. */
  11. ON DUPLICATE KEY UPDATE
  12.     colum_2 = VALUES(column_2),
  13.     ...
Programming Language: MySQL