The following table shows the results from the SELECT statement after the changes have been made: In the previous example, the same column is specified in both the SET and WHERE clauses.
However, the WHERE clause is not restricted in this way.
However, you’ll often want to update only specific rows. To limit the rows that are updated when you issue an UPDATE statement, add a WHERE clause after the SET clause.
In that sense, the two clauses are independent of each other.In addition, the statement can include a WHERE clause, which determines what rows to modify, or a FROM clause, which identifies tables or views that provide values for the expressions defined in the SET clause.In this article, I discuss how to use the UPDATE statement to modify data.That means that you can be as specific in one clause as necessary.For example, in the following UPDATE statement, I modify the row with the Full Name value of Stephen Jiang: As you can see, the WHERE clause limits the rows being updated to those that include the Full Name value of Stephen Jiang (again, only one row).