当前位置：网站首页>10. Update operation

10. Update operation

2022-04-23 07:40:00 【Ah Dai cloth clothes cool】

insert into emp(empno,ename,job,hiredate,sal,deptno)
values(9527,' Tang Bohu ',' Painter ',now(),6666,50);

Delete all the salary higher than in the marketing department 5000 The employees'

delete from emp 
where deptno=(select deptno from dept where dname=' The Marketing Department ') 
and sal>5000;

take smith Of job Set to manager,sal Set to 8888,comm Set to 666

update emp 
set 
job='manager',sal=8888,comm=666
where ename='smith';

版权声明
本文为[Ah Dai cloth clothes cool]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/04/202204230622239224.html