MySql Exercises
SOOPRO Pathshala provides MySql Exercises
Day 1
MySql Day 1
SOOPRO Pathshala Exercises
Day 1
1. Create database name soopropathshala in MySQL.
2. Use database soopropathshala.
Day 2
MySql Day 2
SOOPRO Pathshala Exercises
Day 2
1. Create table student under soopropathshala database.
2. Insert five records in student table.
Day 3
MySql Day 3
SOOPRO Pathshala Exercises
Day 3
1. Add new column to student table.
2. Update value of newly added column one by one.
Day 4
MySql Day 4
SOOPRO Pathshala Exercises
Day 4
1. Write a query to display all records of student table.
2. Write a query to display selected records of student table.
Day 5
MySql Day 5
SOOPRO Pathshala Exercises
Day 5
1. Write a query to delete single record from student table.
2. Write a query to update single field of student table
Day 6
MySql Day 6
SOOPRO Pathshala Exercises
Day 6
1. Write a query to update multiple fields of student table.
2. Writ a query to drop single column.
Day 7
MySql Day 7
SOOPRO Pathshala Exercises
Day 7
1. Write a query to change size of address field.
2. Write a query to rename any field of student table.
Day 8
MySql Day 8
SOOPRO Pathshala Exercises
Day 8
1. Alter student table and add one more column.
2. Alter student table and drop newly added column.
Day 9
MySql Day 9
SOOPRO Pathshala Exercises
Day 9
1. Write a query to erase all rows of student table.
2. Write a query to drop student table of soopropathshala database.
Day 10
MySql Day 10
SOOPRO Pathshala Exercises
Day 10
1. Create new table employee having Id, Name, Gender, City and Salary fields.
2. Insert 10 records in employee table.
Day 11
MySql Day 11
SOOPRO Pathshala Exercises
Day 11
1. Write a query to view top 2 records from employee table.
2. Write a query to display employee in ascending order.
Day 12
MySql Day 12
SOOPRO Pathshala Exercises
Day 12
1. Drop customer table.
2. Drop soopropathshala database.