Scribd
Upload
4 views2 pages

MySQL Holiday Homework

Students are required to complete their MySQL Holiday Homework Practical File, which includes creating a STUDENT table and inserting specified records. They must perform various MySQL commands, such as displaying student details, updating records, and grouping data. The final file should be well-presented with clear commands and screenshots of outputs for each task.

Uploaded by

rukmani.jaithaya
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
4 views2 pages

MySQL Holiday Homework

Students are required to complete their MySQL Holiday Homework Practical File, which includes creating a STUDENT table and inserting specified records. They must perform various MySQL commands, such as displaying student details, updating records, and grouping data. The final file should be well-presented with clear commands and screenshots of outputs for each task.

Uploaded by

rukmani.jaithaya
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Holiday Homework (class 12)

MySQL Practical File


Dear Students,

Complete your MySQL Holiday Homework Practical File neatly on practical sheets. Write all
the given commands clearly and neatly.

Paste screenshots of both the commands and their outputs in front of each question
properly.

The file should be clean, well-presented, and complete.

Table: STUDENT
Create the following table and insert the given records.

RollNo Name Class Section Marks City

101 Aman XII A 89 Delhi

102 Riya XII B 76 Mumbai

103 Karan XI A 91 Jaipur

104 Simran XII C 67 Delhi

105 Rohit XI B 82 Lucknow

Perform the Following MySQL Commands


1. Create the table STUDENT with appropriate data types and constraints.

2. Insert all the above records into the STUDENT table.

3. Display complete details of all students.

4. Display the names and marks of students scoring more than 80 marks.

5. Add a new column named Phone_No in the STUDENT table.

6. Update the marks of student “Riya” from 76 to 85.

7. Display students whose names start with the letter “R”.

8. Display students whose names end with the letter “n”.


9. Display student records in ascending order of Marks using ORDER BY clause.

10. Display total number of students city-wise using GROUP BY clause.

You might also like