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