DEFINITIONS

Definitions More Info.
Definition ID1.002
TitlePOSTGRESQL
CategoryNOTES
DefinitionUPDATE with join - join ileupdate etme
Definition Descriptionhttps://www.postgresqltutorial.com/postgresql-update-join/

UPDATE t1
SET t1.c1 = new_value
FROM t2
WHERE t1.c2 = t2.c2;

UPDATE product
SET net_price = price - price * discount
FROM
product_segment
WHERE
product.segment_id = product_segment.id;

UPDATE "IYSPermissionLog"
SET "address" = "PhoneIO"."address"
FROM "public"."PhoneIO"
WHERE "public"."IYSPermissionLog"."id" = "public"."PhoneIO"."id";


UPDATE "PushNotification"."PushNotificationMobileIdentifier"
SET "IsActive"=False, "LastModifyDate"=now()
FROM "PushNotification"."PushNotificationMobileIdentifier_IsactiveNotUpdated_20200128"
WHERE "PushNotification"."PushNotificationMobileIdentifier"."Id"="PushNotification"."PushNotificationMobileIdentifier_IsactiveNotUpdated_20200128"."Id"
RecordBycunay
Record Date28-01-2020 17:26:36
Düzenle
Kopyala
Sil