MYSQL45道练习题---持续更新中

已于 2024-04-22 00:53:22 修改
阅读量390 收藏 6
点赞数 3
文章标签： java 数据库 前端
于 2024-04-22 00:31:39 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_53676834/article/details/138050547
版权

来源： Mysql_45道练习题 - 简书

共四张表：

①、course表： CId：课程id        Cname：课程名称        TId：老师id

②、student学生表：        SId：学生id        Sname：学生名称        Sage：年龄        Ssex：性别

③、teacher教师表：        TId：教师id        Tname：教师名称

④、sc学生-课程表：        SId:学生Id        CId：课程id        score：成绩

导入sql文件：


SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for course
-- ----------------------------
DROP TABLE IF EXISTS `course`;
CREATE TABLE `course`  (
  `CId` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `Cname` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `TId` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of course
-- ----------------------------
INSERT INTO `course` VALUES ('01', '语文', '02');
INSERT INTO `course` VALUES ('02', '数学', '01');
INSERT INTO `course` VALUES ('03', '英语', '03');

-- ----------------------------
-- Table structure for sc
-- ----------------------------
DROP TABLE IF EXISTS `sc`;
CREATE TABLE `sc`  (
  `SId` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `CId` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `score` decimal(18, 1) NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sc
-- ----------------------------
INSERT INTO `sc` VALUES ('01', '01', 80.0);
INSERT INTO `sc` VALUES ('01', '02', 90.0);
INSERT INTO `sc` VALUES ('01', '03', 99.0);
INSERT INTO `sc` VALUES ('02', '01', 70.0);
INSERT INTO `sc` VALUES ('02', '02', 60.0);
INSERT INTO `sc` VALUES ('02', '03', 80.0);
INSERT INTO `sc` VALUES ('03', '01', 80.0);
INSERT INTO `sc` VALUES ('03', '02', 80.0);
INSERT INTO `sc` VALUES ('03', '03', 80.0);
INSERT INTO `sc` VALUES ('04', '01', 50.0);
INSERT INTO `sc` VALUES ('04', '02', 30.0);
INSERT INTO `sc` VALUES ('04', '03', 20.0);
INSERT INTO `sc` VALUES ('05', '01', 76.0);
INSERT INTO `sc` VALUES ('05', '02', 87.0);
INSERT INTO `sc` VALUES ('06', '01', 31.0);
INSERT INTO `sc` VALUES ('06', '03', 34.0);
INSERT INTO `sc` VALUES ('07', '02', 89.0);
INSERT INTO `sc` VALUES ('07', '03', 98.0);

-- ----------------------------
-- Table structure for student
-- ----------------------------
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student`  (
  `SId` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `Sname` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `Sage` datetime(0) NULL DEFAULT NULL,
  `Ssex` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of student
-- ----------------------------
INSERT INTO `student` VALUES ('01', '赵雷', '1990-01-01 00:00:00', '男');
INSERT INTO `student` VALUES ('02', '钱电', '1990-12-21 00:00:00', '男');
INSERT INTO `student` VALUES ('03', '孙风', '1990-05-20 00:00:00', '男');
INSERT INTO `student` VALUES ('04', '李云', '1990-08-06 00:00:00', '男');
INSERT INTO `student` VALUES ('05', '周梅', '1991-12-01 00:00:00', '女');
INSERT INTO `student` VALUES ('06', '吴兰', '1992-03-01 00:00:00', '女');
INSERT INTO `student` VALUES ('07', '郑竹', '1989-07-01 00:00:00', '女');
INSERT INTO `student` VALUES ('09', '张三', '2017-12-20 00:00:00', '女');
INSERT INTO `student` VALUES ('10', '李四', '2017-12-25 00:00:00', '女');
INSERT INTO `student` VALUES ('11', '李四', '2017-12-30 00:00:00', '女');
INSERT INTO `student` VALUES ('12', '赵六', '2017-01-01 00:00:00', '女');
INSERT INTO `student` VALUES ('13', '孙七', '2018-01-01 00:00:00', '女');

-- ----------------------------
-- Table structure for teacher
-- ----------------------------
DROP TABLE IF EXISTS `teacher`;
CREATE TABLE `teacher`  (
  `TId` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `Tname` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of teacher
-- ----------------------------
INSERT INTO `teacher` VALUES ('01', '张三');
INSERT INTO `teacher` VALUES ('02', '李四');
INSERT INTO `teacher` VALUES ('03', '王五');

SET FOREIGN_KEY_CHECKS = 1;

题目1：

        查询" 01 "课程比" 02 "课程成绩高的学生的信息及课程分数：

select * 
from sc a 
left join student d
    on a.sid=d.sid 
inner join sc b 
    on a.sid=b.sid and a.cid='01' and b.cid='02'
where a.score>b.score;

我自己写的、太冗余：

1、
   先找出cid为01课程的
 select * from sc where cid = 01
2、
    再找出cid课程为02课程的
select * from sc where cid = 02
3、表连接

sleect sid,score from 
( select * from sc where cid = 01) m1
join
(select * from sc where cid = 02) m2
on m1.sid = m2.sid and m1.score>m2.score

改进后：

select * from
student s join sc as m1
on s.sid = m1.sid
join sc as m2
on m1.sid = m2.sid and m1.cid = '01' and m2.cid = '02'
where m1.score > m2.score ;

题目2：

        查询同时选了" 01 "课程和" 02 "课程的学生

select * 
from sc a 
inner join sc b 
    on a.sid=b.sid and a.cid='01' and b.cid='02';
select 
	sid
from
	sc
where
	sid in (select sid from sc where cid = '01')
	and
	sid in (select sid from sc where cid = '02');
select 
	m1.sid
from 
	(select sid from sc where cid = '01') as m1
join
	(select sid from sc where cid = '02') as m2
on 
	m1.sid = m2.sid;
mysql> select
    -> m1.sid
    -> from
    -> (select sid from sc where cid = '01') as m1
    -> join
    -> (select sid from sc where cid = '02') as m2
    -> on
    -> m1.sid = m2.sid;
+------+
| sid  |
+------+
| 01   |
| 02   |
| 03   |
| 04   |
| 05   |
+------+
5 rows in set (0.00 sec)

mysql> select
    -> sid
    -> from
    -> sc
    -> where
    -> sid in (select sid from sc where cid = '01')
    -> and
    -> sid in (select sid from sc where cid = '02');
+------+
| sid  |
+------+
| 01   |
| 01   |
| 01   |
| 02   |
| 02   |
| 02   |
| 03   |
| 03   |
| 03   |
| 04   |
| 04   |
| 04   |
| 05   |
| 05   |
+------+
14 rows in set (0.00 sec)

mysql> select sid from sc where cid = '01';
+------+
| sid  |
+------+
| 01   |
| 02   |
| 03   |
| 04   |
| 05   |
| 06   |
+------+
6 rows in set (0.00 sec)

mysql> select sid from sc where cid = '02';
+------+
| sid  |
+------+
| 01   |
| 02   |
| 03   |
| 04   |
| 05   |
| 07   |
+------+
6 rows in set (0.00 sec)

题目3：

        查询选了" 01 "课程但可能没有选择" 02 "课程的学生(不存在时显示为 null )

错误写法：

mysql> select *
    -> from sc a
    -> left join sc b
    ->     on a.sid=b.sid  and  a.cid='01' and b.cid='02'
    -> ;
+------+------+-------+------+------+-------+
| SId  | CId  | score | SId  | CId  | score |
+------+------+-------+------+------+-------+
| 01   | 01   |  80.0 | 01   | 02   |  90.0 |
| 01   | 02   |  90.0 | NULL | NULL |  NULL |
| 01   | 03   |  99.0 | NULL | NULL |  NULL |
| 02   | 01   |  70.0 | 02   | 02   |  60.0 |
| 02   | 02   |  60.0 | NULL | NULL |  NULL |
| 02   | 03   |  80.0 | NULL | NULL |  NULL |
| 03   | 01   |  80.0 | 03   | 02   |  80.0 |
| 03   | 02   |  80.0 | NULL | NULL |  NULL |
| 03   | 03   |  80.0 | NULL | NULL |  NULL |
| 04   | 01   |  50.0 | 04   | 02   |  30.0 |
| 04   | 02   |  30.0 | NULL | NULL |  NULL |
| 04   | 03   |  20.0 | NULL | NULL |  NULL |
| 05   | 01   |  76.0 | 05   | 02   |  87.0 |
| 05   | 02   |  87.0 | NULL | NULL |  NULL |
| 06   | 01   |  31.0 | NULL | NULL |  NULL |
| 06   | 03   |  34.0 | NULL | NULL |  NULL |
| 07   | 02   |  89.0 | NULL | NULL |  NULL |
| 07   | 03   |  98.0 | NULL | NULL |  NULL |
+------+------+-------+------+------+-------+
18 rows in set (0.00 sec)

mysql> select *
    -> from sc a
    -> left join sc b
    ->     on a.sid=b.sid  and b.cid='02'
    -> where a.cid='01';
+------+------+-------+------+------+-------+
| SId  | CId  | score | SId  | CId  | score |
+------+------+-------+------+------+-------+
| 01   | 01   |  80.0 | 01   | 02   |  90.0 |
| 02   | 01   |  70.0 | 02   | 02   |  60.0 |
| 03   | 01   |  80.0 | 03   | 02   |  80.0 |
| 04   | 01   |  50.0 | 04   | 02   |  30.0 |
| 05   | 01   |  76.0 | 05   | 02   |  87.0 |
| 06   | 01   |  31.0 | NULL | NULL |  NULL |
+------+------+-------+------+------+-------+
6 rows in set (0.00 sec)

mysql> select *
    -> from sc a
    -> left join sc b
    ->     on a.sid=b.sid  and b.cid='02';
+------+------+-------+------+------+-------+
| SId  | CId  | score | SId  | CId  | score |
+------+------+-------+------+------+-------+
| 01   | 01   |  80.0 | 01   | 02   |  90.0 |
| 01   | 02   |  90.0 | 01   | 02   |  90.0 |
| 01   | 03   |  99.0 | 01   | 02   |  90.0 |
| 02   | 01   |  70.0 | 02   | 02   |  60.0 |
| 02   | 02   |  60.0 | 02   | 02   |  60.0 |
| 02   | 03   |  80.0 | 02   | 02   |  60.0 |
| 03   | 01   |  80.0 | 03   | 02   |  80.0 |
| 03   | 02   |  80.0 | 03   | 02   |  80.0 |
| 03   | 03   |  80.0 | 03   | 02   |  80.0 |
| 04   | 01   |  50.0 | 04   | 02   |  30.0 |
| 04   | 02   |  30.0 | 04   | 02   |  30.0 |
| 04   | 03   |  20.0 | 04   | 02   |  30.0 |
| 05   | 01   |  76.0 | 05   | 02   |  87.0 |
| 05   | 02   |  87.0 | 05   | 02   |  87.0 |
| 06   | 01   |  31.0 | NULL | NULL |  NULL |
| 06   | 03   |  34.0 | NULL | NULL |  NULL |
| 07   | 02   |  89.0 | 07   | 02   |  89.0 |
| 07   | 03   |  98.0 | 07   | 02   |  89.0 |
+------+------+-------+------+------+-------+
18 rows in set (0.00 sec)

mysql> select *
    -> from sc a
    -> left join sc b
    ->     on a.sid=b.sid  and  a.cid='01' and b.cid='02'
    -> where a.cid='01';
+------+------+-------+------+------+-------+
| SId  | CId  | score | SId  | CId  | score |
+------+------+-------+------+------+-------+
| 01   | 01   |  80.0 | 01   | 02   |  90.0 |
| 02   | 01   |  70.0 | 02   | 02   |  60.0 |
| 03   | 01   |  80.0 | 03   | 02   |  80.0 |
| 04   | 01   |  50.0 | 04   | 02   |  30.0 |
| 05   | 01   |  76.0 | 05   | 02   |  87.0 |
| 06   | 01   |  31.0 | NULL | NULL |  NULL |
+------+------+-------+------+------+-------+
6 rows in set (0.00 sec)

mysql> select *
    -> from sc a
    -> left join sc b
    ->     on a.sid=b.sid  and  a.cid='01'  ;
+------+------+-------+------+------+-------+
| SId  | CId  | score | SId  | CId  | score |
+------+------+-------+------+------+-------+
| 01   | 01   |  80.0 | 01   | 03   |  99.0 |
| 01   | 01   |  80.0 | 01   | 02   |  90.0 |
| 01   | 01   |  80.0 | 01   | 01   |  80.0 |
| 01   | 02   |  90.0 | NULL | NULL |  NULL |
| 01   | 03   |  99.0 | NULL | NULL |  NULL |
| 02   | 01   |  70.0 | 02   | 03   |  80.0 |
| 02   | 01   |  70.0 | 02   | 02   |  60.0 |
| 02   | 01   |  70.0 | 02   | 01   |  70.0 |
| 02   | 02   |  60.0 | NULL | NULL |  NULL |
| 02   | 03   |  80.0 | NULL | NULL |  NULL |
| 03   | 01   |  80.0 | 03   | 03   |  80.0 |
| 03   | 01   |  80.0 | 03   | 02   |  80.0 |
| 03   | 01   |  80.0 | 03   | 01   |  80.0 |
| 03   | 02   |  80.0 | NULL | NULL |  NULL |
| 03   | 03   |  80.0 | NULL | NULL |  NULL |
| 04   | 01   |  50.0 | 04   | 03   |  20.0 |
| 04   | 01   |  50.0 | 04   | 02   |  30.0 |
| 04   | 01   |  50.0 | 04   | 01   |  50.0 |
| 04   | 02   |  30.0 | NULL | NULL |  NULL |
| 04   | 03   |  20.0 | NULL | NULL |  NULL |
| 05   | 01   |  76.0 | 05   | 02   |  87.0 |
| 05   | 01   |  76.0 | 05   | 01   |  76.0 |
| 05   | 02   |  87.0 | NULL | NULL |  NULL |
| 06   | 01   |  31.0 | 06   | 03   |  34.0 |
| 06   | 01   |  31.0 | 06   | 01   |  31.0 |
| 06   | 03   |  34.0 | NULL | NULL |  NULL |
| 07   | 02   |  89.0 | NULL | NULL |  NULL |
| 07   | 03   |  98.0 | NULL | NULL |  NULL |
+------+------+-------+------+------+-------+
28 rows in set (0.00 sec)

mysql> select *
    -> from sc a
    ->  join sc b
    ->     on a.sid=b.sid  and  a.cid='01' and b.cid='02'
    -> where a.cid='01';
+------+------+-------+------+------+-------+
| SId  | CId  | score | SId  | CId  | score |
+------+------+-------+------+------+-------+
| 01   | 01   |  80.0 | 01   | 02   |  90.0 |
| 02   | 01   |  70.0 | 02   | 02   |  60.0 |
| 03   | 01   |  80.0 | 03   | 02   |  80.0 |
| 04   | 01   |  50.0 | 04   | 02   |  30.0 |
| 05   | 01   |  76.0 | 05   | 02   |  87.0 |
+------+------+-------+------+------+-------+
5 rows in set (0.00 sec)

mysql> select *
    -> from sc a
    ->  join sc b
    ->     on a.sid=b.sid  and  a.cid='01' and b.cid='02';
+------+------+-------+------+------+-------+
| SId  | CId  | score | SId  | CId  | score |
+------+------+-------+------+------+-------+
| 01   | 01   |  80.0 | 01   | 02   |  90.0 |
| 02   | 01   |  70.0 | 02   | 02   |  60.0 |
| 03   | 01   |  80.0 | 03   | 02   |  80.0 |
| 04   | 01   |  50.0 | 04   | 02   |  30.0 |
| 05   | 01   |  76.0 | 05   | 02   |  87.0 |
+------+------+-------+------+------+-------+
5 rows in set (0.00 sec)

mysql>

明日春风
关注
  • 3
    点赞
  • 踩
  • 6
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
MySQL45道练习题-删掉了成绩表主键.docx
04-27
MySQL45道练习题-删掉了成绩表主键.docx
Linux云计算各阶段练习题----持续更新中
ljh451321的博客
02-12 2万+
各阶段练习题 1、删除/tmp目录下所有文件 [root@localhost ~]#rm rf /tmp/* 2、将/etc/fstab, /etc/passwd, /etc/shadow三个文件分别复制到/tmp目录下 [root@localhost ~]# cp -a /etc/fstab /tmp/ [root@localhost ~]# cp -a /etc/passwd /tmp/ [root@localhost ~]# cp -a /etc/shadow /tmp/ 3、将/etc/host
50道经典MySQL练习题（含解答）
孙不坚1208
05-30 9324
本文摘要：本篇主要分享50道经典MySQL练习题（含解答）。
数据存储 | MySQL —— MySQL命令练习题(持续更新！)
也许有一天我们再相逢 睁开眼睛看清楚 我才是英雄！
07-24 237
1.表结构 2.建库/建表 建库 create database test default charset utf8; 创建class表 / 插入数据 -- 创建表 create table class ( cid int(11) not null auto_increment primary key, caption char(12) not null ) engine=innodb auto_increment=1 default charset=utf8; -- 插入数据
mysql 练习题（持续更新中）
路西法Lucifer
04-08 783
表名与字段名： –1.学生表 Student(s_id,s_name,s_birth,s_sex) –学生编号,学生姓名, 出生年月,学生性别 –2.课程表 Course(c_id,c_name,t_id) – –课程编号, 课程名称, 教师编号 –3.教师表 Teacher(t_id,t_name) –教师编号,教师姓名 –4.成绩表 Score(s_id,c_id,s_sc...
mysql数据库题目选择题_MySQL版-50道数据库练习题
weixin_39668898的博客
02-01 1566
原博客戳这里：点我跳转(持续更新)环境1.MySQL 8.0-2. navicat for Mysql建表# 建表# 学生表CREATE TABLE `Student`(`s_id` VARCHAR(20),`s_name` VARCHAR(20) NOT NULL DEFAULT '',`s_birth` VARCHAR(20) NOT NULL DEFAULT '',`s_sex` VARCH...
数据库---练习题(45道)
添砖加瓦
05-10 3909
准备工作 CREATE DATABASE STUDENTS; CREATE TABLE STUDENT( SNO VARCHAR(32) PRIMARY KEY NOT NULL, SNAME VARCHAR(32) NOT NULL, SSEX VARCHAR(32) NOT NULL, SBIRTHDAY DATETIME, CLASS VARCHAR(20) ); CREATE TABL...
MYSQL练习题（持续更新）
qq_50513299的博客
03-01 146
when [条件] then [结果]1.有country表如下,其中the_name代表国家名，sex代表性别(1-男，2-女)，population代表人数。else [结果] end。ps:这里要注意的是1. case when [条件] then [结果]现在需要查找列名为 国家，男，女，形式如下图，请写出sql语句。最近在找工作，面试官说我mysql能力一般，所以加强练习。
MySQL练习题（经典50题）
热门推荐
weixin_43939159的博客
11-05 3万+
MySQL练习题（经典50题） – 建表 –学生表 CREATE TABLE Student( s_id VARCHAR(20), s_name VARCHAR(20) NOT NULL DEFAULT ‘’, s_birth VARCHAR(20) NOT NULL DEFAULT ‘’, s_sex VARCHAR(10) NOT NULL DEFAULT ‘’, PRIMARY KEY(s_id) ); –课程表 CREATE TABLE Course( c_id VARCHAR(20), c_nam
mysql作业34_MySQL常用命令，34道练习题（持续更新中）。
weixin_42500426的博客
02-08 128
1、使用SHOW语句找出在服务器上当前存在什么数据库：mysql> SHOW DATABASES;2、创建一个数据库MYSQLDATAmysql> CREATE DATABASE MYSQLDATA;3、选择你所创建的数据库mysql> USE MYSQLDATA; (按回车键出现Database changed 时说明操作成功！)4、查看现在的数据库中存在什么表mysql&gt...
mysql-connector-java-8.0.22.jar
08-14
包含mysql-connector-java-8.0.22.jar包含mysql-connector-java-8.0.22.jar包含mysql-connector-java-8.0.22.jar包含mysql-connector-java-8.0.22.jar包含mysql-connector-java-8.0.22.jar包含mysql-connector-java-...
mysql-connector-java-8.0.34
12-13
mysql-connector-java-8.0.34
mysql-connector-java-8.0.23.jar
12-18
该资源为mysql-connector-java-8.0.23.jar，欢迎下载使用哦！
mysql-connector-java-8.0.26.jar
12-18
该资源为mysql-connector-java-8.0.26.jar，欢迎下载使用哦！
JAVA 学习·泛型（二）——通配泛型
wr114514的博客
05-02 1057
介绍了Java泛型中的重要知识点——通配泛型及其应用。
获取Java 虚拟机进程ID（java应用进程Id的方法） Linux & windows
weixin_44131922的博客
04-30 507
这个命令会列出所有包含"java"的进程信息。从中你可以找到你的Java应用对应的进程行，第一列就是进程ID（PID）。这个命令会列出所有包含"java"的进程信息。在输出的信息中，你可以找到Java进程及其PID。替换为你的Java主类名或jar文件名的部分匹配字符串，pgrep会直接返回对应的进程ID。如果你需要在Java程序内部获取其自身的进程ID，可以使用。这段代码会打印出当前运行Java程序的进程ID。
springboot 获取maven打包时间
I do more ，you do less
04-30 503
【代码】springboot 获取maven打包时间。
Java---类和方法的再学习
最新发布
m0_74012211的博客
05-05 1072
Java类与对象
mysql sql练习题_Mysql----sql语句练习题(一)
06-11
好的，我可以为您提供一些MySQL SQL语句练习题。以下是一些简单的练习题： 1. 创建一个名为"students"的表，包含以下列：id, name, age, gender。 2. 向表"students"中插入以下数据： | id | name | age | gender | |----|-------|-----|--------| | 1 | Alice | 20 | Female | | 2 | Bob | 22 | Male | | 3 | Carol | 19 | Female | 3. 查询表"students"中所有的数据。 4. 查询表"students"中年龄在20岁以上的学生。 5. 查询表"students"中所有女性学生的姓名和年龄。 6. 将表"students"中所有学生的年龄增加1岁。 7. 删除表"students"中所有年龄小于20岁的学生。 希望这些练习题能够帮助到您。如果您有更多的问题，请随时告诉我。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值