当 dispatch_mobile_order 表只有主键锁; did字段没有加索引会导致死锁;只需要did字段加上索引
dispatch_mobile_order 表只有主键锁 此时 update dispatch_mobile_order set xxx where did = ***
会出现主键锁
当 dispatch_mobile_order 表只有主键锁; did字段没有加索引会导致死锁;只需要did字段加上索引
dispatch_mobile_order 表只有主键锁 此时 update dispatch_mobile_order set xxx where did = ***
会出现主键锁