SQL Update Statement with Example
SQL update Statement is used to update/modify existing records/values in a table.
Syntax
UPDATE Table SET column_name =value [WHERE condition]
Update All Rows
UPDATE table
SET column_name = value;
Update specific row
UPDATE table
SET column_name = value;
WHERE conditions ;
Update Multiple Columns
UPDATE table
SET column1 = ‘value1’ ,
column2 = ‘value2’ ,
WHERE conditions;
Example:
EMPLOYEE table having below records:
Updating Employee table
mysql> Update Employee Set CITY='LUCKNOW' where Employee_FirstName='Kalp';
Query OK, 1 row affected (0.36 sec)
Rows matched: 1 Changed: 1 Warnings: 0
Result after updating Record
