同时多个事务内部修改表记录，怎么样避免死锁？

Question

事务1
begin transaction
update t set count= count +1 where id=A
update t set count=cunt+1 where id=b
end transaction

事务2
begin transaction
update t set count= count +1 where id=B
update t set count= count +1 where id=A
end transaction

Answer 1

正确方式，进行将update语句更加id排序。比如永远先更新A，然后更新B