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 vote187 views1 answer
Assign value to var in SQL
SQL
0 vote225 views1 answer
Get substract count sql
SQL
2 votes188 views1 answer
Mysql cannot delete or update a parent row
SQL
1 vote207 views1 answer
Postgresql define pk sequence next number
SQL
0 vote197 views1 answer
Output table plsql
SQL
0 vote229 views1 answer
Sql create and grant user access to database
SQL
0 vote245 views1 answer
Redshift running queries
SQL
-1 vote174 views2 answers
Sql query examples
SQL
-2 votes208 views1 answer
Trunc in sql
SQL
0 vote186 views2 answers
Postgresql get long running queries
SQL