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

Channel:

We Will Code

Subscribers:

8,020

Published on November 17, 2017 5:26:28 PM ● Video Link: https://www.youtube.com/watch?v=o2B_S3kqtbQ

Duration: 2:09

18 views

2

In this course we go over the syntax for the SELECT statement we wrote in the previous exercise. After going over the SELECT command in further detail, we are asked to UPDATE information in our celebs table. We specify a condition to only UPDATE the row where ID = 1. After updating the row we use the "SELECT * " command to see our updated table WHERE ID = 1.