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

1 vote216 views1 answer
Create new table in SQL from old table with data
SQL
4 votes195 views2 answers
How to delete row in sql
SQL
21 votes266 views3 answers
Average sql
SQL
0 vote301 views1 answer
Contraint default SQL
SQL
0 vote187 views1 answer
Find largest table in mysql database
SQL
2 votes252 views2 answers
Asp.net core with postgresql deploy on ubuntu
SQL
0 vote341 views1 answer
Android sqlite add column if not exists
SQL
3 votes200 views2 answers
To_char sql
SQL
1 vote203 views1 answer
Oracle sql create or replace view
SQL
18 votes230 views2 answers
Sql comments
SQL