This option allows you to delete rows from a table. Note that if you do not set a condition for deleting rows, this will erase the entire table and recreate it as an empty table. The deleted data can not be recovered.
To delete rows from a table, select the "Delete" option from the "Select" list. Then choose the table from the tables list. Set the condition for deleting the rows using the "optional where" panel fields. Choose the column name based on which you want to set the condition from the "Column Name" list. Select the "Equals" or "Like" operators from the drop-down menu. Enter the value of the selected column for the rows you want to delete. Click the "Build SQL Query" button. After reviewing the SQL Query click the "Run SQL Query" button to complete the operation. The result of operation will appear at the bottom of the page.