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 vote229 views1 answer
Mysql disable triggers
SQL
0 vote204 views1 answer
Test connection to sql server
SQL
0 vote208 views1 answer
Mariadb maximum left join
SQL
1 vote198 views1 answer
Psql filed name alter
SQL
0 vote211 views1 answer
Cannot create a JSON value from a string with CHARACTER SET 'binary'.
SQL
2 votes209 views1 answer
Find all triggers in database
SQL
0 vote218 views1 answer
Kill slow queries mysql
SQL
21 votes211 views5 answers
Oracle all tables
SQL
0 vote196 views1 answer
Limiting query result using where in sql
SQL
3 votes209 views3 answers
Start postgresql ubuntu
SQL