- Регистрация
- 15.05.2017
- Сообщения
- 403
- Благодарностей
- 90
- Баллы
- 28
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
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