Example HTML page

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.

Example HTML page

Leave a Reply

Your email address will not be published. Required fields are marked *

Pin It on Pinterest