Question

How to multiple insert or batch insert at a time in MySQL query?

Answer 1

16-Feb-2019 · It is possible to insert multiple records into MySQL using a comma separated list of fields. ... INSERT INTO example (example_id, name, value, other_value) VALUES (100, 'Name 1', 'Value 1', 'Other 1'); To insert more than one record at once, we can do this, with each set of field ...