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,…
Author
Released
7/2/2018- 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
Duration
Views
Related Courses
-
Introduction
-
Welcome1m 16s
-
Exercise files2m 21s
-
Course overview1m 38s
-
-
1. Installation
-
Installing on Windows: Part II10m 16s
-
Installing on a Mac: Part I6m 45s
-
Installing on a Mac: Part II12m 10s
-
2. SQL Overview
-
About the overview3m 39s
-
Database organization2m 54s
-
The SELECT statement5m 49s
-
Selecting rows2m 3s
-
Selecting columns1m 29s
-
Counting rows2m 42s
-
Inserting data3m 9s
-
Updating data2m 28s
-
Deleting data1m 42s
-
-
3. Fundamental Concepts
-
Creating a table3m 40s
-
Deleting a table2m 14s
-
Inserting rows3m 31s
-
Deleting rows1m 55s
-
The NULL value5m 22s
-
Constraining columns3m 17s
-
Changing a schema2m 3s
-
ID columns2m 21s
-
Filtering data5m 43s
-
Removing duplicates2m 37s
-
Ordering output2m 23s
-
Conditional expressions2m 30s
-
-
4. Relationships
-
Understanding JOIN2m 19s
-
Accessing related tables4m 31s
-
Relating multiple tables4m 27s
-
-
5. Strings
-
About SQL strings1m 33s
-
Removing spaces2m 26s
-
Folding case2m 13s
-
-
6. Numbers
-
Numeric types3m 32s
-
What type is that value?2m 12s
-
Integer division1m 56s
-
Rounding numbers1m 2s
-
-
7. Dates and Times
-
Dates and times1m 52s
-
-
8. Aggregates
-
What are aggregates?4m 38s
-
Using aggregate functions1m 57s
-
Aggregating DISTINCT values1m 53s
-
-
9. Transactions
-
What are transactions?2m 2s
-
Data integrity3m 10s
-
Performance3m 27s
-
-
10. Triggers
-
Preventing updates2m 36s
-
Example: Timestamps2m 26s
-
11. Views and Subselects
-
Creating a subselect3m 47s
-
Creating a view3m 32s
-
Creating a joined view2m 32s
-
-
12. Defined Functions
-
Overview1m 7s
-
Defining functions in PHP4m 27s
-
-
13. A Simple CRUD Application
-
Embedding SQL4m 50s
-
The SELECT functions3m 30s
-
-
Conclusion
-
Goodbye1m 3s
-
- 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.
CancelTake 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.
Share this video
Embed this video
Video: Updating data