Mysql create database

MySQL CREATE DATABASE

MySQL implements a database as a directory that contains all files which correspond to tables in the database.

To create a new database in MySQL, you use the CREATE DATABASE statement with the following syntax:

CREATE DATABASE [IF NOT EXISTS] database_name
[CHARACTER SET charset_name]
[COLLATE collation_name]

Source: mysqltutorial.org

Mysql create database

CREATE DATABASE mydatabase CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

Similar codes

22 votes138 views4 answers
Mysql format date
SQL
0 vote57 views1 answer
Print sum of values sql
SQL
9 votes100 views4 answers
SQL Date Format
SQL
5 votes100 views1 answer
Oracle drop index if exists
SQL
0 vote101 views1 answer
Compare subqueries oracle
SQL
21 votes101 views4 answers
Add column mssql
SQL
0 vote105 views1 answer
Mysql insert into select with recursive
SQL
0 vote89 views1 answer
Name '_mysql' is not defined
SQL
1 vote92 views1 answer
Sql server 2012 query history
SQL
15 votes106 views2 answers
How to drop database name in postgresql
SQL