task_003_managing_databases

Manage Databases

• Manage Databases
  • Create Database- CREATE -- SHOW -- Databases
  • Show Databases
  • Drop Database

Create Database- CREATE -- SHOW -- Databases

CREATE DATABASE student_db;

Output

mysql> CREATE DATABASE student_db;
Query OK, 1 row affected (0.01 sec)

Show Databases

show databases;

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| student_db         |
| sys                |
+--------------------+
5 rows in set (0.01 sec)

Drop Database

DROP DATABASE student_db;

Output

mysql> DROP DATABASE student_db;
Query OK, 0 rows affected (0.02 sec)