O'Reilly logo

Apache Derby—Off to the Races: Includes Details of IBM® Cloudscape™ by Dan Scott, George Baklarz, Paul C. Zikopoulos

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required