SET GLOBAL group_concat_max_len=102400;
SET SESSION group_concat_max_len = 102400;
UPDATE zqh_coupontemplate_goods a
INNER JOIN (
select GROUP_CONCAT(goods_id) as goods FROM zqh_goods WHERE goods_id NOT IN(10092,8509,8510,8511,8512,8513,8514,8515,8516,8517,8518,8519,8520,8521,8522,8523,8524,8525,8526,8527,8528,8529,8530,8531,8532,2717,2716)
)b
set a.goods_id_true= b.goods
where a.coupontemplate_id in(14,15,16,17,18,19)
mysql 根据查询结果更新表 (多条数据)
最新推荐文章于 2024-07-21 03:28:24 发布