报错内容: 1093 – You can’t specify target table ‘t’ for update in FROM clause, Time: 0 前情提示: Mac OS10.14+MySQL8.0.18; centOS6.8final+MySQL5.6; 解决: 方法一:多嵌套一层。多来一层子查询 以上SQL修改如下: UPDATE trace_videorecord SET VideoAddress = 'h8' WHERE VideoID IN ( SELECT * FROM ( SELECT mg.VideoID FROM sale_goods m LEFT J