How to insert table to mysql

[myndeswx]

Is there a faster way to insert large table to MySql than looping each line 1 by 1 ?

I came across this example -
INSERT INTO tbl_name (a,b,c) VALUES(1,2,3),(4,5,6),(7,8,9);
but can't think of a way how to use it with a list.
Thank you

 

[ol1ver]

google -> mysql insert more than one row

a,b,c - columns
(1,2,3) - values

im using phpmyadmin which helps to make query and debug