Previous Next JavaScript must be enabled to correctly display this content

## Access and Manipulate Multi-Region Tables

After creating the MR Table, you can perform read or write operations on the table using the existing data access APIs or DML statements. There is no change to any existing data access APIs or DML statements to work with the MR Tables. See Data Row Management in the SQL Reference Guide.

Example:

Perform DML operations on the `users` table in one region, and verify if the changes are replicated to the other region.

    # To be executed in the fra region
    -- Insert two rows into the users MR Table
    sql-> INSERT INTO users(id,name,team) VALUES(1,"Amy","HR");
    {"NumRowsInserted":1}
    1 row returned
    sql-> INSERT INTO users(id,name,team) VALUES(2,"Jack","HR");
    {"NumRowsInserted":1}
    1 row returned

    # To be executed in the lnd region
    -- Verify if the rows are replicated from the fra region
    sql-> SELECT * FROM users;
    {"id":1,"name":"Amy","team":"HR"}
    {"id":2,"name":"Jack","team":"HR"}

    2 rows returned

    -- Update the row with id = 2 in the users MR Table
    sql-> UPDATE users SET team = "IT" WHERE id = 2;
    {"NumRowsUpdated":1}
    1 row returned

    -- Delete the row with id = 1 from the users MR Table
    sql-> DELETE FROM users WHERE id = 1;
    {"NumRowsDeleted":1}
    1 row returned

    # To be executed in the fra region
    -- Verify if the changes are replicated from the lnd region
    sql-> SELECT * FROM users;
    {"id":2,"name":"Jack","team":"IT"}
    1 row returned