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-09-15 08:03:51 发布
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;