DELETE Statements
DELETE statements are used to remove existing data from a table.
A DELETE statement will have 2 parts
Specify the table that the record is to be deleted from
The criteria to specify which record(s) will be deleted.
DELETE Statements - Single Record
DELETE Statements - Single Record
The BMX Advanced course on the 4th May is now cancelled so should be deleted.
DELETE Query Design
SQL Statement Example
SQL Statement Example
DELETE Statements - Multiple Records
DELETE Statements - Multiple Records
An Instructor’s qualifications have changed so there will be no more Abseiling Courses
DELETE Query Design
SQL Tutorial 4 DELETE Statements
SQL Tutorial 4 DELETE Statements
6 SQL DELETE.mp4
This video will demonstrate how to use a DELETE query to remove rows from a table.