SQL DELETE allows you to remove data from your table(s).  It is imperative that you include a where clause in your delete statement, as experience has taught me the concequences of forgeting.

For the sake of argument, lets remove the same record we added back on the INSERT page.

nID

nLegs

strColor

strSize

strType

nWeight

 

          5                    4                  Purple             Medium           Kitchen              20

To do this we will use an DELETE command.  Again, once we have completed, we will want to execute a COMMIT;  If you have not reviewed the commit, head over to the UPDATE page.

DELETE FROM  <Table Name>

WHERE <Column Name> [= < > != BETWEEN NOT] <Column Name or Value> [AND/OR] [<Column Name> [= < > != BETWEEN NOT] etc.]

COMMIT;

DELETE FROM tblChair

WHERE nID = 5;

COMMIT;

nID

nLegs

strColor

strSize

strType

nWeight