随记SQL

最新推荐文章于 2024-09-07 22:37:02 发布
最新推荐文章于 2024-09-07 22:37:02 发布
阅读量152 收藏
点赞数
文章标签： sql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_43031303/article/details/114676071
版权

#随记SQL

学生表
USE BOOK
CREATE TABLE student – 学生信息表
(
stuID CHAR(10) primary key, – 学生编号
stuName CHAR(10) NOT NULL , – 学生名称
major CHAR(50) NOT NULL – 专业
)

图书表
CREATE TABLE book – 图书表
(
BID CHAR(10) primary key, – 图书编号
title CHAR(50) NOT NULL, – 书名
author CHAR(20) NOT NULL, – 作者
)

借书表
CREATE TABLE borrow – 借书表
(
borrowID CHAR(10) primary key, – 借书编号
stuID CHAR(10) foreign key(stuID) references student(stuID), – 学生编号
BID CHAR(10) foreign key(BID) references book(BID),-- 图书编号
T_time datetime NOT NULL, – 借出日期
B_time datetime – 归还日期
)

学生信息插入数据
INSERT INTO student(stuID,stuName,major)VALUES(‘1001’,‘林林’,‘计算机’)
INSERT INTO student(stuID,stuName,major)VALUES(‘1002’,‘白杨’,‘计算机’)
INSERT INTO student(stuID,stuName,major)VALUES(‘1003’,‘虎子’,‘英语’)
INSERT INTO student(stuID,stuName,major)VALUES(‘1004’,‘北漂的雪’,‘工商管理’)
INSERT INTO student(stuID,stuName,major)VALUES(‘1005’,‘五月’,‘数学’)

图书信息插入数据
INSERT INTO book(BID,title,author)VALUES(‘B001’,‘人生若只如初见’,‘安意如’)
INSERT INTO book(BID,title,author)VALUES(‘B002’,‘入学那天遇见你’,‘晴空’)
INSERT INTO book(BID,title,author)VALUES(‘B003’,‘感谢折磨你的人’,‘如娜’)
INSERT INTO book(BID,title,author)VALUES(‘B004’,‘我不是教你诈’,‘刘庸’)
INSERT INTO book(BID,title,author)VALUES(‘B005’,‘英语四级’,‘白雪’)

借书信息插入数据
INSERT INTO borrow(borrowID,stuID,BID,T_time,B_time)VALUES(‘T001’,‘1001’,‘B001’,‘2007-12-26’,null)
INSERT INTO borrow(borrowID,stuID,BID,T_time,B_time)VALUES(‘T002’,‘1004’,‘B003’,‘2008-1-5’,null)
INSERT INTO borrow(borrowID,stuID,BID,T_time,B_time)VALUES(‘T003’,‘1005’,‘B001’,‘2007-10-8’,‘2007-12-25’)
INSERT INTO borrow(borrowID,stuID,BID,T_time,B_time)VALUES(‘T004’,‘1005’,‘B002’,‘2007-12-16’,‘2008-1-7’)
INSERT INTO borrow(borrowID,stuID,BID,T_time,B_time)VALUES(‘T005’,‘1002’,‘B004’,‘2007-12-22’,null)
INSERT INTO borrow(borrowID,stuID,BID,T_time,B_time)VALUES(‘T006’,‘1005’,‘B005’,‘2008-1-6’,null)
INSERT INTO borrow(borrowID,stuID,BID,T_time,B_time)VALUES(‘T007’,‘1002’,‘B001’,‘2007-9-11’,null)
INSERT INTO borrow(borrowID,stuID,BID,T_time,B_time)VALUES(‘T008’,‘1005’,‘B004’,‘2007-12-10’,null)
INSERT INTO borrow(borrowID,stuID,BID,T_time,B_time)VALUES(‘T009’,‘1004’,‘B005’,‘2007-10-16’,‘2007-12-18’)
INSERT INTO borrow(borrowID,stuID,BID,T_time,B_time)VALUES(‘T010’,‘1002’,‘B002’,‘2007-9-15’,‘2008-1-5’)
INSERT INTO borrow(borrowID,stuID,BID,T_time,B_time)VALUES(‘T011’,‘1004’,‘B003’,‘2007-12-28’,null)
INSERT INTO borrow(borrowID,stuID,BID,T_time,B_time)VALUES(‘T012’,‘1002’,‘B003’,‘2007-12-30’,null)

  1. 查询“计算机”专业学生在“2007-12-15”至“2008-1-8”时间段内借书的学生编号、学生名称、图书编号、图书名称、借出日期；

