Mysql基础6-常用数据库函数

谁借莪１个温暖的怀抱￠ 2024-03-17 23:37 68阅读 0赞

#### 一、字符串函数 ####

##### 　　1、常见Mysql内置字符串函数 #####

*   *  concat(s1,s2,s3,...)：字符串拼接，将s1,s2,s3...等拼接成一个字符串
     *  lower(str)：将字符串str全部转为小写
     *  upper(str)：将字符串str全部转为大写
     *  lpad(str,n,pad)：左填充，将字符串pad对str的左边进行填充，达到n个字符串长度
     *  rpad(str,n,pad)：右填充，将字符串pad对str的右边进行填充，达到n个字符串长度
     *  trim(str)：去掉字符串头部和尾部的空格
     *  substring(str,start,len)：返回字符串str从start位置起的len长度的字符串

##### 　　2、函数示例　　　　 #####

**示例1：concat(s1,s2,s3,...) 函数**

![复制代码][806e10d8caf5fa16f79eafefc643d9bb.gif]

mysql> select concat("hello","world");
    +-------------------------+
    | concat("hello","world") |
    +-------------------------+
    | helloworld              |
    +-------------------------+
    1 row in set (0.00 sec)

![复制代码][9ddd456c0ef5738b0c32454a79dd7dcf.gif]

**示例2：lower(str)**

![复制代码][330299067e8e09f84520c0f3eaffc5d9.gif]

mysql> select lower("Hello");
    +----------------+
    | lower("Hello") |
    +----------------+
    | hello          |
    +----------------+
    1 row in set (0.00 sec)

![复制代码][f2975e92e9c8d9ea828b47b6e69d9a70.gif]

**示例3：upper(str)**

![复制代码][1f84f02feeaba4500e62915da89d279f.gif]

mysql> select upper("Hello");
    +----------------+
    | upper("Hello") |
    +----------------+
    | HELLO          |
    +----------------+
    1 row in set (0.00 sec)

![复制代码][9c86015d5f3ea807b50374cedf4b661a.gif]

**示例4：lpad(str,n,pad)|**

**情况一：n小于原始字符串str的长度，只显示原始字符串的长度n的字符　**

![复制代码][4e5dc6e26e9e9b410ba8114253a2783c.gif]

mysql> select lpad("张三",1,"靓仔");
    +---------------------------+
    | lpad("张三",1,"靓仔")     |
    +---------------------------+
    | 张                        |
    +---------------------------+
    1 row in set (0.00 sec)

![复制代码][dd22ee31fbb372c3ed3aac08c3bb4931.gif]

**情况二：当长度n大于str字符串的原始长度，小于拼接后的字符串长度后，显示原来的字符串str+pad继续补齐到n个字符串**

![复制代码][9695603a78306d6c7aedfbc123e3989e.gif]

mysql> select lpad("张三",3,"靓仔");
    +---------------------------+
    | lpad("张三",3,"靓仔")     |
    +---------------------------+
    | 靓张三                    |
    +---------------------------+
    1 row in set (0.00 sec)

![复制代码][f4c2214e6007766c417e21d47406f843.gif]

**情况三：如果n大于拼接后的字符串长度，会重复拼接pad字符串**

![复制代码][90ce9d977a476549f861c4d3d4bb6f71.gif]

mysql> select lpad("张三",6,"靓仔");
    +---------------------------+
    | lpad("张三",6,"靓仔")     |
    +---------------------------+
    | 靓仔靓仔张三              |
    +---------------------------+
    1 row in set (0.00 sec)

![复制代码][a302f9d55cd9e92cf7af36389ff1f319.gif]

**示例5：rpad(str,n,pad)**

![复制代码][b385eb9c8a860e476feb9a668d549f32.gif]

