SQL Create Database.

Creating a SQL Database

The SQL ANSI standard does not include a CREATE DATABASE command. Instead, it provides a CREATE SCHEMA command for defining the part of a database that a specific user owns.

Creating a database is not always easy in all RDBMS but once you've established the correct permissions the SQL syntax is simple.

CREATE DATABASE  db_name;

CREATE DATABASE  customerdb;

CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name
[[DEFAULT] CHARACTER SET charset_name
| [DEFAULT] COLLATE collation_name]

character_name is a set of symbols and encodings. DBMS will set a default if not set.
collation_name is a set of rules for comparing characters in a character set. DBMS will set a default if not set.

CREATE DATABASE IF NOT EXISTS customerdb;

SHOW CHARACTER SET;

SHOW COLLATION;

USE db_name;
SELECT @@character_set_database, @@collation_database;