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. 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