案例1:
UPDATE store_out_odd AS a
JOIN doc_store_position AS b ON a.`position` = b.`code` AND a.`store_id` = b.`store_id`
SET a.`position` = b.id
WHERE a.storage_id IS NULL;
案例2:
UPDATE
store_storage AS ss
JOIN doc_store_position AS dsp ON ss.`position` = dsp.id
JOIN doc_store_position AS zsp ON dsp.`code`=zsp.`code` AND ss.`store_id`=zsp.`store_id`
SET ss.`position`=zsp.id
WHERE ss.`store_id` != dsp.`store_id`