Script Runner

Previous  Index  Next  How To Use

Besides the Script Editor, there's also the Script Runner tool.

 

You can use the Script Runner to execute a (very) large script without loading it into the Script Editor. When a script is very large, syntax highlighting in the Script Editor can get very slow.

 

To avoid this, use the Script Runner, which loads the script from file while executing and only displays a single statement at the time (large statements, like the multi-INSERT statements in MySQL are truncated for display purposes). You can drag a file from the Windows Explorer into the Script File box or select the file using the file open dialog.

 

Script Runner, running a script on a MySQL database

 

As you can see in the above screen shot, you select a script file, an optional result file, in which all executed statements and errors end up, and the option to explicitly issue a database COMMIT after all statements have executed. This can be helpful if the script forgets a last COMMIT statement.