select s.stuID 学生编号,s.stuName 学生名称,k.BID 图书编号,k.title 图书名称,b.T_time 借出日期
from borrow b inner join student s on s.stuID = b.stuID inner join book k on k.BID = b.BID
where T_time > ‘2007-12-15’ and T_time < ‘2008-1-8’ and s.major = ‘计算机’

–
select stuID 学生编号,(select stuName from student where stuID=borrow.stuID) 学生名称,
BID 图书编号,(select title from book where BID=borrow.BID) 图书名称,T_time 借出日期
from borrow where stuID in (select stuID from student where major=‘计算机’)
and T_time>‘2007-12-15’ and T_time<‘2008-1-8’

  1. 查询所有借过图书的学生编号、学生名称、专业；

select s.stuID 学生编号,s.stuName 学生名称,s.major 专业 from borrow b
inner join student s on b.stuID = s.stuID group by s.stuID

–
select stuID 学生编号,stuName 学生名称,major 专业
from student where stuID in (select stuID from borrow)

  1. 查询借过作者为“安意如”的图书的学生姓名、图书名称、借出日期、归还日期；

select (select stuName from student s where s.stuID = b.stuID) 学生姓名,
k.title 图书名称,b.T_time 借出日期,b.B_time 归还日期
from book k inner join borrow b on k.BID = b.BID
where k.author = ‘安意如’

–
select (select stuName from student where stuID=borrow.stuID) 学生名称,
(select title from book where BID=borrow.BID) 图书名称,T_time 借出日期,
B_time 归还日期 from borrow where BID in (select BID from book where author=‘安意如’)

  1. 查询目前借书 但未归 还图书的学生名称 及未还图书数量；

select s.stuName 学生名称,count(*) 图书数量
from borrow b inner join student s on b.stuID = s.stuID
where B_time is null group by s.stuName

select (select stuName from student where stuID=borrow.stuID) 学生名称,
count(*) 借书数量 from borrow where B_time is null group by stuID

学生表
CREATE TABLE Members
(
MID char(10) primary key,
MName char(50) NOT NULL
)

课程表
CREATE TABLE F – 课程表
(
FID char(10) primary key, – 课程号
FName CHAR(50) NOT NULL – 课程名
)

成绩表
CREATE TABLE score – 学生成绩表
(
SID int primary key, – 成绩记录号
FID char(10) , – 课程号
MID char(10) , – 学生号
score int(10) – 成绩
)

课程表插入数据
INSERT INTO F(FID,FName)VALUES(‘F001’,‘语文’)
INSERT INTO F(FID,FName)VALUES(‘F002’,‘数学’)
INSERT INTO F(FID,FName)VALUES(‘F003’,‘英语’)
INSERT INTO F(FID,FName)VALUES(‘F004’,‘历史’)

学生表插入数据
INSERT INTO Members(MID,MName)VALUES(‘M001’,‘张萨’)
INSERT INTO Members(MID,MName)VALUES(‘M002’,‘王强’)
INSERT INTO Members(MID,MName)VALUES(‘M003’,‘李三’)
INSERT INTO Members(MID,MName)VALUES(‘M004’,‘李四’)
INSERT INTO Members(MID,MName)VALUES(‘M005’,‘阳阳’)
INSERT INTO Members(MID,MName)VALUES(‘M006’,‘虎子’)
INSERT INTO Members(MID,MName)VALUES(‘M007’,‘夏雪’)
INSERT INTO Members(MID,MName)VALUES(‘M008’,‘璐璐’)
INSERT INTO Members(MID,MName)VALUES(‘M009’,‘珊珊’)
INSERT INTO Members(MID,MName)VALUES(‘M010’,‘香奈儿’)

