How to create and work with database?

1.	How to create and work with database?
Answer» Creating Database (i) To create a database, type the following command in the prompt: CREATE DATABASE database_name; For example to create a database to store the tables: CREATE DATABASE stud; (ii) To work with the database, type the following command USE DATABASE; For example to use the stud database created, give the command USE stud;

Answer»

Creating Database

(i) To create a database, type the following command in the prompt:

CREATE DATABASE database_name;

For example to create a database to store the tables:

CREATE DATABASE stud;

(ii) To work with the database, type the following command

USE DATABASE;

For example to use the stud database created, give the command

USE stud;

Discussion