MySQL表字段的数据迁移
update ecm_order_goods, ecm_goods, ecm_order
set ecm_order_goods.eu_point=ecm_goods.eu_point, ecm_order_goods.au_point=ecm_goods.au_point
where ecm_order_goods.goods_id=ecm_goods.goods_id and ecm_order.order_id = ecm_order_goods.order_id and ecm_order.add_time < 1508256000;
温馨提示: 本文由Jm博客推荐，转载请保留链接: https://www.jmwww.net/SQL/21281.html
- 上一篇：mysql建库建表插入数据
- 下一篇：【12】MySQL：锁处理
