Learn how the DELETE statement is used to remove a row or rows from a table and the WHERE clause is used to specify which rows to remove.
- [Narrator] To delete rows from a table,…use the "delete from" statement.…Start by selecting the test data base again,…and I'm just going to put in a select statement…to see what's in the customer table.…And, here we see we have five rows…and row four and row five are rows…that we had added since we began.…So, we might want to delete those.…So, first thing I'm going to do is,…I'm going to select from customer "where ID equals four",…and the reason I'm doing this is…because the "delete from" statement uses the "where" clause…to determine which rows to delete…and so, I'm kind of auditioning the "where" clause…to make sure I have it right and when I press go,…you see it shows me that one row, and I'm like,…yeah, that's the row that I want to delete.…
So, I can say "delete from", and then I'll go ahead…and I'll put this select asterisk from customer…after it so we can see what the table…looks like after the "delete from".…So, "delete from customer where ID equals four",…I'm using a "where" clause just like I would…
- Understanding SQL terminology and syntax
- Creating new tables
- Inserting and updating data
- Writing basic SQL queries
- 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
- Defining functions in PHP
Skill Level Beginner
2. SQL Overview
3. Fundamental Concepts
7. Dates and Times
Dates and times1m 52s
11. Views and Subselects
12. Defined Functions
13. 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.