update student
set student.name = (select name from student1 where student1.id=student.id),
student.age = (select age from student1 where student1.id=student.id)oracle大概要这样写
set student.name = (select name from student1 where student1.id=student.id),
student.age = (select age from student1 where student1.id=student.id)oracle大概要这样写
set (student.name,student.age)
(select name, age from student1
where student.id = student1.id)
where student.id = student1.id;