Bummer! This is just a preview. You need to be signed in with a Basic account to view the entire video.
Review and Practice0:55 with Andrew Chalkley
Let's review the different types of UPDATE statements and then practice it!
You can create, read and update rows.
Let's recap on how you can construct an update statement.
To update the value in a particular column for all rows, you do,
update, the table name, the key word set, the column name.
The assignment operator, and then the value.
To update any number of rows that match a particular condition,
you can use the WHERE clause with any number of conditions.
Any rows matching the condition will be updated.
Once again, to practice this update syntax,
I've created a sequel playground with some tasks for you to complete.
Familiarize yourself with the schema and data, and then complete the tasks.
You’re almost done with all the CRUD operations.
You can create, read, and update rows.
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