UPDATE t_invests INNER JOIN t_user_coupons ON t_invests.user_coupon_id = t_user_coupons.id SET t_invests.virtual_product_id = t_user_coupons.virtual_product_id WHERE t_user_coupons.virtual_product_id > 0;
原文：http://www.cnblogs.com/weixiaole/p/5976590.html