peoples ID age
student ID age
UPDATE peoples SET age=age+(SELECT age FROM student WHERE peoples.id = student.id)
要怎么写才能让peoples表中相同ID数据才更新不同ID不更新
相关分类