SQL Console

Runs SQL on the connected MySQL/MariaDB server and displays results.
Requires an EDB session and database to be open — result sets are stored in a session-scoped EDB temporary table (not persisted to disk) in the active session.

Purpose — verification, not editing. The SQL Console is intended for inspecting and verifying data that has been migrated to the target MySQL/MariaDB server.
The result grid is read-only: data retrieved from the server cannot be edited directly inside EDB2MySQL.

To insert, update, or delete rows on the target server, use a dedicated MySQL administration tool such as phpMyAdmin, MySQL Workbench, DBeaver, or the mysql command-line client. Alternatively, if you need to drive MySQL operations programmatically from a Delphi application, use the EDBApiClient Library, which provides a self-contained REST client for executing arbitrary SQL scripts against the server.

Script Editor

Accepts any SQL that edbapi.php can execute. SELECT, SHOW, and EXPLAIN display a result grid; DDL and DML report success or error only.

Toolbar

Control	Description
Max KB	Per-cell BLOB/CLOB cap in KB. Values larger than this are truncated server-side before sending. 0 = no cap. Default: 1024 KB.
OOB KB	Out-of-band threshold in KB. BLOB/CLOB cells larger than this value are stored as temporary files on the server and fetched individually, keeping each result page small. Cells at or below this size are sent inline. Default: 64 KB.
Database	Toggles the Database Schema panel. Shows the name of the active MySQL database. Disabled when no EDB database is open.
Open Script	Load a SQL file from disk.
Save / Save As	Save the current editor content.
Clear	Clear the editor.
Find	Open the find/replace bar.
Use Transaction	Wraps the query in BEGIN / COMMIT.
Run	Execute the script and display results.

Both BLOB size values are auto-configured from server limits when Get Server Information is run, and saved between sessions.

Result Grid

Results appear in the grid below the editor.

BLOB / CLOB cells — show [BLOB] or [CLOB] with a size indicator. Click the ... button on the right edge of the cell to open the BLOB / CLOB Viewer.

Status bar — shows row count and column count after a successful run. When a BLOB/CLOB result is truncated by the per-cell cap (Max KB), a notice is appended indicating how many columns were capped.

Result Toolbar

Button	Action
Apply / Clear	Enter an EDB filter expression in the Filter field and click Apply to narrow the visible rows. Click Clear to remove the filter. The expression uses EDB WHERE syntax (e.g. amount > 100). Press Enter in the filter box to apply.
Copy	Copy the current result (filtered rows only, if a filter is active) to the clipboard as tab-separated values (TSV). The header row is included. Pastes into Excel and LibreOffice Calc. BLOB cells appear as (BLOB).
Export	Save the result to a file → Export Result Set
Structure	Show the full MySQL/MariaDB column metadata for the result (type, nullable, default, key, charset, collation, etc.) and the EDB temp-table DDL.
Close	Clear the result grid and hide the result panel.

Database Schema Panel

Click the Database button in the toolbar to open an inline panel on the right side of the editor. The panel shows a tree of all tables and their columns in the connected MySQL/MariaDB database.

Tree contents:

• Top-level nodes — one per BASE TABLE, labelled with the table name.
• Child nodes — one per column, labelled column : type (e.g. customer_id : int).

Insert into editor — double-click any node to insert its name at the current cursor position in the editor:

• Table node → inserts the table name.
• Column node → inserts the column name (the : type part is stripped).

Closing the panel — click the Database button again, or click the × button in the panel header.

Data freshness — the panel data is fetched from the server once per connection (when Get Server Information / TestConnection runs) and after each Run execution that may have altered the schema (DDL). Click Get Server Information again to force a full refresh. The panel opens instantly from the cached data; no extra server call is made when toggling it open.

Requires PHP v188+. The table and column lists are populated only when the backend is PHP v188 or later. On older versions the panel opens but shows no content.

Notes

• Multi-statement scripts are supported; each statement executes in sequence.
• Large result sets are fetched in pages transparently — all rows appear in the grid once fetching completes. The status bar shows Fetching results: N / T rows… during the fetch, where N is the number of rows already loaded and T is the total expected from the server.
• BLOB/CLOB cells larger than OOB KB are fetched individually as out-of-band files. This keeps result pages small regardless of BLOB sizes. Values at or below Max KB are delivered inline; values above Max KB are truncated server-side and can be downloaded in full via the BLOB / CLOB Viewer.
• Run is only enabled when an EDB database is open, the editor contains text, and a server URL is configured. It is disabled while a query is executing or results are being fetched — clicking it during an active run has no effect.
• Demo mode — result sets are capped at 50 rows. The status bar appends (demo limit) to the row count when the cap is reached. Activate a license via the About button to remove this restriction.

See Also

• Using the Converter
• Export Result Set
• BLOB / CLOB Viewer
• Remote Configuration