JDBC Tutorials - Herong's Tutorial Notes
Dr. Herong Yang, Version 2.11

Java DB (Derby) - DML Statements

This chapter provides tutorial notes on executing DML statements with Java DB (Derby) JDBC Driver. Topics include inserting, updating and deleting data rows in existing tables; creating IDENTITY columns; handling date and timestamp values.

Tables with Primary Key Column "GENERATED ... AS IDENTITY"

"INSERT INTO" Statements

"INSERT INTO" Statements with INDENTITY Columns

Handling Date and Timestamp Values

"UPDATE" Statements

"DELETE FROM" Statements

Dr. Herong Yang, updated in 2007
Java DB (Derby) - DML Statements