MySQL 基礎操作入門指南：數據庫與表的增刪改查實戰

學習背景

通過書籍學習與燕十八老師視頻教程，記錄 MySQL 基礎操作學習過程。

核心操作實戰

1. 登入數據庫

zhiniaobu@telunsu-K55VD:~$ mysql -uroot -p
Enter password: 

2. 查看所有數據庫

mysql> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| ceshi              |
| mysql              |
| performance_schema |
+--------------------+
4 rows in set (0.04 sec)

3. 創建數據庫

mysql> CREATE DATABASE ceshi1;
Query OK, 1 row affected (0.00 sec)

mysql> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| ceshi              |
| ceshi1             |
| mysql              |
| performance_schema |
+--------------------+
5 rows in set (0.00 sec)

4. 查看數據庫定義（字符集等）

mysql> SHOW CREATE DATABASE ceshi1;
+----------+-------------------------------------------------------------------+
| Database | Create Database                                                   |
+----------+-------------------------------------------------------------------+
| ceshi1   | CREATE DATABASE `ceshi1` /*!40100 DEFAULT CHARACTER SET latin1 */ |
+----------+-------------------------------------------------------------------+
1 row in set (0.00 sec)

5. 刪除數據庫

mysql> DROP DATABASE ceshi1;
Query OK, 0 rows affected (0.07 sec)

mysql> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| ceshi              |
| mysql              |
| performance_schema |
+--------------------+
4 rows in set (0.00 sec)

關鍵知識點總結

• SHOW DATABASES：列出所有數據庫
• CREATE DATABASE：創建新數據庫，可指定字符集
• SHOW CREATE DATABASE：查看數據庫完整定義語句
• DROP DATABASE：永久刪除數據庫及其所有對象，操作不可逆
• 系統庫 information_schema、mysql、performance_schema 為 MySQL 內建，不可刪除