Using the Relational Data Framework › Table Management Operations › Update Values in a Table

Previous Topic: Insert a Row into a Table

Next Topic: Use the Relational Table Editor Batch API

Update Values in a Table

To update values in a table, use the UPDATE statement.

Suppose you want to update values in the table APPLICATIONS when the STATUS column has a value of DOWN. To change the status to UP for these rows, issue this command:

OPSQL UPDATE APPLICATIONS SET STATUS = 'UP' WHERE STATUS = 'DOWN'