Question

Given below is a Table Patient :

              Table : PATIENT

P_No	Patient Name	DocID
1	Neerj	101
2	Mohit	201
3	Ragini	101
4	Mohit	102
5	Nandini	201

(i) Identify Primary key in the table given above.

(ii) Write MySQL query to add a column department with data type Varchar and Size 30 in the table Patient.

Answer 1

(i) P_No

(ii) ALTER TABLE Patient ADD (Department varchar(30));