MySQL Cookbook

Using Copy and Paste as a mysql Input Source

Problem

You want to take advantage of your graphical user interface (GUI) to make mysql easier to use.

Solution

Use copy and paste to supply mysql with queries to execute. In this way, you can take advantage of your GUI’s capabilities to augment the terminal interface presented by mysql.

Discussion

Copy and paste is useful in a windowing environment that allows you to run multiple programs at once and transfer information between them. If you have a document containing queries open in a window, you can just copy the queries from there and paste them into the window in which you’re running mysql. This is equivalent to typing the queries yourself, but often quicker. For queries that you issue frequently, keeping them visible in a separate window can be a good way to make sure they’re always at your fingertips and easily accessible.