sql语句批量添加数据的方法是什么?
方法1:逐条执行,速度慢。
INSERT INTO testimport (name, message)VALUES ('testname', 'jfksdfkdsfjksadljfkdsfjsdlafjdaslkfjasfd'); INSERT INTO testimport (name, message)VALUES ('testname', 'jfksdfkdsfjksadljfkdsfjsdlafjdaslkfjasfd'); INSERT INTO testimport (name, message)VALUES ('testname', 'jfksdfkdsfjksadljfkdsfjsdlafjdaslkfjasfd');
方法2:批量执行,适用于 SQL Server。
INSERT INTO testimport (name, message) VALUES ('testname', 'jfksdfkdsfjksadljfkdsfjsdlafjdaslkfjasfd'), ('testname', 'jfksdfkdsfjksadljfkdsfjsdlafjdaslkfjasfd'), ('testname', 'jfksdfkdsfjksadljfkdsfjsdlafjdaslkfjasfd');
方法3:批量执行,适用于Oracle。
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;
推荐教程: 《sql教程》