## To Do

- New screen dumps
- New menu items

## Introduction

The MySQL plugin adds MySQL specific functionality to SQuirreL SQL Client.

Note apparently the MySQL team don't support DML (e.g. CREATE TABLE) through their JDBC driver. This is as reported in bug #1180. That said Squirrel attempts to do the right thing so you are welcome to see what happens.

## New Tabs

The session node in the object tree has four new tabs added.

The "MySQL Status" tab display status information about the MySQL server. This tab requires you to have sufficient authority to run the `show status` command against the server.

The "MySQL Processes" tab shows the current processes attached to the server. This tab requires you to have sufficient authority to run the `show full processlist` command against the server.

The "MySQL Variables" tab shows the values of some MySQL system variables. This tab requires you to have sufficient authority to run the `show variables` command against the server.

The "MySQL Logs" tab shows information about the current MySQL log files. This tab requires you to have sufficient authority to run the `show logs` command against the server.

The Catalog nodes in the object tree have two new tabs.

The "MySQL Open Tables" tab. shows a list of the currently opened tables in the catalog. To display this tab successfully you need to have the rights to run `show open tables` against the catalog.

The "MySQL Table Status" tab shows status information for the tables in the currently selected catalog. To display this tab successfully you need to have the rights to run `show table status` against the catalog.

## New Menu Options

The Session menu (and the popup menu in the object tree) has a new Hierarchical menu "MySQL" that contains MySQL specific actions. These options are:

"MySQL Create table Script" has been added to the popup menu for tables in the Object Tree. This will generate a "Create Table" script for the selected table(s) and add it into the SQL entry area.