Tutorials
SQL Delete

DELETE FROM ANTIQUES
WHERE ITEM = 'Ottoman';

But if there is another row that contains 'Ottoman', that row will be deleted also. Let's delete all rows (one, in this case) that contain the specific data we added before:

DELETE FROM ANTIQUES
WHERE ITEM = 'Ottoman' AND BUYERID = 01 AND SELLERID = 21;
SQL
Database Indexes
Create Table
SQL Select
SQL Alias
SQL Insert
SQL Update
SQL Delete
SQL Alter
SQL group by & having
SQL Subqueries
SQL Exists, All & Any
SQL Joins
SQL Aggregate Functions
SQL Drop
SQL Union & All
Constraints
Create Views
SQL Transactions