成绩表插入数据
INSERT INTO Score(FID,MID,Score)VALUES(‘F001’,‘M001’,78)
INSERT INTO Score(FID,MID,Score)VALUES(‘F002’,‘M001’,67)
INSERT INTO Score(FID,MID,Score)VALUES(‘F003’,‘M001’,89)
INSERT INTO Score(FID,MID,Score)VALUES(‘F004’,‘M001’,76)
INSERT INTO Score(FID,MID,Score)VALUES(‘F001’,‘M002’,89)
INSERT INTO Score(FID,MID,Score)VALUES(‘F002’,‘M002’,67)
INSERT INTO Score(FID,MID,Score)VALUES(‘F003’,‘M002’,84)
INSERT INTO Score(FID,MID,Score)VALUES(‘F004’,‘M002’,96)
INSERT INTO Score(FID,MID,Score)VALUES(‘F001’,‘M003’,70)
INSERT INTO Score(FID,MID,Score)VALUES(‘F002’,‘M003’,87)
INSERT INTO Score(FID,MID,Score)VALUES(‘F003’,‘M003’,92)
INSERT INTO Score(FID,MID,Score)VALUES(‘F004’,‘M003’,56)
INSERT INTO Score(FID,MID,Score)VALUES(‘F001’,‘M004’,80)
INSERT INTO Score(FID,MID,Score)VALUES(‘F002’,‘M004’,78)
INSERT INTO Score(FID,MID,Score)VALUES(‘F003’,‘M004’,97)
INSERT INTO Score(FID,MID,Score)VALUES(‘F004’,‘M004’,66)
INSERT INTO Score(FID,MID,Score)VALUES(‘F001’,‘M006’,88)
INSERT INTO Score(FID,MID,Score)VALUES(‘F002’,‘M006’,55)
INSERT INTO Score(FID,MID,Score)VALUES(‘F003’,‘M006’,86)
INSERT INTO Score(FID,MID,Score)VALUES(‘F004’,‘M006’,79)
INSERT INTO Score(FID,MID,Score)VALUES(‘F002’,‘M007’,77)
INSERT INTO Score(FID,MID,Score)VALUES(‘F003’,‘M008’,65)
INSERT INTO Score(FID,MID,Score)VALUES(‘F004’,‘M007’,48)
INSERT INTO Score(FID,MID,Score)VALUES(‘F004’,‘M009’,75)
INSERT INTO Score(FID,MID,Score)VALUES(‘F002’,‘M009’,88)

  1. 查询各个学生语文、数学、英语、历史课程成绩
    select s.MName 学生姓名,f.FName 课程,e.score 成绩 from members s
    inner join score e on s.MID = e.MID
    inner join f f on f.FID = e.FID

SELECT Members.MName AS 姓名,
SUM(CASE F.FName WHEN ‘语文’ THEN Score.Score END) 英语,
SUM(CASE F.FName WHEN ‘数学’ THEN Score.Score END) 数学,
SUM(CASE F.FName WHEN ‘英语’ THEN Score.Score END) 英语,
SUM(CASE F.FName WHEN ‘历史’ THEN Score.Score END) 历史
FROM Score, Members,F
WHERE F.FID = Score.FID AND Members.MID =Score.MID GROUP BY Members.MName

  1. 查询四门课中成绩低于70分的学生及相对应课程名和成绩。

select s.MName 学生姓名,e.score 成绩,f.FName 课程 from score e
inner join members s on e.MID = s.MID
inner join f f on f.FID = e.FID
where e.score < 70

select (select MName from Members where MID=Score.MID) 姓名,
(select FName from F where FID=Score.FID) 课程,
Score 成绩 from Score where Score<70

  1. 统计各个学生参加考试课程的平均分，且按平均分数由高到底排序。

select members.MName 姓名,avg(score) 平均分 from score inner join
members on members.MID = score.MID
group by members.MName order by 平均分 desc

select (select MName from Members where MID=Score.MID) 姓名,
Avg(Score) 平均分 from Score group by MID order by 平均分 desc

  1. 创建存储过程，分别查询参加 1、2、3、4门考试及没有参加考试的学生名单，要求显示姓名、学号。

create procedure P_stu ( in num int )
begin
select (select MName from Members where MID=Score.MID) 姓名,
MID 学号 from Score group by MID having count(*) = num;
end;

– 调用存储过程 –
CALL P_stu (4)

