Question

37.
Write the answer based on the following table: RPS Olympiad.
(1) Write a query to display all records.
(ü) Write a query to modify the mode of exam of R001 from online to offline.
(ü) Write the query to add a new row/record with following details
(R005, Chirag, '10', Gurgaon', Online)
(iv) Write the query to add a new field name as DOB.
(v) Write a query to delete a record whose registration ID is R001.​

Answer 1

Answer:

i) SELECT * FROM `rps olympaid`;

ii) UPDATE `rps olympaid` SET `Mode of Exam`='Offline' WHERE `Registration ID`='R001';

iii) INSERT INTO `rps olympaid`(`Registration ID`,`S' Name`,Class,Location,`Mode of Exam`)VALUES('R005','Chirag','10','Guragon','Online');

iv) ALTER TABLE `rps olympaid` ADD COLUMN DOB DATE;

v) DELETE FROM `rps olympaid` WHERE `Registration ID`='R001';