salix/db/versions/10862-navyHydrangea/02-updateExpenseRegularize.sql

9 lines
202 B
MySQL
Raw Permalink Normal View History

2024-02-19 12:56:16 +00:00
DELETE FROM vn.expense
WHERE id ='' AND id IS NULL AND isWithheld = FALSE;
2024-02-02 07:05:17 +00:00
UPDATE vn.expense
SET id='7002090000'
WHERE id='7002009000';
UPDATE vn.expense
SET id='7001090000'
WHERE id='7001009000';