表1: person(id, name, age, degree, gender),
表2: teacher(id, name, age, gender);
对于两张表中name相同的列,将person中的age,gender的值复制倒teacher表中:
update teacher t set (t.gender, t.age) = (select p.gender, p.agefrom person p where t.name=p.name)
表1: person(id, name, age, degree, gender),
表2: teacher(id, name, age, gender);
对于两张表中name相同的列,将person中的age,gender的值复制倒teacher表中:
update teacher t set (t.gender, t.age) = (select p.gender, p.agefrom person p where t.name=p.name)