hgducharme / SQL-Basics

An introductory e-book to SQL & how to develop queries.
https://app.gitbook.com/@hunter-ducharme/s/sql-basics/
14 stars 10 forks source link

Fix UPDATE statement update_commands.md #3

Closed gb69010p closed 8 years ago

gb69010p commented 9 years ago

Fixes code to exclude the value of ratingDate for reviews by uID 207 on 2014-03-07 and 2014-03-26 from being updated. It also updates the phrasing of the last paragraph to reflect code changes.

The previous statement updated all reviews by the uIDs, even if they already had a date assigned. According to the example database in the introduction that would include all reviews by users, even if there was already a ratingDate.