xxxxxxxxxx
UPDATE `table_name` SET `column1` = value1, `column2` = value2 WHERE condition;
xxxxxxxxxx
--update query example
UPDATE table_name
SET column1 = value1, column2 = value2,
WHERE condition;
xxxxxxxxxx
/* modify data in a database table */
UPDATE Customers SET City = 'New York' WHERE CustomerID = 1;
xxxxxxxxxx
UPDATE table_name
SET column_name1 = value1, column_name2 = value2
WHERE condition;
xxxxxxxxxx
UPDATE table_name
SET column1 = value1, column2 = value2,
WHERE condition;
--ex
update employee
set employee.salary = 14000
where employee.id = 12;
xxxxxxxxxx
UPDATE table_name
SET column1 = value1, column2 = value2,
WHERE condition;