UPDATE emp e left join dept d on e.empno =d.empno SET e.ename = 'SMITH'
where e.emp=6379;
1、update table_1 t1, table_2 t2 set t1.b=t2.b(table_1的b全部被替换成table_2中的第一条b(2))
结果为:
2、update table_1 t1 inner join table_2 t2 on t1.a=t2.a set t1.b=t2.b
结果为:
1、将王文老师教的课程的学生英语成绩都加15分
sql语句: update
(tb_score t inner join tb_course t1 inner join tb_student t2 on t.cid=t1.cid and t.sid=t2.sid and t1.cname='英语' and t1.teacher='王文')
set t.grade=t.grade+15
结果为:
2、写出一份学生数学成绩排名的花名册,成绩从高到底排序,要求:学生 id,学生姓名,成绩,排名。
sql语句:select tt.sid,tt.sname,tt.grade ,(@b:=@b+1) sort from
(select t.sid,t.sname,t1.grade from tb_student t left join tb_score t1 on t.sid=t1.sid and t1.cid=(select cid from tb_course where cname="数学") order by grade desc) tt,(select @b:=0) b
结果为:
因为ls没有数学成绩。