From the course: SQL Essential Training
Join today to access over 23,200 courses taught by industry experts.
Deleting data - SQL Tutorial
From the course: SQL Essential Training
Deleting data
- [Instructor] The final DML statement we're going to take a look at is the delete statement. Now the delete statement is used to remove existing records from a table, and just like the update, it is usually used with the where clause. Without the where clause, using a delete statement will delete every single record from your table. Now this is extremely important and again very important to include the where clause when using a delete statement. So let's demonstrate the use of a delete statement and remove our record that we have just inserted. So once again, we've gotten word from the management at WSDA Music that once again there has been a little bit of a mix up. They have now decided to remove altogether the newly added then modified artist Damien Marley from the database. Let's see how we would construct a DML statement to remove this record. Now we do need a few new keywords, starting with delete. So we specify…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.