SELECT Members.MName AS 姓名,
SUM(CASE F.FName WHEN ‘语文’ THEN Score.Score END) 英语,
SUM(CASE F.FName WHEN ‘数学’ THEN Score.Score END) 数学,
SUM(CASE F.FName WHEN ‘英语’ THEN Score.Score END) 英语,
SUM(CASE F.FName WHEN ‘历史’ THEN Score.Score END) 历史
FROM Score, Members,F
WHERE F.FID = Score.FID AND Members.MID =Score.MID GROUP BY Members.MName

学生表 Students
create table Students(SId varchar(10) primary key,Sname varchar(10),Sage datetime,Ssex varchar(10));

insert into Students values(‘01’ , ‘巫瑜’ , ‘1990-01-01’ , ‘男’);
insert into Students values(‘02’ , ‘欧阳沨’ , ‘1990-12-21’ , ‘男’);
insert into Students values(‘03’ , ‘夏冰’ , ‘1990-12-20’ , ‘男’);
insert into Students values(‘04’ , ‘万嘞’ , ‘1990-12-06’ , ‘男’);
insert into Students values(‘05’ , ‘阿布靛’ , ‘1991-12-01’ , ‘女’);
insert into Students values(‘06’ , ‘凌鳕’ , ‘1992-01-01’ , ‘女’);
insert into Students values(‘07’ , ‘莫竹’ , ‘1989-01-01’ , ‘女’);
insert into Students values(‘09’ , ‘雾瑾’ , ‘2017-12-20’ , ‘女’);
insert into Students values(‘10’ , ‘遽然’ , ‘2017-12-25’ , ‘女’);
insert into Students values(‘11’ , ‘卿卿’ , ‘2012-06-06’ , ‘女’);
insert into Students values(‘12’ , ‘戏欸’ , ‘2013-06-13’ , ‘女’);
insert into Students values(‘13’ , ‘彬淋’ , ‘2014-06-01’ , ‘女’);

科目表 Course
create table Course(CId varchar(10) primary key,Cname nvarchar(10),TId varchar(10));

insert into Course values(‘01’ , ‘语文’ , ‘02’);
insert into Course values(‘02’ , ‘数学’ , ‘01’);
insert into Course values(‘03’ , ‘英语’ , ‘03’);

教师表 Teacher
create table Teacher(TId varchar(10) primary key,Tname varchar(10));

insert into Teacher values(‘01’ , ‘龙扉’);
insert into Teacher values(‘02’ , ‘翡霏’);
insert into Teacher values(‘03’ , ‘羽宁’);

成绩表 SCORES
create table Scores(SId varchar(10),CId varchar(10),score decimal(18,1));

insert into Scores values(‘01’ , ‘01’ , 80);
insert into Scores values(‘01’ , ‘02’ , 90);
insert into Scores values(‘01’ , ‘03’ , 99);
insert into Scores values(‘02’ , ‘01’ , 70);
insert into Scores values(‘02’ , ‘02’ , 60);
insert into Scores values(‘02’ , ‘03’ , 80);
insert into Scores values(‘03’ , ‘01’ , 80);
insert into Scores values(‘03’ , ‘02’ , 80);
insert into Scores values(‘03’ , ‘03’ , 80);
insert into Scores values(‘04’ , ‘01’ , 50);
insert into Scores values(‘04’ , ‘02’ , 30);
insert into Scores values(‘04’ , ‘03’ , 20);
insert into Scores values(‘05’ , ‘01’ , 76);
insert into Scores values(‘05’ , ‘02’ , 87);
insert into Scores values(‘06’ , ‘01’ , 31);
insert into Scores values(‘06’ , ‘03’ , 34);
insert into Scores values(‘07’ , ‘02’ , 89);
insert into Scores values(‘07’ , ‘03’ , 98);

0 查询" 01 “课程比” 02 "课程成绩高的学生的信息及课程分数
select s1.SId,s1.score1,s2.score2 from
(select SId,score score1 from scores where CId = ‘01’) as s1,
(select SId,score score2 from scores where CId = ‘02’) as s2
where s1.SId = s2.SId and s1.score1 > s2.score2

select * from Students RIGHT JOIN (
select t1.SId, class1, class2 from
(select SId, score as class1 from scores where scores.CId = ‘01’) as t1,
(select SId, score as class2 from scores where scores.CId = ‘02’) as t2
where t1.SId = t2.SId AND t1.class1 > t2.class2
) r
on Students.SId = r.SId;

