DELETE FROM table_name WHERE condition;
-- Ex.
DELETE FROM Customers WHERE CustomerName='Mustafa Mbari';
delete from TableName where condition;
delete from scrumteam where firstname='Jack';
delete from scrumteam where JobTitle='SDET';
DELETE FROM table_name WHERE condition;
TRUNCATE table my_table;
Mit DELETE werden einzelne oder mehrere Datensätze gelöscht. Mit WHERE
werden nur bestimmte Datensätez gelöscht.
DELETE FROM suppliers
WHERE
supplier_name = 'Microsoft';
DELETE FROM `table` WHERE condition
Delete data from a table.
Example: Removes a user with a user_id of 674.
DELETE FROM users WHERE user_id = 674;
DELETE FROM sakila.actor
WHERE actor_id = 201;
CREATE PROC dbo.DeleteLotsOfStuff
(@id int)
AS
Begin
DELETE FROM login WHERE klantid = @id
DELETE FROM klantGegevens WHERE klantid = @id
DELETE FROM orderGegevens WHERE loginNr = @id
End
DELETE FROM computer WHERE name = '{}'
select * from
create trigger