Update Data

On this page

This page has instructions for updating rows of data (using the UPDATE statement) in CockroachDB from various programming languages.

Before you begin

Make sure you have already:

Set up a local cluster.
Installed a Postgres client.
Connected to the database.
Inserted data that you now want to update.

Note:

Your application should use a retry loop to handle transaction errors that can occur under contention.

Update a row

UPDATE accounts SET balance = 900 WHERE id = 1;

For more information about how to use the built-in SQL client, see the cockroach sql reference docs.

// tx is a *sql.Tx from "database/sql"

transferAmount := 100
fromID := 1

if _, err := tx.Exec("UPDATE accounts SET balance = balance - $1 WHERE id = $2", transferAmount, fromID); err != nil {
    return err
}

For complete examples, see:

// ds is an org.postgresql.ds.PGSimpleDataSource

int transferAmount = 100;
int fromID = 1;

try (Connection connection = ds.getConnection()) {
    connection.createStatement().executeUpdate("UPDATE accounts SET balance = balance - "
                                               + transferAmount + " where id = " + fromID);

} catch (SQLException e) {
    System.out.printf("sql state = [%s]\ncause = [%s]\nmessage = [%s]\n",
                      e.getSQLState(), e.getCause(), e.getMessage());
}

For complete examples, see:

# conn is a psycopg2 connection

transferAmount = 100
fromID = 1

with conn.cursor() as cur:
    cur.execute("UPDATE accounts SET balance = balance - %s WHERE id = %s",
                (transferAmount, fromID));
conn.commit()

For complete examples, see:

Pricing

Contact us

Sign In

Update Data

Before you begin

Update a row

See also