sqldelete语句用法介绍-mysql教程

The SQL DELETE command has the following generic SQL syntax:

DELETE FROM Table1
WHERE Some_Column = Some_Value

DELETE FROM Customers
WHERE LastName = 'Smith'

DELETE FROM suppliers
WHERE EXISTS
( customers.name
from customers
where customers.customer_id = suppliers.supplier_id
and customers.customer_name = 'IBM' );

SELECT count(*) FROM suppliers
WHERE EXISTS
( select customers.name
from customers
where customers.customer_id = suppliers.supplier_id
and customers.customer_name = 'IBM' );