mysql> select rpad("张三",1,"靓仔");
    +---------------------------+
    | rpad("张三",1,"靓仔")     |
    +---------------------------+
    | 张                        |
    +---------------------------+
    1 row in set (0.00 sec)
    
    mysql> select rpad("张三",3,"靓仔");
    +---------------------------+
    | rpad("张三",3,"靓仔")     |
    +---------------------------+
    | 张三靓                    |
    +---------------------------+
    1 row in set (0.00 sec)
    
    mysql> select rpad("张三",6,"靓仔");
    +---------------------------+
    | rpad("张三",6,"靓仔")     |
    +---------------------------+
    | 张三靓仔靓仔              |
    +---------------------------+
    1 row in set (0.00 sec)

![复制代码][56e2d626da6f7742cdaaf5b3990c5a39.gif]

**情况处理：同lpad情况**

**　　　　示例6：trim(str)**

![复制代码][341600c763598a957dc722f1f18ad60e.gif]

mysql> select trim(" Hello world ");
    +-----------------------+
    | trim(" Hello world ") |
    +-----------------------+
    | Hello world           |
    +-----------------------+
    1 row in set (0.00 sec)

![复制代码][86d5527e62c9195b385d5310a91c031f.gif]

**注意**：trim只会取出开始和结尾的空格，不会去除中间的空格。

**示例7：substring(str,start,len)**

![复制代码][2bde7ad3a22e0bee5195f74f7647ab61.gif]

mysql> select substring("hello world", 1, 5);
    +--------------------------------+
    | substring("hello world", 1, 5) |
    +--------------------------------+
    | hello                          |
    +--------------------------------+
    1 row in set (0.00 sec)

![复制代码][0b1e332dc330fbcec70a0132ca1ddf44.gif]

**注意：**截取字符串的索引从1开始

**示例8：在table\_test中对id重新编号，统一显示五位数，不足五位数的前面补0**

原始表test数据

![复制代码][947ede3944f42e0421244c1a3ab7b988.gif]

mysql> select * from test;
    +------+---------+--------------+-----------+
    | id   | stu_num | stu_name     | stu_score |
    +------+---------+--------------+-----------+
    |    1 | 1       | 张三         | 90        |
    |    2 | 2       | 李四         | 87        |
    |    3 | 3       | 王五         | 78        |
    |    4 | 14      | 赵六         | 83        |
    |    5 | 25      | 王二麻子     | 94        |
    +------+---------+--------------+-----------+
    5 rows in set (0.00 sec)

![复制代码][7e56e353335fa1ebb4300b4dc8048d45.gif]

修改后的数据

![复制代码][fc6ed9f2a5adadc90247e8ce17e12991.gif]

mysql> update test set stu_num = lpad(stu_num,5,'0');
    Query OK, 5 rows affected (0.01 sec)
    Rows matched: 5  Changed: 5  Warnings: 0
    
    mysql> select * from test;
    +------+---------+--------------+-----------+
    | id   | stu_num | stu_name     | stu_score |
    +------+---------+--------------+-----------+
    |    1 | 00001   | 张三         | 90        |
    |    2 | 00002   | 李四         | 87        |
    |    3 | 00003   | 王五         | 78        |
    |    4 | 00014   | 赵六         | 83        |
    |    5 | 00025   | 王二麻子     | 94        |
    +------+---------+--------------+-----------+
    5 rows in set (0.00 sec)

![复制代码][f96a8ac85726b048eae6c33b9b6d229a.gif]

#### 二、数值函数 ####

##### 　　1、常见数值函数 #####

*   *  ceil(x)：向上取整
     *  floor(x)：向下取整
     *  mod(x,y)：返回x/y的模
     *  rand()：返回0-1内的随机数
     *  round(x,y)：求参数x的四舍五入的值，保留y位小数

##### 　　2、函数示例 #####

**　　　　**示例1：ceil(x)：向上取整

![复制代码][b385eb9c8a860e476feb9a668d549f32.gif]

mysql> select ceil(1.1);
    +-----------+
    | ceil(1.1) |
    +-----------+
    |         2 |
    +-----------+
    1 row in set (0.00 sec)

![复制代码][8b5211507289d4a4aa2500b1a9d768d9.gif]

**示例2：floor(x)：向下取整**

