MYSQL DATABASE COMMANDS (DATA DEFINITION LANGUAGE;DDL)

Answer»

COMMAND	MEANING	SYNTAX
show database	Shows all the databases available in MySQL server.	>SHOW DATABASE;
create database	Creates a new database if it does not exist.	>CREATE DATABASE DATABASENAME;
drop database	To delete an existing database permanently.	>DROP DATABASE DATABASE_NAME
alter database	Changes or modifies the characteristics of an existing database.	>ALTER DATABASE [DATABASENAME] ALTEROPTION ;
use database	Allow you to use a particular database or change from the current database to another database.	>USE DATABASENAME;

Discussion