1. Learn
  2. /
  3. Courses
  4. /
  5. Introduction to SQL Server

Connected

Exercise

Update

You may sometimes have to update the rows in a table. For example, in the album table, there is a row with a very long album title, and you may want to shorten it.

You don't want to delete the record - you just want to update it in place. To do this, you need to specify the album_id to ensure that only the desired row is updated and all others are not modified.

Instructions 1/3

undefined XP
    1
    2
    3
  • Select the title column from the album table where the album_id is 213.