![复制代码][e083d3759adb8aa04584a830273661b5.gif]

mysql> select floor(1.9);
    +------------+
    | floor(1.9) |
    +------------+
    |          1 |
    +------------+
    1 row in set (0.00 sec)

![复制代码][90d2562fdba4a58eed955ff23738ffd3.gif]

**示例3：mod(x,y)：返回x/y的模**

![复制代码][aae3e363000fae37c590988fb0d89ec0.gif]

mysql> select mod(5,2);
    +----------+
    | mod(5,2) |
    +----------+
    |        1 |
    +----------+
    1 row in set (0.00 sec)

![复制代码][be973cedd2493409ff6ef04e6da251e7.gif]

**示例4：rand()：返回0-1内的随机数**

![复制代码][e2de66d805367a812d5f584573bd1593.gif]

mysql> select rand();
    +---------------------+
    | rand()              |
    +---------------------+
    | 0.20385351237268515 |
    +---------------------+
    1 row in set (0.00 sec)

![复制代码][71e5edf812968f7467840270e74605f2.gif]

**示例5：round(x,y)：求参数x的四舍五入的值，保留y位小数**

![复制代码][5629ea734fb67a4b5a1e7a5feb57e0f5.gif]

mysql> select round(3.1415926,2);
    +--------------------+
    | round(3.1415926,2) |
    +--------------------+
    |               3.14 |
    +--------------------+
    1 row in set (0.00 sec)

![复制代码][4d2b2533faab65b0294ef92443e73870.gif]

**示例6：综合案例：通过数据库函数，生成一个六位数的随机验证码**

![复制代码][e083d3759adb8aa04584a830273661b5.gif]

mysql> select rpad(round(rand()*1000000, 0),6,'0');
    +--------------------------------------+
    | rpad(round(rand()*1000000, 0),6,'0') |
    +--------------------------------------+
    | 192803                               |
    +--------------------------------------+
    1 row in set (0.00 sec)

![复制代码][20162aa91c6cd5019919a22f201f7771.gif]

**说明：**

1、rand()生成的小数，乘以1000000，才有可能是有六位整数的小数，所以这个时候需要市容round()四舍五入取整数

*　　　　　　2、因为rand()生成的小数有可能是0.999999这样的乘以1000000就是6位整数，也有可能生成的小数是0.000009这样的小数就算乘以1000000也不够六位整数*

*　　　　　　3、所以还需要使用rpad()函数，如果整数不足六位，就在后面补0*

#### 三、日期函数 ####

##### 　　1、常见日期函数 #####

*   *  curdate()：返回当前日期
     *  curtime()：返回当前时间
     *  now()：返回当前日期和时间
     *  year(date)：获取指定date的年份
     *  month(date)：获取指定date的月份
     *  day(date)：获取指定date的日期
     *  date\_add(date,interval expr type)：返回一个日期/时间值加上一个时间间隔expr后的时间值
     *  datediff(date1,date2)：返回起始时间date1和结束时间date2之间的天数

##### 　　2、函数示例 #####

**示例1：curdate()：返回当前日期**

![复制代码][e0a2864c817a59fbcfe363c32bce2e4d.gif]

mysql> select curdate();
    +------------+
    | curdate()  |
    +------------+
    | 2023-07-18 |
    +------------+
    1 row in set (0.00 sec)

![复制代码][ff3342e24e9e359220eb918e9b392ef2.gif]

**示例2：curtime()：返回当前时间**

![复制代码][e2eaf773d708d233769a6852c1f69ddb.gif]

mysql> select curtime();
    +-----------+
    | curtime() |
    +-----------+
    | 21:52:43  |
    +-----------+
    1 row in set (0.00 sec)

![复制代码][fd0cf0b572710275363b917349898a60.gif]

**示例3：now()：返回当前日期和时间**

![复制代码][bf7a2dde76d3b83a7828707502747111.gif]

mysql> select now();
    +---------------------+
    | now()               |
    +---------------------+
    | 2023-07-18 21:53:10 |
    +---------------------+
    1 row in set (0.00 sec)

