1、庫操作
- 展示本地所有庫
- show databases；
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| cms |
| mysql |
| test |
+--------------------+
- 創建資料庫
- create database + 庫名；
# 創建 student 庫 mysql> create database student; # 查看庫 mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | cms | | mysql | | student | | test | +--------------------+
- 選擇進入某個資料庫
- user + 庫名；
mysql> use student;
Database changed
- 洗掉資料庫
- drop database + 庫名；
# 洗掉資料庫 student mysql> drop database student; # 查看驗證 student 庫是否成功洗掉 mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | cms | | mysql | | test | +--------------------+
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/58177.html
標籤：MySQL
上一篇：MySQL 資料庫賦權
下一篇：MySQL 表操作