What are the sql statements to create a database in mysql?

SQL statement to create a MySQL database: CREATE DATABASE database_name Optional parameters: CHARACTER SET charset_name: Specify character set COLLATE collation_name: Specify collation rules

SQL statement to create a MySQL database

To create a MySQL database, you can use the following SQL statement:

CREATE DATABASE database_name;

Where, database_name is the database to be created The name.

Example:

To create a database named "my_database", you can use the following SQL statement:

CREATE DATABASE my_database;

Optional parameters ：

CREATE DATABASE The statement can also include some optional parameters, such as:

• ##CHARACTER SET charset_name:Specify the database character set.
• COLLATE collation_name: Specify the collation rules of the database.

Example:

To create a database named "my_database" and use the UTF-8 character set and utf8_general_ci collation rules, you can use the following SQL Statement:

CREATE DATABASE my_database CHARACTER SET utf8 COLLATE utf8_general_ci;

The above is the detailed content of What are the sql statements to create a database in mysql?. For more information, please follow other related articles on the PHP Chinese website!