![复制代码][b3b21c8e9b1e1476568889f5bc9c62dc.gif]

**示例4：year(date)：获取指定date的年份**

![复制代码][04d4aeb40ab18fe87166b0d3806f1e7f.gif]

mysql> select year("2023-07-18 21:53:10");
    +-----------------------------+
    | year("2023-07-18 21:53:10") |
    +-----------------------------+
    |                        2023 |
    +-----------------------------+
    1 row in set (0.01 sec)

![复制代码][5f5dc79bd73faf1867c880fa9333d491.gif]

**示例5：month(date)：获取指定date的月份**

![复制代码][c1419100e3d08f0d93148f8522d8936a.gif]

mysql> select month("2023-07-18 21:53:10");
    +------------------------------+
    | month("2023-07-18 21:53:10") |
    +------------------------------+
    |                            7 |
    +------------------------------+
    1 row in set (0.00 sec)

![复制代码][eb1970009218e3b8e9ea93fe84e38d06.gif]

**示例6：day(date)：获取指定date的日期**

![复制代码][83846397a8a8fd80498ed588a6ac4584.gif]

mysql> select day("2023-07-18 21:53:10");
    +----------------------------+
    | day("2023-07-18 21:53:10") |
    +----------------------------+
    |                         18 |
    +----------------------------+
    1 row in set (0.00 sec)

![复制代码][2c385b9a19b23e0566e9061a732de3b5.gif]

**示例7：date\_add(date,interval expr type)：返回一个日期/时间值加上一个时间间隔expr后的时间值**

![复制代码][7253281fe479d731feaaa654a71a629c.gif]

mysql> select date_add("2023-07-18 21:53:10", interval 2 day);
    +-------------------------------------------------+
    | date_add("2023-07-18 21:53:10", interval 2 day) |
    +-------------------------------------------------+
    | 2023-07-20 21:53:10                             |
    +-------------------------------------------------+
    1 row in set (0.01 sec)
    
    mysql> select date_add("2023-07-18 21:53:10", interval 2 month);
    +---------------------------------------------------+
    | date_add("2023-07-18 21:53:10", interval 2 month) |
    +---------------------------------------------------+
    | 2023-09-18 21:53:10                               |
    +---------------------------------------------------+
    1 row in set (0.00 sec)
    
    mysql> select date_add("2023-07-18 21:53:10", interval 2 year);
    +--------------------------------------------------+
    | date_add("2023-07-18 21:53:10", interval 2 year) |
    +--------------------------------------------------+
    | 2025-07-18 21:53:10                              |
    +--------------------------------------------------+
    1 row in set (0.00 sec)

![复制代码][324c33e211b6ccf0d753fa1a6871d9e1.gif]

**示例8：datediff(date1,date2)：返回起始时间date1和结束时间date2之间的天数**

![复制代码][7857fe19360156737264d7117873ca31.gif]

mysql> select datediff("2023-07-18 21:53:10", "2023-07-28 21:53:10");
    +--------------------------------------------------------+
    | datediff("2023-07-18 21:53:10", "2023-07-28 21:53:10") |
    +--------------------------------------------------------+
    |                                                    -10 |
    +--------------------------------------------------------+
    1 row in set (0.00 sec)
    
    mysql> select datediff("2023-07-28 21:53:10", "2023-07-18 21:53:10");
    +--------------------------------------------------------+
    | datediff("2023-07-28 21:53:10", "2023-07-18 21:53:10") |
    +--------------------------------------------------------+
    |                                                     10 |
    +--------------------------------------------------------+
    1 row in set (0.00 sec)

![复制代码][bf47a77a00a6b86098e0799477562c8a.gif]

#### 四、流程函数 ####

##### 　　1、常见流程函数 #####

*   *  if(value, t, f)：如果value为true，则返回t，否则返回f
     *  ifnull(value1,value2)：如果value1不为空，返回value1，否则返回value2
     *  case when \[val1\] then \[res1\]...else\[default\] end：如果val1为true，则返回res1，否则返回default默认值
     *  case\[expr\] when \[val1\] then \[res1\]...else\[default\] end：如果expr的值等于val1，返回res1，否则返回默认值

