MySQL Creating databases
Syntax
- CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name [create_specification] /// To create database
- DROP {DATABASE | SCHEMA} [IF EXISTS] db_name /// To drop database
Parameters
| Parameter | Details |
|---|---|
| CREATE DATABASE | Creates a database with the given name |
| CREATE SCHEMA | This is a synonym for CREATE DATABASE |
| IF NOT EXISTS | Used to avoid execution error, if specified database already exists |
| create_specification | create_specification options specify database characteristics such as CHARACTER SET and COLLATE(database collation) |
