mysql bulk insert multiple rows code example

Example: how to insert multiple rows in mysql using stored procedure

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