MySQL Expert

Query MySQL with easy field selection - only get the data you need

Actions6

Table → Delete

AI-generated

Summary

Delete rows from a specified MySQL table matching optional filter conditions, or perform a truncate or drop table operation.

Inputs

  • table (required) — Name of the target MySQL table to delete from.
  • filters — Optional conditions to filter rows to delete, supporting multiple column/operator/value filters combined by AND or OR.
  • combineFilters — How to combine multiple filter conditions: either 'AND' (all conditions must match) or 'OR' (any condition matches). Defaults to 'AND'.
  • deleteCommand (required) — Type of deletion to perform. Choose 'Delete Rows' to delete rows matching filters, 'Truncate Table' to remove all data but keep table structure, or 'Drop Table' to permanently delete the table and its data.

Output shape

An array of response objects containing success status, number of affected rows (for 'delete' and 'truncate'), and the command executed.

For 'delete' operations, filters may be omitted to delete all rows. 'truncate' and 'drop' commands do not use filters. The output includes 'success', 'affectedRows' (if applicable), and 'command' fields. Errors are thrown on failure unless "Continue On Fail" is enabled.

Examples

Example 1: Delete rows where specified filter conditions match

Set 'Delete Command' to 'Delete Rows', specify the table name, optionally add filters and choose how to combine them.

Example 2: Remove all data from a table but keep its structure

Set 'Delete Command' to 'Truncate Table', specify the table name, leave filters empty.

Example 3: Permanently delete a table and its data

Set 'Delete Command' to 'Drop Table', specify the table name, filters are ignored.

Links

Discussion