How to run script from within Mysql workbench?

Question

I have a SQL script to distribute to others to run from a MySQL IDE, not from a MySQL command prompt.

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:

SELECT value FROM mytable WHERE key = "mykey" into @columnid;

INSERT INTO mytable (col2,col3) VALUES (
@columnid,
'testvalue'
)

We all have MySQL Workbench installed but I don't see a way to do this from workbench.

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?

You'll need to specify a default database if you aren't using a database prefix. (Right click on Database, set as default, or something of the likes) — Devon Bessemer
– Devon Bessemer, Commented Apr 9, 2015 at 18:25

Philip Olson · Accepted Answer · 2015-04-14 20:17:27Z

26

There are two different methods:

File -> Open SQL Script: This simply loads the file contents into a new SQL query tab in the SQL editor. From here, execute the query exactly like you would if you typed it in.
File -> Run SQL Script: This opens the SQL script in its own "Run SQL Script" wizard that includes a [Run] button to execute the query. This only displays part of the query, but does allow the user to override the selected schema and character set. Note: This feature was added in Workbench 6.2.

I suspect you want the simpler "Run SQL Script".

answered Apr 14, 2015 at 20:17

Philip Olson

4,8781 gold badge27 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

William T. Mallard Over a year ago

For very long scripts (e.g. restoring from backup) I think the Run SQL Script option is preferable as it doesn't load the entire script.

Rahul Tripathi · Accepted Answer · 2015-04-09 18:27:02Z

4

You just need to go to the File option and then click Open SQL Script.

You can refer: SQL Query Window Toolbar and a small video

answered Apr 9, 2015 at 18:27

Rahul Tripathi

173k33 gold badges292 silver badges341 bronze badges

Comments

chamzz.dot · Accepted Answer · 2018-10-25 06:07:16Z

3

After open the Mysql workbench ,Just follow these steps,

start the server

server -> server status -> start server

create the relevant database

navigator(in left side) -> schemas -> (right click) new schema -> your new db name ->ok

set the new db as default schema

right click the new db name -> set as default schema

Run the query

file-> open a sql script -> Open relevant script -> execute it

Finish

answered Oct 25, 2018 at 6:07

chamzz.dot

7752 gold badges12 silver badges25 bronze badges

Comments

O. Jones · Accepted Answer · 2015-04-09 18:27:19Z

1

Most RDMS IDE tools have a way to open a SQL script from a menu item.

In Workbench, it's File > Open SQL Script... like Maximus2012 wrote.

In HeidiSQL, it's File > Load SQL File ...

answered Apr 9, 2015 at 18:27

community wiki

O. Jones

Collectives™ on Stack Overflow

How to run script from within Mysql workbench?

4 Answers 4

1 Comment

Comments

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Related