title: How to run script from within Mysql workbench?
body: <p>I have a SQL script to distribute to others to run from a MySQL IDE, not from a MySQL command prompt.</p>
  
  <p>I want the user to load the script into a window of workbench (or another IDE like sqlyog) and just run the script, which inserts records based on variables, for example:</p>
  
  <pre><code>SELECT value FROM mytable WHERE key = "mykey" into @columnid;
  
  INSERT INTO mytable (col2,col3) VALUES (
  @columnid,
  'testvalue'
  )
  </code></pre>
  
  <p>We all have MySQL Workbench installed but I don't see a way to do this from workbench.  </p>
  
  <p>Is there a way to run a script (that is in an editor window) from workbench (or any other MySQL IDE) the way you can run scripts from other database IDE's like Toad or SQL Server Management Studo?</p>