MySQL Assignment 1
Hi,
The following questions are based on creating a database.
1. Write an SQL statement to create ‘4’ databases of an educational institution VIT. The database names include VIT_Vellore, VIT_Chennai, VIT_Amaravathi, VIT_Bhopal.
2. Write an SQL statement to list down all the databases that are currently available in MySQL server. Write an SQL statement to create a database VIT_Vellore using IF NOT EXISTS.
3. Write an SQL statement to use the database VIT_Chennai.
4. Write an SQL statement to drop the database VIT_Bhopal.
5. Write an SQL statement to drop the database VIT_Anantapur without getting an error using IF EXISTS.
6.Write an SQL statement to list down the tables present in VIT_Chennai Database.
7.Write an SQL statement to print the details of the current database which you are using.