How to Delete a Row from a Table

Removing individual records from your MySQL tables is straightforward with the Nobregas MySQL Panel. The table browser provides a delete button on each row with a safety confirmation, preventing accidental data loss.

Locating the Row to Delete

1. Log in at mysql.nobregas.org.
2. Navigate to Databases > Manage on your database.
3. Click the table name or Browse button.
4. On the Data tab, browse or paginate to find the row you want to remove.

Deleting a Row

1. Find the specific row in the data table.
2. Click the Delete button (red, with a trash icon) on that row.
3. A confirmation dialog appears asking you to confirm the deletion.
4. Read the confirmation carefully, then click Delete to confirm.

The row is permanently removed from the table. A success notification appears confirming the deletion.

Important: Deletion Is Permanent

There is no undo button for row deletion. Once a row is deleted:

• The data is gone from the table permanently.
• Any relationships to this row from other tables may be affected (depending on foreign key constraints).
• The auto-increment counter is not reset — so if you delete row ID 5, the next insert will be ID 6 (not 5 again).

Before You Delete

Consider these steps before deleting:

• Verify the correct row — Double-check the data in the row to make sure it is the right one.
• Check dependencies — If other tables reference this row via foreign keys, deleting it may fail or cascade-delete related data.
• Create a backup if you are unsure — use the Backups page to save the current state.

Deleting Multiple Rows

The table browser deletes one row at a time. If you need to delete multiple rows based on criteria, use the SQL Query page:

-- Delete specific rows
DELETE FROM orders WHERE status = 'cancelled' AND created_at < '2026-01-01';

-- Delete by ID
DELETE FROM users WHERE id IN (10, 15, 22);

Always use a WHERE clause. Running DELETE FROM table_name without a WHERE clause deletes all rows in the table.

If You Deleted the Wrong Row

If daily backups are enabled on your plan, you may be able to restore the database from the last backup via the Backups page. Otherwise, the deleted data cannot be recovered.