How to run script from within Mysql workbench? -

i have sql script distribute others run mysql ide, not mysql command prompt.

i want user load script window of workbench (or ide sqlyog) , run script, inserts records based on variables, example:

select value mytable key = "mykey" @columnid;  insert mytable (col2,col3) values ( @columnid, 'testvalue' ) 

we have mysql workbench installed don't see way workbench.

is there way run script (that in editor window) workbench (or other mysql ide) way can run scripts other database ide's toad or sql server management studo?

there 2 different methods:

1. file -> open sql script: loads file contents new sql query tab in sql editor. here, execute query if typed in.

2. file -> run sql script: opens sql script in own "run sql script" wizard includes [run] button execute query. displays part of query, allow user override selected schema , character set. note: this feature added in workbench 6.2.

i suspect want simpler "run sql script".