update lps_trade_deal d set goods_name=(select goods_name from lps_goods g where g.goods_code=d.goods_code) where d.id>0;
把一张表的字段更新到另外一张表
最新推荐文章于 2024-07-23 14:05:29 发布
update lps_trade_deal d set goods_name=(select goods_name from lps_goods g where g.goods_code=d.goods_code) where d.id>0;