-
SQL – Update Statement
SQL Update Statement Table Of Contents: What Is SQL Update Statement? Syntax Of Update Statment. Examples Of Update Statement. (1) What Is SQL Update Statement ? The UPDATE statement is used to modify the existing records in a table. If the user wants to update their records at a later point in time they can do that using the “UPDATE” statement. (2) Syntax Of SQL Update Statement. Syntax: UPDATE table_name SET column1 = value1, column2 = value2, … WHERE condition; (3) Examples Of SQL Update Statement. Demo Data: Example-1: Updating A Single Record UPDATE Customers SET ContactName=’Alfred Schmidt’, City=’Frankfurt’ WHERE CustomerID=1;
