primary key can be composite? code example
Example 1: how to define a composite primary key in sql
CREATE TABLE person(id INT,
name TEXT,
PRIMARY KEY (id, name)
);
Example 2: 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`)
);