MariaDB [(none)]> SHOW DATABASES;  # 查看有哪些数据库
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
+--------------------+
MariaDB [(none)]> CREATE DATABASE tedu1 CHARSET utf8; #建库
MariaDB [(none)]> SHOW DATABASES;
+--------------------+
| tedu1              |  # 查到tedu1，创建成功
+--------------------+
MariaDB [(none)]> USE tedu1;  # 选择要操作的数据库
Database changed
MariaDB [tedu1]> SHOW TABLES;  # 查看当前库下有哪些表
Empty set (0.000 sec)
tedu1]> CREATE TABLE bumen(bumen_id INT, bumen_name VARCHAR(30));
Query OK, 0 rows affected (0.00  5 sec)  # 建表语句
MariaDB [tedu1]> INSERT INTO bumen VALUES(1, "OPS"); # 插入数据
MariaDB [tedu1]> INSERT INTO bumen VALUES(2, "DEV");
MariaDB [tedu1]> SELECT * FROM bumen;  # 再次查询，2条数据入库
+----------+------------+
|        1 | OPS        |
|        2 | DEV        |
+----------+------------+
MariaDB [tedu1]> UPDATE bumen SET bumen_name="HR" WHERE bumen_id=1;
Query OK, 1 row affected (0.003 sec)  # 更新语句
MariaDB [tedu1]> SELECT * FROM bumen;
+----------+------------+
|        1 | HR         |  # 从ops变成了hr
|        2 | DEV        |
+----------+------------+
MariaDB [tedu1]> DELETE FROM bumen;  # 删除表数据
MariaDB [tedu1]> SELECT * FROM bumen;
Empty set (0.000 sec)
MariaDB [tedu1]> DROP TABLE bumen;  # 删除表
MariaDB [tedu1]> SHOW TABLES;
Empty set (0.000 sec)