Scribd
Upload
5 views2 pages

Write Mysql Queries To

The document provides a series of MySQL queries to manage a database named MySchool. It includes commands to create a student table, insert student records, delete a specific student, update marks, display various student information, and modify the table structure by adding a new column. Additionally, it includes queries to retrieve specific data based on conditions such as name prefixes and birth dates.

Uploaded by

pranjalsharma4409
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
5 views2 pages

Write Mysql Queries To

The document provides a series of MySQL queries to manage a database named MySchool. It includes commands to create a student table, insert student records, delete a specific student, update marks, display various student information, and modify the table structure by adding a new column. Additionally, it includes queries to retrieve specific data based on conditions such as name prefixes and birth dates.

Uploaded by

pranjalsharma4409
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

Write MySQL Queries to

1. To create a database MySchool

2. To create a student table with the student id, class, section, gender, name, dob, and marks as
attributes where the student id is the primary key.

3. To insert the details of following 10 students in the above table.

(1001, 11, B, Boy, Kamal, 29/07/2005, 45)

(1002, 12, A, Boy, Ravi, 29/06/2006, 25)

(1003, 11, A, Girl, Kushali, 30/06/2005, 43)

(1005, 12, B, Boy, Vimal, 12/09/2005, 28)

(1006, 11, A, Girl, Ruchi, 17/10/2004, 29)

(1009, 11, A, Girl, Ketaki, 24/07/2005, 11)

(1010, 12, A, Boy, Rahul, 21/4/2004, 29)

(1011, 12, B, Boy, Ketan, 3/02/2005, 22)

(1014, 12, A, Boy, Sajal, 9/12/2004, 44)

(1016, 11, B, Girl, Rajni, 18/11/2005, 45)

4. To delete the student whose Student id is 1005 in the above table.

5. To increase marks by 5% for those students who are in Class 12.

6. To display the entire content of the table Student

7. To display Rno, Name & Marks of students who are scoring marks more than 25.

8. To find the average of marks from the student table.

9. To find the number of students, who are from section ‘A’.

10. To add a new column email in the above table with appropriate data type.

11. To add the email ids of each student in the previously created email column.

12. To display the information of all the students, whose name starts with ‘RA’

13. To display Rno, Name, DOB of those students who are born after ‘2005- 01-01’
14. To display Rno, Name, DOB, Marks, Email of those male students in ascending order of their
names.

15. To display Rno, Gender, Name, DOB, Marks, Email in in descending order of their marks.

16. To display the unique section available in the table.

You might also like