UPDATE `table1` SET `colum_1` = ‘value’ WHERE table1.sku=any(SELECT `sku` FROM `table2` WHERE `colum_2` = ”)
UPDATE `table1` SET `colum_1` = ‘value’ WHERE table1.sku=any(SELECT `sku` FROM `table2` WHERE `colum_2` = ”)
除非注明， askADC博客 的文章均为原创，转载请注明作者和出处。
本文链接地址: http://blog.askadc.com/mysql%e6%9b%b4%e6%96%b0%e8%a1%a82-%e6%9d%a1%e4%bb%b6%e4%b8%ba%e6%9f%a5%e6%89%be%e8%a1%a81%e7%9a%84%e5%86%85%e5%ae%b9/