Creating a database query in Mysql

CREATE and DATABASE is in build command for creating database and demo is database name and semicolon specifies the termination of the query line;

CREATE DATABASE demo;

After executing this query your database will be created to check whether your database is created or not

To check that type


SHOW DATABASES;

this will show what are all the databases have been created in your system.

After execution of creating database what kind of database will bee created.
Database charset - UTF8 and Database collation is utf8_general_ci this charset and collation will helps you to insert, update and delete the multilingual format of database

For Further Reading,

Database, My SQL, Tutorial