Using UPDATE

You can use an UPDATE statement to change the data in a row that is already in a table. UPDATE statements let you modify specific columns in a row. Also, you can use a WHERE clause in an UPDATE statement to specify which rows for Pervasive PSQL to change. This is referred to as a searched update. Using SQL declared cursors and the Positioned UPDATE statement, you can update the current row of a declared cursor from which you are fetching data.

UPDATE Course
SET Credit_Hours = 4
WHERE Course.Name = 'Math'#

This example instructs Pervasive PSQL to find the row that contains the course name Math and change the Credit Hours column value to 4.

As shown in the previous example, you can use a constant to update a column by placing it on the right hand side of a SET clause in an UPDATE statement.