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 vote321 views1 answer
Sql headers delphi
SQL
0 vote310 views2 answers
Call to undefined function mysqli_fetch_all()
SQL
0 vote342 views1 answer
Check if mysql db is used
SQL
0 vote290 views1 answer
How to update rows from a table when certain conditions are met in mysql
SQL
9 votes323 views4 answers
How to alter table column name in mysql
SQL
0 vote336 views1 answer
Error: SAP DBTech JDBC: [258]: insufficient privilege: Detailed info for this error can be found with guid '87813FAA56439F48BD60812F3EBEC5A4'
SQL
1 vote316 views1 answer
Sql server 2012 query history
SQL
0 vote333 views2 answers
Mysql two column combination unique
SQL
0 vote289 views2 answers
Clear window pl sql
SQL
2 votes336 views3 answers
Mysql kill
SQL