7.1.1 使用CREATE DATABASE语句创建数据库

7.1.1　使用CREATE DATABASE语句创建数据库

1．语法格式

创建数据库的语法格式如下：

---

CREATE DATABASE database_name

---

2．简单示例

首先，在CentOS 6.8服务器上登录MySQL。

---

[root@binghe150 ~]# mysql -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 13
Server version: 8.0.18 binghe edition
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>

---

接下来，在MySQL命令行中查看当前MySQL中存在的数据库。

<