keep all primary keys in one table 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: primary key sql

CREATE TABLE student

(

Roll integer (15) NOT NULL PRIMARY KEY,

Name varchar (255),

Class varchar (255),

Contact No varchar (255),

);

Tags:

Sql Example

Related