Question

Consider the following table Student_info and write the queries.
Table: Student_info
Student_Rollno Name_of_father Name_of_mother City_or_town
2212 Vijay Chand Sheela Kumari Nizamabad
3321 Madan Dhoni Kavita Devi Nematabad
2276 Kushal Pandit Rera Kumari Khulna
1166 Rahul Koshiyari Vimla Devi Kusumbad

1. Write a command to insert a new record with the following values: (3332, ‘Dev
Kumar’, ‘Amit Bhandari’, Dhanbad)
2. Write a query to display all the records of the table Stud_info whose name of father
starts with ‘Vijay’.
3. Write a query to delete the row of the table with the roll number starting with 2.
4. Write a query to update the Student_Rollno: ‘1166’ as ’4586’.

Answer 1

Explanation:

1. INSERT INTO student-info VALUES ( ' 3332 ', 'Dev kumar', 'Amit Bhandari', Dhanbad);
2. SELECT * FROM student-info WHEREname of father Vijay;
3. DELETE FROM student-info WHERE roll number starting with 2;
4. UPDATE student-info SET (roll number 1166 as 4586 );