summaryrefslogtreecommitdiffstats
path: root/tests/data/parser/parseTransaction.in
blob: 51c7e8ba56fa42879cfbc75816eeeea6a6c4230a (plain)
1
2
3
4
START TRANSACTION;
SELECT @A:=SUM(salary) FROM table1 WHERE type=1;
UPDATE table2 SET summary=@A WHERE type=1;
COMMIT;