SQL Tree - SQL tree console



The SQL tree console can be opened via the main menu: Library -> SQL tree console. It allows to run any SQL command against the underlying database including querying the virtual tables MediaLibrary and Playlist.

Execute: Execute the entered SQL commands.
Abort: Abort currently running commands.
Load: Load a text file with SQL commands
Save: Save the SQL commands of the console to a text file.

The content of the result list can be copied via the context menu to the clipboard.

Copy cell: Copy the value as it is displayed
Copy row: Copy the row in a CSV format, which can be used as a value list in a SQL statement.
Copy all: Copy all rows. The format of the row is the same as for a single copied row.