Execution of SQL statements on MySQL and MariaDB databases
The SQL editor is available at server and database level
Module for creating, editing and executing SQL statements:
You can search and set markings in the SQL editor.
A script archive, database and server change, search functions and various editor options are available.
Markers can be set by clicking on the line numbers.
The maximum size of SQL scripts for editing is 500 MB.
Runs the SQL script on the selected server and database.
SQL execution and data display options.
Starts the SQL wizard to create SQL statements.
Displays the server and database selection.
Save SQL statements as a file in the script archive.
Display SQL script archive.
Copy the contents of the editor to the clipboard.
Database selection:
Server:
Selection of the connected server on which to execute the SQL statements.
Database:
Selection of the database on the connected server on which to execute the SQL statements.
SQL and data options:
MULTI-QUERY:
All SQL statements are sent at once to the SQL server for execution. This also allows constructs with variables or the creation of several procedures without delimiters.
NUM-ROWS:
Displays the number of rows for result sets.
Lines of Data:
Maximum number of data rows to be output in the result table.
Shorten texts:
Shorten texts in table output to the maximum number of characters.
Blob content:
Show blob contents in tables.
Binary content:
Display binary content in tables.
As Text:
Display binary content in tables as text.
Spatial content:
Output spatial content in tables.
Null values:
Output null values in tables.
Field Information:
Show column information like data type, original field name and queried tables in output.
Searching in SQL Editor:
Find and highlight terms in the SQL Editor.
Delete search markers.
Jump to previous marker.
Jump to next marker.
Status line:
X:
Horizontal cursor position.
Y:
Vertical cursor position.
Rows:
Number of lines of SQL script.
Selection:
Positions of the selected text. With copy button.
Last:
Positions of the last selected text. With restore button.