How to create a database in mysql

The method for creating a database in mysql is: You can use the create command to create a database. The syntax format is: [CREATE DATABASE database name;]. For example: [CREATE DATABASE aa;] means creating a database named aa.

Use the create command to create a database. The syntax is as follows:

(recommended learning: mysql tutorial)

CREATE DATABASE 数据库名;

Example:

Create a database named aa:

[root@host]# mysql -u root -p   
Enter password:******  # 登录后进入终端
mysql> create DATABASE aa;

Related recommendations:

drop Command format:

drop database <数据库名>;

For example, delete the database named aa:

mysql> drop database aa;

Note: Be very careful when deleting the database, because after executing the delete command, all data will disappear.

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