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

16 votes217 views3 answers
T-SQL Add Column
SQL
0 vote208 views1 answer
How to delete python anywhere mysql database
SQL
0 vote206 views2 answers
How to count codition
SQL
0 vote227 views1 answer
Add two days to current date in sql when creating tables
SQL
0 vote189 views2 answers
Add new column after in sql
SQL
2 votes195 views1 answer
Import database in mysql command line xampp
SQL
17 votes274 views6 answers
Sql current date
SQL
11 votes226 views4 answers
Reset identity column values in sql server
SQL
2 votes149 views1 answer
Select sid oracle
SQL
0 vote203 views2 answers
Update all linkedserver tables with openquery on db
SQL