DB section has been updated to add some SQL code.
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.
The BMX Advanced course on the 4th May is now cancelled so should be deleted.
DELETE Query Design
An Instructor’s qualifications have changed so there will be no more Abseiling Courses
DELETE Query Design
This video will demonstrate how to use a DELETE query to remove rows from a table.