salix/db/versions/11342-crimsonDendro/02-itemShelving.sql

3 lines
115 B
MySQL
Raw Permalink Normal View History

2024-11-15 07:45:28 +00:00
UPDATE vn.itemShelving ish
JOIN tmp.tItemShelving tish ON tish.id = ish.id
SET ish.shelvingFk = tish.shelvingFk;