Updating Data – update.sqb.
The update.sqb program uses a cursor to select rows from a table and update information in the database. The program demonstrates
- the FOR UPDATE clause when declaring a cursor
- positioned updates
- the SET clause
Note: This sample is not supported by MySQL, because it does not support updatable cursors or implement the
UPDATE WHERE CURRENT OF and
DELETE WHERE CURRENT OF phrases. Refer to the MySQL documentation for any changes in database support of these features.
Run the update program to change information for Sam and Sally Snead in the sample data source you created with the create program