select * from (
select t1.SId, class1, class2
from
(SELECT SId, score as class1 FROM scores WHERE scores.CId = ‘01’) AS t1,
(SELECT SId, score as class2 FROM scores WHERE scores.CId = ‘02’) AS t2
where t1.SId = t2.SId and t1.class1 > t2.class2
) r
LEFT JOIN Students
ON Students.SId = r.SId;

1 查询同时存在" 01 “课程和” 02 "课程的情况
select s1.SId,s1.CId,s1.score,s2.CId,s2.score from
(select * from scores where CId = ‘01’) s1,
(select * from scores where CId = ‘02’) s2
where s1.SId = s2.SId

2 查询存在" 01 “课程但可能不存在” 02 "课程的情况(不存在时显示为 null )
select s1.SId,s1.CId,s1.score,s2.CId,s2.score from
(select * from scores where CId = ‘01’) s1 left join
(select * from scores where CId = ‘02’) s2 on s1.SId = s2.SId

3 查询不存在" 01 “课程但存在” 02 "课程的情况
select s1.SId,s1.CId,s1.score,s2.CId,s2.score from
(select * from scores where CId = ‘01’) s1 right join
(select * from scores where CId = ‘02’) s2
on s1.SId = s2.SId where s1.CId is null

4 查询平均成绩大于等于 60 分的同学 的学生编号和学生姓名和平均成绩
select SId 学生编号,
(select Sname from students s where s.SId = scores.SId) 学生姓名,
avg(score) 平均成绩 from scores group by SId having 平均成绩 >= 60

5 查询在 SC 表存在成绩的学生信息
select s.*,e.score from students s inner join scores e on s.SId = e.SId

6 查询所有同学的学生编号、学生姓名、选课总数、所有课程的总成绩(没成绩的显示为 null )

select scores.SId 学生编号,
(select s.Sname from students s where s.SId = scores.SId) 学生姓名,
count(scores.CId) 选课总数,
sum(scores.score) 总成绩
from scores group by scores.SId

select s.SId 学生编号,s.Sname 学生姓名,
(select count(scores.CId) from scores where scores.SId = s.SId) 选课总数,
(select sum(scores.score) from scores where scores.SId = s.SId) 总成绩
from students s group by s.SId

7 查有成绩的学生信息
select s.* from students s inner join scores on s.SId = scores.SId group by s.SId

8 查询「李」姓老师的数量
select count(*) from teacher where Tname like ‘%扉%’

9 查询学过「张三」老师授课的同学的信息
select s.*,c.Cname,t.Tname,e.score from students s
inner join scores e on s.SId = e.SId
inner join Course c on e.CId = c.CId
inner join teacher t on t.TId = c.TId
where t.Tname = '龙扉

10 查询没有学全所有课程的同学的信息
select s.*,count(e.CId) 课程 from students s left join scores e on s.SId = e.SId
group by s.SId having 课程 <> 3

11 查询至少有一门课与学号为" 01 "的同学所学相同的同学的信息
select * from students s where SId in
( select SId from scores where CId in
(select e.CId from students s left join
scores e on s.SId = e.SId where s.SId = ‘01’ ) group by SId )

