Updating data in tables
59.6
Exercise

Updating data in all rows

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

  1. set price of all the books as 500

  2. set publisherName of all the books as NULL