Name : Raghunathan R

USN : 1NT19IS122

5th Semester - B Section - Batch - 3

sudo mysql -u root -p company_30_11_122 < DB_Backup_30_11_02PM.sql

December 6, 2021 Back Up

sudo mysqldump -u root -p company_30_11_122 > Company_backup_06_12_21_07AM.sql

Company_backup_06_12_21_07AM.sql

Adding some more entries into employee table

Q 1. Retrieve the details of employees where salary is in range of 50000 - 60000

SELECT * FROM employee WHERE salary BETWEEN 50000 AND 60000;

Q 2. Retrieve the employee details who are staying in ' Yelahanka Bangalore '

SELECT * FROM employee WHERE address LIKE '%Yelehanka Bangalore%';