##### 　　2、函数示例 #####

**示例1：if(value, t, f)：如果value为true，则返回t，否则返回f**

![复制代码][6d7f720ec31e5e52a561133b61e1dd36.gif]

mysql> select if(1>2,"ok","no");
    +-------------------+
    | if(1>2,"ok","no") |
    +-------------------+
    | no                |
    +-------------------+
    1 row in set (0.00 sec)

![复制代码][2c385b9a19b23e0566e9061a732de3b5.gif]

**示例2：ifnull(value1,value2)：如果value1不为空，返回value1，否则返回value2**

![复制代码][d5884f5452573e72ee1cbbd1c421d35e.gif]

mysql> select ifnull("ok","default");
    +------------------------+
    | ifnull("ok","default") |
    +------------------------+
    | ok                     |
    +------------------------+
    1 row in set (0.00 sec)
    
    mysql> select ifnull("","default");
    +----------------------+
    | ifnull("","default") |
    +----------------------+
    |                      |              注意：空字符串不是null
    +----------------------+
    1 row in set (0.00 sec)
    
    mysql> select ifnull(null,"default");
    +------------------------+
    | ifnull(null,"default") |
    +------------------------+
    | default                |
    +------------------------+
    1 row in set (0.00 sec)

![复制代码][1699a8d4c152e5a4da95f2d5ba30898d.gif]

**示例3**：case \[expr\] when \[val1\] then \[res1\]...else\[default\] end：如果val1为true，则返回res1，否则返回default默认值

需求：在table\_test中，展示姓名和特色一栏，特色根据address的值来设定，北京特色烤鸭，上海特色蟹黄包，西安特色肉夹馍，其他地方都是红烧肉

table\_test表原始数据

![复制代码][dde0a05a80f6fd894d7120681b59cf73.gif]

mysql> select * from table_test;
    +------+--------+------+---------+
    | id   | name   | age  | address |
    +------+--------+------+---------+
    |    1 | 刘一   |   18 | 西安    |
    |    2 | 陈二   |   19 | 上海    |
    |    3 | 张三   |   21 | 北京    |
    |    4 | 李四   |   18 | 北京    |
    |    5 | 王五   |   21 | 西安    |
    |    6 | 赵六   |   22 | NULL    |
    +------+--------+------+---------+
    6 rows in set (0.00 sec)

![复制代码][6d3319bb37076c029d6c800f27154035.gif]

![复制代码][0657217fb1e2b08f31d6552d2e3ea66d.gif]

mysql> select name ,(case address when "北京" then "烤鸭" when "上海" then "蟹黄包" when "西安" then "肉夹馍" else "红烧肉" end) as "特色" from table_test;
    +--------+--------------+
    | name   | 特色         |
    +--------+--------------+
    | 刘一   | 肉夹馍       |
    | 陈二   | 蟹黄包       |
    | 张三   | 烤鸭         |
    | 李四   | 烤鸭         |
    | 王五   | 肉夹馍       |
    | 赵六   | 红烧肉       |
    +--------+--------------+
    6 rows in set (0.00 sec)

![复制代码][0657217fb1e2b08f31d6552d2e3ea66d.gif]

**示例4：需求：在学生成绩表中，根据成绩展示优秀,良好一般。**

学生成绩表（test）原始数据

![复制代码][ccf9a60f8b3b1a0f0c30a5870d11c6cc.gif]

mysql> select * from test;
    +------+---------+--------------+-----------+
    | id   | stu_num | stu_name     | stu_score |
    +------+---------+--------------+-----------+
    |    1 | 00001   | 张三         | 90        |
    |    2 | 00002   | 李四         | 87        |
    |    3 | 00003   | 王五         | 78        |
    |    4 | 00014   | 赵六         | 83        |
    |    5 | 00025   | 王二麻子     | 94        |
    +------+---------+--------------+-----------+
    5 rows in set (0.00 sec)

