Updating data in tables
59.4
Exercise

Updating data in multiple columns

We have a table books below. Write an SQL statement to:

  1. set price as NULL

  2. add 'Sold Out - ' in the beginning of the name

  3. update publisherName to HYDRA Corp.

for all the books whose publisherName is HYDRA Inc.

Note: If you want to add 'Prefix - ' to values in a column x, add x = 'Prefix - ' || x in the SET list.