DELETE
mutation deletes one or more records from a table based on specified conditions. This support has limitations:
DELETE from the table
without any condition is possible, but it will be much slower than the DROP TABLE table
.SET column=<value>
operation doesn’t support sub-SELECT as the value, and the WHERE
clause cannot contain sub-SELECT.DELETE
mutation is as follows:
table
: The table name from which you want to delete records.WHERE
conditions (Optional): The conditions must be met for the deletion to execute. If no conditions are provided, all records from the table will be deleted.orders
that track customer orders.order_id
: 102
, 103
, and 104
are deleted because they have a quantity less than 2.