Tag: UPDATE Statement in SQL

Use of UPDATE Statement in SQL

Use of UPDATE Statement in SQL: (1) “UPDATE” statement is used to modify records. (2) Syntax of “UPDATE” statement is: UPDATE table_nameSET column1 = value1, column2 = value2, … column = valueNWHERE condition; WHERE clause is used to specify which record should be modified. (3) Let’s take an example to update/modify records in the Vendor table as shown. …