方式一:
更新student_test表年龄字段为空的数据:
UPDATE student_test br
SET age = ( SELECT age FROM student WHERE NAME = br.NAME )
WHERE
age IS NULL;
方式二:
UPDATE student_test br1,
student br2
SET br1.age = br2.age
WHERE
br1.NAME = br2.NAME;
建议:将student_test表的NAME字段以及student 表的NAME设置为索引
能够提高此语句的执行效率。