mysql update join 效率_mysql update join优化update in查询效率
数据库版本:5.6.16update in 修改数据,结果执行时间过慢,一直不出结果。SQL语句及执行计划如下:UPDATE erp_order_extra SET last_time=123123123123WHERE order_id IN (SELECT eo.order_id FROM jiuxianweb.erp_order eo WHERE eo.channel_ordersn='18...