mysql insert into multiple rows

INSERT statements that use VALUES syntax can insert multiple rows. mysql insert into select To do this, include multiple lists of column values, each enclosed within parentheses and separated by commas. mysql insert into select Example: INSERT INTO tbl_name (a,b,c) VALUES (1,2,3), (4,5,6), (7,8,9); Source