select @pid := pid from accounttxlog where userId = 3055 and transactionType=4 and flowType=0 ORDER BY modifyAt DESC limit 1;
update accounttxlog set amount=117777, balance=117777 where pid=@pid;
适用于mysql
update accounttxlog set amount=117777, balance=117777 where pid=@pid;
适用于mysql