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

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

ACUSQLUSGU06-low.gif