Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.w22.dev/llms.txt

Use this file to discover all available pages before exploring further.

The SQL editor gives you a full MySQL query interface directly in MySQL UI. Use it when the table view’s built-in filters and sorting are not enough — write any valid MySQL statement, execute it, and see the results in a table below the editor.

​
Opening the editor

Click the Query tab at the top of the main panel. If you have a table selected in the sidebar, the editor opens pre-populated with: 
SELECT * FROM `your_table` LIMIT 100;
You can edit or replace this query with anything you need. If no table is selected, the editor opens with an empty input.

​
Writing queries

The editor provides MySQL syntax highlighting and keyword auto-complete to help you write queries faster. Keywords, strings, numbers, and comments are each highlighted in a distinct color. The editor grows vertically as you type and adds a scrollbar for very long scripts.

​
Executing a query

Click the Execute button below the editor, or press Ctrl+Enter (or Cmd+Enter on Mac) to run the current query.
Use Ctrl+Enter (Cmd+Enter on Mac) to execute without reaching for the mouse. It works from anywhere inside the editor.

​
Reading results

Results appear in the panel below the editor immediately after execution. For SELECT queries, the results panel shows a table with one column per field returned and one row per result row. The row count is shown in the top-left corner of the results panel (for example, 42 rows). For INSERT, UPDATE, and DELETE queries, the results panel shows:
  • Affected rows — the number of rows modified
  • Insert ID — the auto-increment ID of the last inserted row (INSERT only, when applicable)
  • Execution time — how long the query took in milliseconds

​
Copying results

Click the Copy button in the top-right corner of the results panel to copy all result rows to your clipboard as tab-separated values (TSV). The first row in the copied text contains the column names. You can paste this directly into a spreadsheet.

​
Query history

MySQL UI automatically saves every query you execute. Click History to open the history panel, which lists your last 50 queries in reverse chronological order. Click any entry to load it back into the editor. Duplicate queries are deduplicated — only the most recent occurrence of each query is kept.

​
Example queries

SELECT * FROM `users` LIMIT 100;