qfedu-linux-advanced-level/day9/update_employee.sql

use studb;

update t_emp
set salary = salary + 1000;

update t_emp
set salary = salary * 1.15
where tel like '%8979$';

select * from t_emp;