sqlMate - The Main Window:

Select an object of interest and click your mouse upon it:

back to the main-page

List of mySql-Servers:

You can define one or more mySql-servers.

To define a new server:

Context-menu -> Edit Login-Data -> Define new server
To log in to a server:

Doubleclick on a list-entry

Button 'Show Tables':

This function is for convenience only: The SQL-command 'Show tables' is generated and executed immediately ('Go'-button need not be clicked).

Button 'Show Columns':

This function is for convenience only: The SQL-command 'Show columns from <table>' is generated and put in the Edit-Area. You must provide only the table-name and click on 'Go'-button.

Path to your DDML-directory:

The path to your DDML-directory is shown here (DDML: Data Definition/Data Manipulation Language). You may change this path in the Settings.

Prolog:

The so-called Prolog, which you have defined with your server, is shown here. The 'Prolog' is an SQL-command, which is executed automatically after each login to a server. This typically is the 'use'-command, which is neccessary to sign on to a specific mysql-database.

Alternatively you may have a 'use'-command at the beginning of every DDML-script, which is only useful if you have more than one database on your server.

You may change this command in the definition of that server.

Button to store a modified DDML-script:

When you have selected a script from the Query-list and have modified it, you may save the modifications by using this button.

Button to store a new DDML-script:

Any code which you have entered in the DDML-Edit-Area can be save under a new name by using this button.

List of defined DDML-scripts:

This listbox shows all your existing DDML-scripts. In addition to those in your defined DDML-directory also those from the sqlMate-program directory (if any) are shown.

With a doubleclick on one of the list-entries you bring that script into the DDML-Edit-Area. By invoking the Context-menu (right mouse-click) a file-open-dialogue appears where you can select a directory for the DDML-members of your choice.

DDML-Edit-Area for SQL-Commands:

Here is the place where the SQL-commands are entered. You can use this area the same way you use a text-editor (copy, paste etc);

You have to follow the rules of mySQL-syntax.

The right mouse-button over the Edit-Area brings up this context-menu:

Undo:
Makes the last update on the SQL-command undone (not any database-update!).
Clear Edit-Area:
Removes everything from the Edit-Area.
External Edit:
By means of this function you may edit the DDML in your favourite ascii-editor. Being invoked for the first time the program will prompt you for the full path to that editor.
Paste:
The content of the actual clipboard is pasted into the Edit-Area (to the current position of the cursor).

Button for executing the script:

The SQL-command which is presently in the DDML-Edit-Area will be sent to the remote server and there be executed. You can have more than one SQL-commands at a time, but remember to terminate each command with a semi-colon (';').

Checkbox for formating the mySql-Query-report:

When checked the resulting list from the server is formatted in a certain way, mainly to show the column-structure of the list.

List of mySql-Query-report:

Whatever comes in return from the mySql-server as a result from your DDML will be shown here. In case of a SELECT-statement (query) this will be a list of rows from the selected table(s), in case of a UPDATE, DELETE or INSERT-statement (query) the list will be empty.

The right mouse-button in the Result-Area brings up this context-menu:

Most of the functions are self-explanatory, except these two:
Show columns from <table>:
Suppose you have executed a 'Show Table'-command, resulting in a list of table-names in the result-area. Invoking the context-menu over one of these table-names and selecting 'Show columns from <table>' will have this table-name be inserted into this command (replacing <table>). Then the command may be edited manually or submitted immediately by clicking on the 'Go'-button.
Select * from <table>:
Works the same way as 'Show columns from <table>'.

List of columns from a single row:

The rows of a query-report may be of quite large size, and not be visible in total in the listbox. To show a specific row in detail you can doubleclick on it, and that row will be presented column after column in this list (requires that the 'Format Output'-checkbox is off).

The content of this single line may now be transformed into an SQL-insert or -update-statement. Put the mouse cursor over the 'Single Record' listbox and right-click. You see a context-menu:

Select from that context-menu 'Generate SQL-Statement -> Update (or Insert). A window will pop up with the generated statement. If you had marked one line in the 'Single Record' listbox before, the corresponding column will be used for a WHERE-clause in case you selected UPDATE. In the 'Auxiliary Edit'-window you can again invoke the context menu. By selecting COPY you get the appropriate text into the clipboard; now you can change over to the main SQL-Edit-area and there you can PASTE the statement into it and then execute it after - if you like - editing again.

The Log-Window:

In this tiny window messages from the sqlMate-program are written, normally general hints, sometimes error-messages.

back to the main-page