An SQL UPDATE statement changes the data of one or more records in a table. Either all the rows can be updated, or a subset may be chosen using a condition.
UPDATEstatement has the following form:
SETcolumn_name = value [, column_name = value ...] [
UPDATEto be successful, the user must have data manipulation privileges (
UPDATEprivilege) on the table or column, the updated value must not conflict with all the applicable constraints (such as primary keys, unique indexes,