![复制代码][6984fd84bc59b419490179797a19734f.gif]

![复制代码][9d2b7fd4bddbb13489ffe38777450498.gif]

mysql> select stu_name, (case when stu_score>=90 then "优秀" when stu_score >=80 then "良好" when stu_score >=70 then
    "一般" when stu_score >=60 then "及格" else "不及格" end) as "成绩" from test;
    +--------------+--------+
    | stu_name     | 成绩   |
    +--------------+--------+
    | 张三         | 优秀   |
    | 李四         | 良好   |
    | 王五         | 一般   |
    | 赵六         | 良好   |
    | 王二麻子     | 优秀   |
    +--------------+--------+
    5 rows in set (0.00 sec)

![复制代码][56fe4471d4887e91ea6af69ede297f2d.gif]

[806e10d8caf5fa16f79eafefc643d9bb.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/890ab69cb6bb47889ce0f09dd1746224.png
[9ddd456c0ef5738b0c32454a79dd7dcf.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/a02274933a254a75ba66d3f2bd2a28a1.png
[330299067e8e09f84520c0f3eaffc5d9.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/c5125d305e0b4aae9f6be142451f706a.png
[f2975e92e9c8d9ea828b47b6e69d9a70.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/d529db2a7c654daf98b35b072f4ea40e.png
[1f84f02feeaba4500e62915da89d279f.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/15837b4a4baa4e7fb83b3573003c4bb3.png
[9c86015d5f3ea807b50374cedf4b661a.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/fb59f497c6bb4c5a9b2b4713c8852f46.png
[4e5dc6e26e9e9b410ba8114253a2783c.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/83bbeedce96c453faf6bb92e4853062d.png
[dd22ee31fbb372c3ed3aac08c3bb4931.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/28992c064b8c4070a791641bd6395dcb.png
[9695603a78306d6c7aedfbc123e3989e.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/ebf46f8a2a14465a87c6a836edd3387a.png
[f4c2214e6007766c417e21d47406f843.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/d0f4a2d65c0f442e9efadf7d64487925.png
[90ce9d977a476549f861c4d3d4bb6f71.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/2a12f6fdd84b454cb9f13d9e9e26bd77.png
[a302f9d55cd9e92cf7af36389ff1f319.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/7588d64253ed4504885e29913e0af198.png
[b385eb9c8a860e476feb9a668d549f32.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/8c90d3eaa8ed4ad2804432c0c9cc1d0b.png
[56e2d626da6f7742cdaaf5b3990c5a39.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/2a425e2b5b7f41199d43adad1b40dfd6.png
[341600c763598a957dc722f1f18ad60e.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/8fc928e2a56448aa84449ae542777ba1.png
[86d5527e62c9195b385d5310a91c031f.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/3edb896189e4445d89046889e5023110.png
[2bde7ad3a22e0bee5195f74f7647ab61.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/96d938a64a3d48a0b76990a4a141ea13.png
[0b1e332dc330fbcec70a0132ca1ddf44.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/298f3e58c047463694749ef8c6459302.png
[947ede3944f42e0421244c1a3ab7b988.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/2fd4f39603d14d6f9c71afbfccba1685.png
[7e56e353335fa1ebb4300b4dc8048d45.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/bbaa3bbd10ab44a2b5eccaaea4dc874d.png
[fc6ed9f2a5adadc90247e8ce17e12991.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/3cc40c5fc70e4fbc91e4f814504b5631.png
[f96a8ac85726b048eae6c33b9b6d229a.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/cf2c998c116e4bd8b8c5075e2dab1172.png
[8b5211507289d4a4aa2500b1a9d768d9.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/31a905fdcfb043d794d9a57640032368.png
[e083d3759adb8aa04584a830273661b5.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/bf41339832fd4cf9abf515c463645d1a.png
[90d2562fdba4a58eed955ff23738ffd3.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/a72a74e6afd64b58af674403384b65ef.png
[aae3e363000fae37c590988fb0d89ec0.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/3429293ec03e46c8bf848238d2974cdf.png
[be973cedd2493409ff6ef04e6da251e7.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/c057650bc39f42a58179485d0f1c0f38.png
[e2de66d805367a812d5f584573bd1593.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/5e4ce8a1496640159d89a3f2525e9d3b.png
[71e5edf812968f7467840270e74605f2.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/d29120d3e6b54eafb42bb0e266686c3c.png
[5629ea734fb67a4b5a1e7a5feb57e0f5.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/0ef290c77a4b4296aa3ad0fffdd0d2bc.png
[4d2b2533faab65b0294ef92443e73870.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/22782b52c95f41be99ac43e00525e3e2.png
[20162aa91c6cd5019919a22f201f7771.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/10f7a04f5cdd4b71981bc5fd7494a63e.png
[e0a2864c817a59fbcfe363c32bce2e4d.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/24cc118eba694a6e80eec9c2fce232f4.png
[ff3342e24e9e359220eb918e9b392ef2.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/dde23dc4d8394fd990a87470e8a15e25.png
[e2eaf773d708d233769a6852c1f69ddb.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/a8cb1972246b4e7fb76680713cb2c743.png
[fd0cf0b572710275363b917349898a60.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/608954678f1b427bbc62e7f337fca6e8.png
[bf7a2dde76d3b83a7828707502747111.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/41094dbf15224daaa4405465f5a08455.png
[b3b21c8e9b1e1476568889f5bc9c62dc.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/217183035ba14df8854df617d78c6e4f.png
[04d4aeb40ab18fe87166b0d3806f1e7f.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/918700b699b64a09b3870b37228228c8.png
[5f5dc79bd73faf1867c880fa9333d491.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/f6985fbb1f1e41068099afeef915b2e9.png
[c1419100e3d08f0d93148f8522d8936a.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/496300d98f504b8fa387045ea0dc5940.png
[eb1970009218e3b8e9ea93fe84e38d06.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/94cbb213834a4fcd88d017cd5fb1bb46.png
[83846397a8a8fd80498ed588a6ac4584.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/3663fb608e40450497b55fd59bf75d25.png
[2c385b9a19b23e0566e9061a732de3b5.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/240103c30bc44fe898e108dad5b6d31f.png
[7253281fe479d731feaaa654a71a629c.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/77184b5035994fa29173cff3040dc058.png
[324c33e211b6ccf0d753fa1a6871d9e1.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/a973a158407747c485b27e7d0851cf27.png
[7857fe19360156737264d7117873ca31.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/0dbe5fb62aff40a0982cba365f3dc7e3.png
[bf47a77a00a6b86098e0799477562c8a.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/66a5309e3e2f4f1884e25e899be924c0.png
[6d7f720ec31e5e52a561133b61e1dd36.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/2bb9e0a37af24c3e84965a1b80eced09.png
[d5884f5452573e72ee1cbbd1c421d35e.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/97d44b0c797d4b0e94606a2ce04507f7.png
[1699a8d4c152e5a4da95f2d5ba30898d.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/c8bf9e719d594f84877e3b0774a08c97.png
[dde0a05a80f6fd894d7120681b59cf73.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/c46053a40c7e4dd5b9c954f5986a02a0.png
[6d3319bb37076c029d6c800f27154035.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/3f537bccadf54103a612120d8b1899b8.png
[0657217fb1e2b08f31d6552d2e3ea66d.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/c54a90bb2f8e45f28df169570f3bcba5.png
[ccf9a60f8b3b1a0f0c30a5870d11c6cc.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/82a958db1c104b54aa2c17073e7f1789.png
[6984fd84bc59b419490179797a19734f.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/be0e17ca525c427ab7f0c92382d33a8c.png
[9d2b7fd4bddbb13489ffe38777450498.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/b57e4821d2f74a43804a7f6d8f478f12.png
[56fe4471d4887e91ea6af69ede297f2d.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/5044449426c446149c8e8bfc86aee5b6.png