The DELETE statement is used to remove a row or rows from a table. Use the WHERE clause to specify which rows to remove.
- [Instructor] Use the delete from statement to delete rows … from a table. … Again here we're using the test database and if I select … just the row where the ID equals four from the customer … table you'll notice that the value is the Fred Flintstone … with his address on Cobblestone Way. … And if I come down here and use the delete statement … followed by a select statement, you'll see that we can … delete that row. … Again I need to use a where clause where ID equals four … otherwise it will delete all of the rows in the table … and we certainly don't want that. … So I'm going to say press the F9 key here and you can see … that the row with the ID four is now gone and I can do … the same where ID equals five, which is our Jimi Hendrix … row and if I execute those two statements including … the select statement, you'll see that our database … is now back to its original state. … So to delete rows from a table use the delete from … statement, the where clause specifies which rows to delete. …
This course was created by Bill Weinman. We are pleased to offer this training in our library.
- How databases are organized
- Selecting rows and columns
- Creating new tables
- Inserting and updating data
- Sorting and filtering
- Accessing related tables with JOIN
- Working with strings
- Understanding numeric types
- Using aggregate functions and transactions
- Automating data with triggers
- Creating views
- Using CRUD functions
Skill Level Beginner
2. SQL Overview
3. Fundamental Concepts
7. Dates and Times
Dates and times2m 6s
11. Views and Subselects
12. A Simple CRUD Application
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.