mysql update时加了exists后秒出结果,否则需要执行好长时间

雲水禅心

已于 2024-01-16 15:41:50 修改

阅读量493

点赞数 10

文章标签：数据库 mysql

于 2024-01-16 15:22:55 首次发布

本文链接：https://blog.csdn.net/hopefly000/article/details/135626158

版权

update shopping_pay_record
set is_return = 1
where is_return = 0

               and exists(
                       select distinct pay_number from shopping_order_settlement
                               where order_code in
                               (
                                       select distinct source_code from shopping_order where code in ("0040574")
                               )
               )


               and pay_number in
               (
                       select distinct pay_number from shopping_order_settlement
                       where order_code in
                       (
                               select distinct source_code from shopping_order where code in ("0040574")
                       )
               )