方法1 demo是将class_name赋值为 company UPDATE work w SET w.class_name = ( SELECT a.company FROM ( SELECT * FROM work ) a WHERE a.id = w.id ) 方法2 update table_1 t1,table_2 t2 set t1.column = t2.column where t1.id = t2.pid;