— Deletes all records where `columnName` matches the values in brackets.<br /> DELETE FROM tableName WHERE columnName IN (‘val1’, ‘val2’, ‘val3’);

DELETE FROM table_name WHERE condition;<br /> — Ex.<br /> DELETE FROM Customers WHERE CustomerName=”Mustafa Mbari”;

DELETE FROM tableA<br /> WHERE ROWID IN<br /> ( SELECT q.ROWID<br /> FROM tableA q<br /> INNER JOIN tableB u on (u.qlabel = q.entityrole AND u.fieldnum = q.fieldnum)<br /> WHERE (LENGTH(q.memotext) NOT IN (8,9,10) OR q.memotext NOT LIKE ‘%/%/%’)<br /> AND (u.FldFormat=”Date”));<br />

Mit DELETE werden einzelne oder mehrere Datensätze gelöscht. Mit WHERE<br /> werden nur bestimmte Datensätez gelöscht. </p> <p> DELETE FROM suppliers<br /> WHERE<br /> supplier_name=”Microsoft”;<br />

Delete data from a table.<br /> Example: Removes a user with a user_id of 674.<br /> DELETE FROM users WHERE user_id = 674;

DELETE FROM table_name<br /> WHERE condition;</p> <p>Delete from Employee<br /> where id = 12;<br />

DELETE FROM sakila.actor<br /> WHERE actor_id = 201;

DELETE FROM computer WHERE name=”{}”<br />

CREATE PROC dbo.DeleteLotsOfStuff<br /> (@id int)<br /> AS</p> <p>Begin</p> <p>DELETE FROM login WHERE klantid = @id<br /> DELETE FROM klantGegevens WHERE klantid = @id<br /> DELETE FROM orderGegevens WHERE loginNr = @id</p> <p>End

DELETE FROM table_name<br /> WHERE [condition];