Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll
Preview
Start a free Courses trial
to watch this video
Let's review the different types of UPDATE statements and then practice it!
You can create, read and update rows.
0:00
Let's recap on how you can
construct an update statement.
0:03
To update the value in a particular
column for all rows, you do,
0:06
update, the table name,
the key word set, the column name.
0:11
The assignment operator,
and then the value.
0:17
To update any number of rows that
match a particular condition,
0:20
you can use the WHERE clause with
any number of conditions.
0:25
Any rows matching
the condition will be updated.
0:29
Once again,
to practice this update syntax,
0:33
I've created a sequel playground
with some tasks for you to complete.
0:35
Familiarize yourself with the schema and
data, and then complete the tasks.
0:40
You’re almost done with
all the CRUD operations.
0:45
You can create, read, and update rows.
0:47
You’ll find out how to perform the final
CRUD operation in the next stage.
0:50
You need to sign up for Treehouse in order to download course files.
Sign up