Learn how the UPDATE statement is used to modify the contents of an existing row, or the specific columns in a row in a table.
- To change the data in a table, use the update command.…Let's start by choosing the test database,…and I'm just gonna take a look at the…customer table with the select statement.…Select, asterisk, from, and customer.…When I press go, I get the table with five rows.…You notice that the row with the ID number five…has no data in address and zip.…We're gonna go ahead and fix that,…put some data in that row.…
I'm gonna copy and paste, so command + C to copy,…and command + V to paste.…Paste this statement into SID,…and this is an update statement,…and it specifies the table,…so update and then the table name.…And then, set and a list of assignments.…So you assign a literal string,…in this case, to the address column, and…a literal string to the zip column.…Then there's a where clause to indicate…which rows are going to be updated,…and this is where ID equals five,…so that's this row here with Jimi Hendrix.…
We're going to set the address column…to this string and the zip column to that string.…We have select after the update,…
- 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.