SQL's UPDATE Command, Learn SQL, Codecademy, Manipulation

Channel:

We Will Code

Subscribers:

8,020

Published on November 20, 2017 5:00:09 PM ● Video Link: https://www.youtube.com/watch?v=qAvUNAmTgFw

Duration: 1:54

175 views

3

In this lesson we look at the command from the previous lesson in more detail. We learn that "UPDATE" is a clause that will allow us to edit a row in a table. After the update keyword is the name of the table(s) you want to target. After the table name, the keyword SET is used to indicate which column(s) to edit, followed by the column name. They keyword WHERE is used to specify a condition that needs to be met.