Updating data with UPDATE
Update data in the table using the UPDATE operator:
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;