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 1FROM DUAL;
推荐教程: 《sql教程》
以上就是sql语句批量添加数据的方法是什么的详细内容,更多请关注24课堂在线网其它相关文章!