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.

Figure 16 UPDATE command

Indeed, Richard Roe is now with a higher salary.