遇到同表子查询查询结果做为修改条件报错
UPDATE tbl SET is_in = 1
WHERE `code` =
(SELECT `source_code` FROM `tbl` WHERE `code` = '0001680' LIMIT 1 )
改为: UPDATE `tbl, (SELECT `source_code` sourceCode FROM `tbl` WHERE `code` = '0001680' LIMIT 1 ) a
SET is_in = 1
WHERE `code` = a.sourceCode