11 lines
141 B
SQL
11 lines
141 B
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;
|