Set the autocommit=0;
Start the transaction;
The set sql_safe_updates=0;
Update the account set the balance=500 where username='zhang mowgli';
Update the account set the balance=1500 where username='zhao';

commit;
Why this transaction execution only performs every time the first modify command, refer to