realtor-lp-backend/sql/property_arrangement/update.sql

13 lines
281 B
MySQL
Raw Permalink Normal View History

UPDATE property_arrangement SET
2023-05-08 18:28:19 +00:00
price = $2,
currency = $3,
arrangement = $4,
last_updated = $5
2023-05-11 15:44:46 +00:00
WHERE property_id = $1 AND arrangement = $4
RETURNING
property_id,
2023-05-08 18:28:19 +00:00
price,
currency,
arrangement as "arrangement: _",
time_created,
last_updated;