Updating data with UPDATE
Update data in the table using the UPDATE operator:
Note
We assume that you already created tables in step Creating a table and populated them with data in step Adding data to a table.
UPDATE episodes
SET title="test Episode 2"
WHERE
series_id = 2
AND season_id = 5
AND episode_id = 12
;
COMMIT;
-- View result:
SELECT * FROM episodes WHERE series_id = 2 AND season_id = 5;
-- YDB doesn't see changes that take place at the start of the transaction,
-- which is why it first performs a read. You can't UPDATE or DELETE a table
-- already changed within the current transaction. UPDATE ON and
-- DELETE ON let you read, update, and delete multiple rows from one table
-- within a single transaction.
$to_update = (
SELECT series_id,
season_id,
episode_id,
Utf8("Yesterday's Jam UPDATED") AS title
FROM episodes
WHERE series_id = 1 AND season_id = 1 AND episode_id = 1
);
SELECT * FROM episodes WHERE series_id = 1 AND season_id = 1;
UPDATE episodes ON
SELECT * FROM $to_update;
COMMIT;
-- View result:
SELECT * FROM episodes WHERE series_id = 1 AND season_id = 1;
COMMIT;