EN
MySQL - multiple queries in one transaction
9
points
In this short article, we would like to show how using MySQL, create a transition that makes multiple queries in one atomic operation.
Quick solution:
START TRANSACTION;
SELECT @sum := SUM(`salary`) FROM `user` WHERE `role` = 'seller';
UPDATE `report` SET `summary` = @sum WHERE `role` = 'seller';
COMMIT;