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;