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 vote282 views1 answer
Delete all rows from table sqlite
SQL
-1 vote317 views1 answer
Adding a new table psql
SQL
1 vote343 views1 answer
How to fetch data in between startfromdate to starenddate in sql
SQL
19 votes350 views3 answers
How to change column type psql
SQL
11 votes336 views5 answers
Sql server reset identity
SQL
0 vote352 views1 answer
Sql query to force the database to be drop
SQL
7 votes328 views2 answers
Sql empty table
SQL
0 vote300 views0 answer
SQL
3 votes329 views1 answer
Stpop start psql server
SQL
17 votes308 views5 answers
Order by sql
SQL