what is primary key code example
Example 1: how to make multiple keys as primary in bdms
CREATE TABLE `Donor`(
`did` int(50) NOT NULL,
`oid` int(50) NOT NULL,
`dname` varchar(50) NOT NULL,
`dblood` varchar(50) NOT NULL,
PRIMARY KEY (`did`, `oid`)
);
Example 2: what is primary key
Primary Key :
It is unique column in every table in a database
It can ONLY accept;
- nonduplicate values
- cannot be NULL
Foreign Key:
It is a column that comes from a different table and
using Foreign key tables are related each other
It is the primary key of another table
It can be duplicate or null for another table
Unique Key:
Only unique value and also can contain NULL
Example 3: primary key in sql
PRIMARY KEY
Example 4: what is primary key
PRIMARY KEY
Example 5: primary key
Primary Key :
It is unique column in every table in a database
It can ONLY accept;
- nonduplicate values
- cannot be NULL