創建資料庫： 輸入：CREATE DATABASE itcase;
計算機輸出： Query OK, 1 row affected 查看資料庫：
輸入：SHOW DATABASES;
計算機輸出： +--------------------+
| Database |
+--------------------+
| information_schema |
| itcast |
| mysql |
| performance_schema |
| test |
+--------------------+
5 rows in set
查看創建資料庫的方式：
輸入：SHOW CREATE DATABASE itcast;
計算機輸出： +----------+----------------------------------------------------------------+
| Database | Create Database |
+----------+----------------------------------------------------------------+
| itcast | CREATE DATABASE `itcast` /*!40100 DEFAULT CHARACTER SET gbk */ |
+----------+----------------------------------------------------------------+
1 row in set
修改后的資料庫：
輸入：ALTER DATABASE itcast DEFAULT CHARACTER SET utf8;
計算機輸出： Query OK, 1 row affectedSHOW CREATE DATABASE itcast;
+----------+-----------------------------------------------------------------+
| Database | Create Database |
+----------+-----------------------------------------------------------------+
| itcast | CREATE DATABASE `itcast` /*!40100 DEFAULT CHARACTER SET utf8 */ |
+----------+-----------------------------------------------------------------+
1 row in set
洗掉資料庫：
輸入：DROP DATABASE itcast;
計算機輸出： Query OK, 0 rows affected 查看資料庫： 輸入：SHOW DATABASES;
計算機輸出： +--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
+--------------------+
4 rows in set
轉載請註明出處，本文鏈接：https://www.uj5u.com/qita/234692.html
標籤：其他
上一篇：IDM(Internet Download Manager)—下載各類安裝包（github代碼、python包）、軟體、視頻、檔案的神器，居家必備良藥
下一篇：MYSQL第一課