Delete the record from the erp_repairorder_items table by inputting the repair order # and work order # to be removed


The DELETE statement is used to remove a record from the table


The WHERE clause specifies the conditions for the deletion

Only the record that matches both the repair order ID and work order ID will be deleted


DELETE FROM erp_repairorder_items
WHERE id_repairorder = :user_input AND id_workorder = :user_input;