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

0 vote170 views1 answer
Sql query for getting data with join and count
SQL
0 vote163 views1 answer
Create boolean column in MySQL with false as default value?
SQL
0 vote174 views1 answer
Wordpress sql change site url
SQL
15 votes158 views7 answers
MYSQL
SQL
0 vote179 views1 answer
Sql query to get contact form 7 fields
SQL
1 vote191 views5 answers
Sql 2nd highest salary
SQL
1 vote169 views10 answers
Stack overflow
SQL
-1 vote132 views1 answer
MySQL said: Documentation #1010 - Error dropping database errno: 39 "Directory not empty")
SQL
0 vote171 views1 answer
Sql sum if
SQL
2 votes222 views3 answers
Mysql cheat sheet
SQL