DELETE


InterServer Web Hosting and VPS
Sony Playstation PS4 Pro Custom Build NVMe SSD Drive - Enclosure case and Crucial NVMe SSD
PS4 Pro Custom External SSD NVMe Drive

How I built a PS4 Pro Custom External SSD NVMe Drive...

NUC8i7BEH with memory
Intel NUC8I7BEH Review and Custom Build

This is my review of the Intel NUC8i7BEH and a summary of my build...

Card image cap
Asus M5A88-M EVO Review

This is my review of the Asus M5A88-M EVO motherboard...

Corsair Vengeance Blue 8GB (2x4GB) DDR3 PC3-12800C9 1600MHz Dual Channel Kit
Corsair Vengeance Blue Review

This is my review of the Corsair Vengeance Blue 8GB (2x4GB) DDR3 PC3-12800C9 1600MHz Dual Channel Kit memory...

Robotic Arm with USB PC Interface Review
Robotic Arm with USB PC Interface Review

This is my review of the Robotic Arm with USB PC Interface...

DELETE

Here we look at the Delete command in SQL.

The Delete command in SQL allows us to delete data from a table in our database. It can be used to delete one row, multiple rows and all the rows.

In our first example, we delete a row where the ProductID is equal to 12345. This query would actually delete all the rows with a ProductID of 12345, so be careful.


-- Delete any row where ProductID = '12345'
DELETE FROM Products WHERE ProductID = '12345'


The following example will delete all the data in your database table.


-- Delete all the data in the table
DELETE FROM Products


The following example will delete rows where the price is between 11.00 and 14.00, including if the price is 11.00 or 14.00.


-- Delete all the rows where the
-- price is between 11.00 and 14.00 inclusively
DELETE FROM Products WHERE Price >= '11.00' AND Price <= '14.00'


Sponsored Links
SolarSystem - AngularJS Demo
SolarSystem - Angular JS Demo

Check out my first Angular JS demo hosted in Azure, it helped win my first Angular contract. Put the sound on.