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 vote398 views2 answers
SQL SERVER ORDER BY DATE NULL LAST
SQL
5 votes316 views1 answer
Mysql get last day of month
SQL
2 votes329 views2 answers
Mysql user access to database
SQL
0 vote321 views1 answer
Drop unique
SQL
6 votes767 views3 answers
Sql select last id
SQL
0 vote349 views1 answer
Check if record exists mysql
SQL
1 vote317 views1 answer
Sql avg group by
SQL
8 votes280 views8 answers
Second highest salary in mysql
SQL
1 vote319 views1 answer
Flask sqlalchemy filter multiple conditions
SQL
0 vote310 views3 answers
Above average salary in sql
SQL