Program settings - MySQL database servers

In this category of settings, you have the option to define the settings of the MySQL database servers that you use to create your website. This category only consists of a list to which you can add new servers, modify existing ones, or manage the list at all, using the buttons next to it, as well as one option described below.

Adding database servers is done via a separate window called MySQL database server properties, and of course a separate connection must be defined for each database. In the same window you modify the settings of the server selected in the list.

Format for pasting a query in the SQL Table Inspector

This list contains templates for formatting that is pasted into the current query editor, resulting in the current SQL table view in the MySQL Inspector tab. To paste a query in one of the formats presented here, press the Insert current query into the editor button next to the MySQL Inspector table contents view.

The buttons on the right side of the template list are used to edit the list of templates. By using them you can add, delete and edit templates as well as restore default templates.

The most important element of the template is the %s symbol, which indicates where to place the SQL query in the pasted text.

Number columns in the table content view
Check this option if you want a sequence number to appear next to the table field names in the table content view on the MySQL Inspector tab....

When dragging the table into the editor, use the export wizard
Check this option if you want the Database Export Wizard to open automatically when you drag a table from the database structure tree.

Related topics

To top