01 - 終端操作MySQL數(shù)據(jù)庫

1. 登錄數(shù)據(jù)庫服務(wù)器

mysql -uroot -p123456

2. 顯示數(shù)據(jù)庫服務(wù)器中所有的數(shù)據(jù)庫

show databases;

+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
| test               |
+--------------------+
5 rows in set (0.00 sec)

3. 選中一個數(shù)據(jù)庫進行操作（這里選擇test數(shù)據(jù)庫）

use test;

Database changed

4. 顯示所選數(shù)據(jù)庫中所有的數(shù)據(jù)表

show tables;

+----------------+
| Tables_in_test |
+----------------+
| pet            |
+----------------+
1 row in set (0.00 sec)

5. 創(chuàng)建數(shù)據(jù)庫（這里創(chuàng)建的是test數(shù)據(jù)庫）

create database test;

6. 創(chuàng)建數(shù)據(jù)表（這里創(chuàng)建的是pet表）

create table pet (name varchar(20), owner varchar(20), species varchar(20), sex char(1), birth date, death date);

7. 顯示數(shù)據(jù)表的結(jié)構(gòu)

describe pet;

+---------+-------------+------+-----+---------+-------+
| Field   | Type        | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+-------+
| name    | varchar(20) | YES  |     | NULL    |       |
| owner   | varchar(20) | YES  |     | NULL    |       |
| species | varchar(20) | YES  |     | NULL    |       |
| sex     | char(1)     | YES  |     | NULL    |       |
| birth   | date        | YES  |     | NULL    |       |
| death   | date        | YES  |     | NULL    |       |
+---------+-------------+------+-----+---------+-------+
6 rows in set (0.00 sec)

8. 插入記錄

insert into pet values ('Tom', 'jack', '中華田園犬', 'f', '2020-07-28', null);

9. 刪除記錄

delete from pet where name='Siri';

10. 更新記錄

update pet set species='泰迪4' where name='mango';

11. 查詢數(shù)據(jù)表中的記錄

select * from pet;

+--------+-------+------------+------+------------+------------+
| name   | owner | species    | sex  | birth      | death      |
+--------+-------+------------+------+------------+------------+
| Tom    | jack  | 中華田園犬 | f    | 2020-07-28 | NULL       |
| apple  | aa    | 泰迪1      | f    | 2020-02-22 | NULL       |
| banana | bb    | 泰迪2      | m    | 2020-04-08 | NULL       |
| cherry | cc    | 泰迪3      | m    | 2020-03-18 | 2020-05-29 |
| mango  | ee    | 泰迪4      | f    | 2020-05-12 | 2020-07-30 |
| grape  | dd    | 泰迪5      | m    | 2020-07-14 | NULL       |
+--------+-------+------------+------+------------+------------+
6 rows in set (0.00 sec)

^{注：上述內(nèi)容舞萄，部分來自于網(wǎng)絡(luò)或書籍自娩，僅作為學(xué)習(xí)記錄使用蔓倍。由于參考來源眾多涌穆，未依次標(biāo)明出處霞赫。若有原作者看到此文盏混，麻煩聯(lián)系本人，我會第一時間處理橄镜。我對由此給您帶來的不便，深感抱歉冯乘！望見諒，謝謝晒夹！}

最后編輯于：2020.08.17 23:29:50

?著作權(quán)歸作者所有,轉(zhuǎn)載或內(nèi)容合作請聯(lián)系作者