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.

MySQL UI lets you insert, update, and delete rows without writing SQL. You can edit a single cell with a double-click, modify an entire row from the row menu, or remove records with a confirmation step to prevent accidental deletions.

​
Adding a row

  1. Click Add Row in the toolbar above the table.
  2. A dialog opens showing every column in the table, along with each column’s data type and whether it accepts NULL. Auto-increment columns show “Auto-generated” and can be left blank.
  3. Fill in the values you want to insert.
  4. Click Insert to save the new row.
The table refreshes automatically and the new row appears in the data view.

​
Editing a single cell

Double-click any cell in the table to open the edit dialog for that field. Update the value and click Save. For cells containing more than 100 characters, the dialog switches to a larger text area automatically so long values are easier to read and edit.
Updates use the row’s primary key in the WHERE clause to identify the correct record. If the table has no primary key, MySQL UI falls back to matching on all column values. For best results, ensure your tables have a primary key defined.

​
Editing an entire row

To update multiple fields at once:
  1. Click the ⋮ (more options) icon at the right end of any row.
  2. Select Edit row from the dropdown.
  3. The edit dialog opens showing all columns. Modify any fields you need.
  4. Click Save to apply all changes.
You can also switch between single-field and full-row mode inside the edit dialog using the Edit entire row / Edit single field toggle at the bottom left.

​
Deleting a row

  1. Click the ⋮ icon on the row you want to remove.
  2. Select Delete row.
  3. A confirmation dialog appears — click Delete to confirm.
Deletions are permanent. MySQL UI does not provide an undo option, and deleted rows cannot be recovered from within the application. Make sure you have a backup before deleting data you may need later.