Scribd
Upload
19 views1 page

Update Inventory Receiving

The document contains a series of SQL update commands that set the 'status' field to 'NULL' for various entries in the 'inventory_receiving' table based on their IDs. Each ID corresponds to a specific entry that has been marked with a status of 'OPENED' or 'EDITED'. The commands are executed within a transaction that is committed at the end.

Uploaded by

Bonbihandmade
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
19 views1 page

Update Inventory Receiving

The document contains a series of SQL update commands that set the 'status' field to 'NULL' for various entries in the 'inventory_receiving' table based on their IDs. Each ID corresponds to a specific entry that has been marked with a status of 'OPENED' or 'EDITED'. The commands are executed within a transaction that is committed at the end.

Uploaded by

Bonbihandmade
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 1

BEGIN;

UPDATE "inventory_receiving" SET "status" = 'NULL' WHERE "id" = 57436 ;


UPDATE "inventory_receiving" SET "status" = 'NULL' WHERE "id" = 56787 ;
UPDATE "inventory_receiving" SET "status" = 'NULL' WHERE "id" = 56909 ;
UPDATE "inventory_receiving" SET "status" = 'NULL' WHERE "id" = 59531 ;
UPDATE "inventory_receiving" SET "status" = 'NULL' WHERE "id" = 56534 ;
UPDATE "inventory_receiving" SET "status" = 'NULL' WHERE "id" = 56879 ;
UPDATE "inventory_receiving" SET "status" = 'NULL' WHERE "id" = 59411 ;
UPDATE "inventory_receiving" SET "status" = 'NULL' WHERE "id" = 58999 ;
UPDATE "inventory_receiving" SET "status" = 'NULL' WHERE "id" = 60483 ;
-- 57436 OPENED
-- 56787 OPENED
-- 56909 OPENED
-- 59531 OPENED
-- 56534 OPENED
-- 56879 OPENED
-- 59411 EDITED
-- 58999 OPENED
-- 60483 OPENED
COMMIT;

You might also like