奶茶小酥
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
mysql综合练习
koko_pe的博客
10-11 865
USE testdb; CREATE TABLE sch( id INT PRIMARY KEY, NAME VARCHAR(50) NOT NULL, glass VARCHAR(50) NOT NULL ); INSERT INTO sch VALUES (1,'xiaoming','glass1'), (2,'xiaojun','glass2'); SELECT * FROM ...
三范式 与 MySQL语句
yehaotianyhy的博客
05-19 209
第一范式的目标是确保每列的原子性第二范式要求每个表只描述一件事情（消除部分依赖）第三范式（消除传递依赖）与主键要直接相关，不能间接相关。drop database 数据库名；  //删除数据库show databases:  //查看所有数据库create database 数据库名：  //新建数据库创建表create table 新表名(id int(2),name varchar(50));...
SQL 随记 sql 判空 非空 ：
IT_Yl的博客
05-04 912
sql 判空 非空 ： trim(column)!=''  
mysql之随记sql
hanruiding的博客
10-09 167
mysql之随记sql 字符集设置（当前登录用户） set names utf8; mysqldump附带where条件 mysqldump -uroot -p --default-character-set=utf8 umtpassport umt_user --where=" cstnet_id like 'qibaohua19%' " > qibaohua19.sql 查询语句输...
SQL函数随记
qq_50071874的博客
03-15 115
desc/asc、convert、datediff、abs、count
随记sqlserver学习笔记
weixin_30625691的博客
05-07 101
create database libraryDBgouse libraryDBgo--读者信息表create table ReaderInfo( ReaderId int not null primary key identity,--读者编号，表示列、自动增长，主键 ReaderNo varchar(20) not null ,--借书证号 ReaderName varchar(10) no...
Sql入门随记
qq_40696594的博客
03-20 284
SQL随记 求取“平均…“时使用”分组函数“：group by SELECT DISTINCT 语句用于返回唯一不同的值。(去重) SELECT 字段名 FROM 表名 [WHERE 字段 = 值] ORDER BY 字段名 [ASC / DESC]---->排序 多表连接时，出现多对一的情况时，“一”会在后面自动补全 SQL CONCAT函数用于将两个字符串连接起来，形成一个单一的字符串。 SQL truncate（不进行四舍五入）用法类似的函数round（四舍五入）...
微信小程序小手随记个人记账软件系统
11-02
微信小程序“小手随记”个人记账软件系统是一个基于.NET框架和SQL Server数据库的完整解决方案，旨在提供用户友好的移动记账体验。这个系统包括三个主要组成部分：前台小程序源代码、后台接口源代码和后台管理源代码...
sql递归随记
weixin_50648720的博客
07-14 199
sql递归随记
sql随记
风雨小树林的博客
12-31 440
DML语言，比如update，delete，insert等修改表中数据的需要commit; DDL语言，比如create，drop等改变表结构的，就不需要写commit（因为内部隐藏了commit）; 最好都commit select sysdate time from dual（无表操作用dual） （dual是Oracle提供的最小的工作表） select * from table for update;更新操作（开锁） 非空验证：select sum(decode(字段名,null,1,0
#随记牛客sql题-牛客1-87题 实际74题
qq_43031303的博客
03-11 1452
#随记牛客sql题-牛客1-87题 实际74题 1、查找最晚入职员工的所有信息 select * from employees order by hire_date desc limit 1 select * from employees where hire_date = (select max(hire_date) from employees) 2、查找入职员工时间排名倒数第三的员工所有信息 select * from employees order by hire_date desc limit 2
PL/SQL Developer遇到一个奇葩无效标识符问题随记
qq_43685346的博客
02-15 621
PL/SQL Developer遇到一个奇葩无效标识符问题随记
Java随记
weixin_52938172的博客
12-07 1889
Java开发常用基础技术点使用场景和使用方式。
九、安装artifactory并配置PostgreSQL--失败了
shafatudou的博客
09-01 1487
基于八，克隆出一个新的虚拟机，用来安装制品库并配置mysql数据库。仅参考，未使用（配置的centos自带的数据库，不会用）
【网络安全】空字节绕过：URL回调+XSS+SQL绕WAF
最新发布
等风来
09-07 98
经过进一步测试，我发现WAF在解析HTTP请求时，如果发现恶意查询，会导致服务器挂起。如果我连续提交3个请求且服务器挂起，它就会阻止我的IP地址。
【SQL】跳过记录筛选第二名
Frost_Descent的博客
09-03 954
当从数据库表中查询数据时，如果表中某列包含重复的值，而又只想获取这些值的唯一列表，那么就可以使用。，那么 SQL 会返回这些列组合起来的唯一值。子句通常一起使用来限制查询结果的数量，并指定从哪里开始获取这些结果。这通常用于获取查询结果的第二行数据（假设结果集是按某种顺序排列的，比如按主键或某个特定的列排序）。可以考虑使用 ifNull（查询，null）方法，或者通过外层再加一层查询，使其作为临时表。在某些数据库系统中（如SQL Server），可能需要使用不同的语法来实现分页，比如。id 是这个表的主键。
C++随记：内存管理、内联函数与默认参数详解
在"C++随记"文档中，记录了几个关键的C++知识点，对于学习者来说具有较高的参考价值。首先，关于内存管理，提到了`new`和`delete`以及`new[]`和`delete[]`操作符的重要性，强调了在C++中正确使用这些运算符以避免...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值