sql语句批量添加数据的方法是什么

INSERT INTO testimport (name, message)  VALUES

('testname', 'jfksdfkdsfjksadljfkdsfjsdlafjdaslkfjasfd'),

('testname', 'jfksdfkdsfjksadljfkdsfjsdlafjdaslkfjasfd'),

('testname', 'jfksdfkdsfjksadljfkdsfjsdlafjdaslkfjasfd');

INSERT ALL

    INTO A (name, message) VALUES ('testname', 'jfksdfkdsfjksadljfkdsfjsdlafjdaslkfjasfd')   

    INTO A (name, message) VALUES ('testname', 'jfksdfkdsfjksadljfkdsfjsdlafjdaslkfjasfd')   

    INTO A (name, message) VALUES ('testname', 'jfksdfkdsfjksadljfkdsfjsdlafjdaslkfjasfd')

SELECT 1

FROM DUAL;