Update Entry

Let’s give Richard Roe a raise.

UPDATE employees SET employee_salary=20202
WHERE employee_name='Richard Roe'

Now let’s run the SELECT command from the previous section and see if Richard Roe appears now.

Indeed, Richard Roe appears now as he has a higher salary.