Database Guide

WHERE clause of UPDATE

The WHERE clause of an UPDATE statement specifies a condition that restricts which rows are to be updated. Only the rows for which the condition is true will be updated.

The WHERE clause is optional. If it is not specified, all the rows in the table or view will be updated.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]