从cmd问题插入所有内容

本文介绍了从cmd问题插入所有内容的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述 大家好， 我有一个sql文件需要从命令行运行。 $ b sql文件中的$ b（请注意与现实生活中的信息相比较小）： Hi guys,I have an sql file that i need to run from command line.in sql file (please note that is small compared to real life sceanrios):INSERT ALLinto table1 (column1,columnc1) VALUES (1,2)into table1 (column1,columnc1) VALUES (3,4)into table1 (column1,columnc1) VALUES (5,6)into table1 (column1,columnc1) VALUES (7,8)into table1 (column1,columnc1) VALUES (9,10)SELECT * FROM DUAL;COMMIT; 当我试图从cmd传递此信息时，将发生以下错误： When im trying to pass this from cmd the folloing error will occur:SP2-0734: unknown command beginning "into table1..." - rest of line ignored.SP2-0734: unknown command beginning "into table1..." - rest of line ignored.SP2-0734: unknown command beginning "into table1..." - rest of line ignored.SP2-0734: unknown command beginning "into table1..." - rest of line ignored.SP2-0044: For a list of known commands enter HELPand to leave enter EXIT. 我尝试了什么： 有人能告诉我是否有解决方法？ 感谢您的帮助！ ：）What I have tried:Can someone tell me if there is a work around ? Thanks for your help ! :)推荐答案 不应该更像这样吗？ Shouldn't it be more like this?INSERT INTO table ( col … ) VALUES ( row1 … ) , ( row2 … ) … 这篇关于从cmd问题插入所有内容的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！