salix/db/versions/10862-navyHydrangea/04-updateExpenseConflict.sql

7 lines
113 B
SQL

UPDATE vn.expense
SET id = CASE id
WHEN 7000100000 THEN 7001010000
ELSE id
END
WHERE id IN (7000100000);