Inserting multiple rows in a single MySQL query

MySQL

 

The world's second most used open-source database. Skyvia requires the server to be available from Internet. Skyvia supports MySQL, Percona, and MariaDB servers.

Inserting multiple rows in a single MySQL query at once

Query Text

INSERT INTO tbl_name
    (a,b,c)
VALUES
    (1,2,3),
    (4,5,6),
    (7,8,9);
  

Open Query