transactional/sql/refresh-balance.sql

3 lines
108 B
SQL

DELETE FROM person WHERE id = 3;
DELETE FROM transaction;
UPDATE person SET balance = 1000 WHERE id in (1,2)