Apache Derby—Off to the Races: Includes Details of IBM® Cloudscape™

Data Modification

Up to now, all of our SQL has focused on queries. The SELECT statement allows you to retrieve data from your database and assumes that the tables contain data. There are three SQL statements that you can use to add, change, or remove data stored in an Apache Derby database table: INSERT, UPDATE, and DELETE.

To perform these operations, you must have the required privileges on the tables being accessed. These privileges must be granted with caution because they allow end users to modify rows.

Inserting Rows

To initially populate an Apache Derby table with data, use the INSERT statement to store one or more rows at a time. Every row that is populated using the INSERT statement must adhere to table check constraints, data type ...