CREATE:
The CREATE DATABASE statement is used to create a database.
Syntax: CREATE DATABASE database_name;
SELECT:
It is used to select a database first before executing any query on table.
Syntax: DATABASE database_name;
RENAME:
RENAME DATABASE is used when you need to change the name of your database.
Syntax: RENAME DATABASE old_db_name TO new_db_name;
DROP:
DROP statement is used to delete or remove indexes from a table in the database.
Syntax: DROP DATABASE database_name;