The Candidate key can be categorized into two parts. In this table, the first 4 rows ( identit圜ardNo, voterId, passportNo, and drivingLCNo) are unique so they are the Candidate key column. It holds unique values.Įxample:- We have a table “Personal_info” and it have following columns. But before developing a JDBC program let us discuss some points on the Candidate key column.Ĭandidate key column:- The column in the database table whose value can be used to identify the record and to access them is called a candidate key column.
In these programs, we will use the PreparedStatement object. In this JDBC tutorial, we will discuss how to use auto-increment value as the primary key or how to generate primary key values dynamically using surrogate key columns.
0 kommentar(er)
