Inserting data with INSERT

    Add data to the table using INSERT INTO:

    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.

    INSERT INTO episodes
    (
        series_id,
        season_id,
        episode_id,
        title,
        air_date
    )
    VALUES
    (
        2,
        5,
        21,
        "Test 21",
        CAST(Date("2018-08-27") AS Uint64)
    ),                                        -- Rows are separated by commas.
    (
        2,
        5,
        22,
        "Test 22",
        CAST(Date("2018-08-27") AS Uint64)
    )
    ;
    
    COMMIT;
    
    -- View result:
    SELECT * FROM episodes WHERE series_id = 2 AND season_id = 5;
    
    COMMIT;