mysql run sql files_如何在Eclipse DTP中運行多個.sql文件

Part I

As far as I know the developers of Eclipse DTP have not yet implemented a command line SQL execution interface through the Eclipse console view.

據我所知,Eclipse DTP的開發人員還沒有通過Eclipse控制台視圖實現命令行SQL執行接口。

請參閱eclipse DTP開發人員論壇上的以下URL:http://dev.eclipse.org/newslists/news.eclipse.dtp/msg00304.html

Part II

While the Eclipse DTP people are working on it, you can use a database specific tool to load a master SQL file (all SQL proc files appended together)

當Eclipse DTP人員正在處理它時,您可以使用特定於數據庫的工具來加載主SQL文件(所有SQL proc文件附加在一起)

There are database specific console tools that will load your master SQL file command line. (ie. SQL*Plus for Oracle, ij for Apache Derby)

有一些特定於數據庫的控制台工具將加載主SQL文件命令行。 (即SQL * Plus for Oracle,ij for Apache Derby)

Part III

An improvement over DOS batch is using Cygwin bash or python or perl to merge all of your sql files together into a master file.

對DOS批處理的改進是使用Cygwin bash或python或perl將所有sql文件合並到一個主文件中。

I found that the text processing tools available in UNIX (awk,sed,cat...) are great for this sort of thing.

我發現UNIX中可用的文本處理工具(awk,sed,cat ...)非常適合這類事情。