syntax of update dbms code example

Example: update query in mysql

-- Set New Employee Password 
UPDATE employee
SET employee.password = '1234'
WHERE employee.email = 'emp@gmail.com';