Scribd
Upload
5 views1 page

Program Customer Status Update SQL

The document contains SQL commands to update the status of multiple entries in the 'program_customer' table. Specifically, it sets the status to 'WAITING_TO_PAY' for a group of IDs and includes several commented-out commands for setting other statuses. The transaction is wrapped in a BEGIN and COMMIT statement to ensure atomicity.

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
5 views1 page

Program Customer Status Update SQL

The document contains SQL commands to update the status of multiple entries in the 'program_customer' table. Specifically, it sets the status to 'WAITING_TO_PAY' for a group of IDs and includes several commented-out commands for setting other statuses. The transaction is wrapped in a BEGIN and COMMIT statement to ensure atomicity.

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

BEGIN;

UPDATE "public"."program_customer" SET "status" = 'WAITING_TO_PAY' WHERE id in


(2110,2114,2116,2109,2113,2111,2108,2112,2115);
-- UPDATE "public"."program_customer" SET "status" = 'CREATED' WHERE "id" = 2110;
-- UPDATE "public"."program_customer" SET "status" = 'CREATED' WHERE "id" = 2114;
-- UPDATE "public"."program_customer" SET "status" = 'CREATED' WHERE "id" = 2116;
-- UPDATE "public"."program_customer" SET "status" = 'CREATED' WHERE "id" = 2109;
-- UPDATE "public"."program_customer" SET "status" = 'WAITING_KT_AP_APPROVE_ADJUST'
WHERE "id" = 2113;
-- UPDATE "public"."program_customer" SET "status" = 'CREATED' WHERE "id" = 2111;
-- UPDATE "public"."program_customer" SET "status" = 'CREATED' WHERE "id" = 2108;
-- UPDATE "public"."program_customer" SET "status" = 'WAITING_KT_AP_APPROVE_ADJUST'
WHERE "id" = 2112;
-- UPDATE "public"."program_customer" SET "status" = 'CREATED' WHERE "id" = 2115;
COMMIT;

You might also like