-- 一个表内移植字段值
UPDATE tbl a SET a.student_id=a.old_student_id;
-- 根据总表id匹配到招标供应商id,并关联到入库单
update tbl a, tcl b, tdl c
SET a.student_id = b.id
WHERE a.student_id =c.id AND b.student_id =c.id;
-- 一个表内移植字段值
UPDATE tbl a SET a.student_id=a.old_student_id;
-- 根据总表id匹配到招标供应商id,并关联到入库单
update tbl a, tcl b, tdl c
SET a.student_id = b.id
WHERE a.student_id =c.id AND b.student_id =c.id;