sql語句練習50題(Mysql版)

表名和字段
–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_score) –學生編號,課程編號,分數
測試數據

 1 --建表 --學生表 CREATE TABLE `Student`(
 2     `s_id` VARCHAR(20),
 3     `s_name` VARCHAR(20) NOT NULL DEFAULT '',
 4     `s_birth` VARCHAR(20) NOT NULL DEFAULT '',
 5     `s_sex` VARCHAR(10) NOT NULL DEFAULT '',
 6     PRIMARY KEY(`s_id`)
 7 ); --課程表 CREATE TABLE `Course`(
 8     `c_id`  VARCHAR(20),
 9     `c_name` VARCHAR(20) NOT NULL DEFAULT '',
10     `t_id` VARCHAR(20) NOT NULL,
11     PRIMARY KEY(`c_id`)
12 ); --教師表 CREATE TABLE `Teacher`(
13     `t_id` VARCHAR(20),
14     `t_name` VARCHAR(20) NOT NULL DEFAULT '',
15     PRIMARY KEY(`t_id`)
16 ); --成績表 CREATE TABLE `Score`(
17     `s_id` VARCHAR(20),
18     `c_id`  VARCHAR(20),
19     `s_score` INT(3),
20     PRIMARY KEY(`s_id`,`c_id`)
21 ); --插入學生表測試數據 insert into Student values('01' , '趙雷' , '1990-01-01' , '男'); insert into Student values('02' , '錢電' , '1990-12-21' , '男'); insert into Student values('03' , '孫風' , '1990-05-20' , '男'); insert into Student values('04' , '李云' , '1990-08-06' , '男'); insert into Student values('05' , '周梅' , '1991-12-01' , '女'); insert into Student values('06' , '吳蘭' , '1992-03-01' , '女'); insert into Student values('07' , '鄭竹' , '1989-07-01' , '女'); insert into Student values('08' , '王菊' , '1990-01-20' , '女'); --課程表測試數據 insert into Course values('01' , '語文' , '02'); insert into Course values('02' , '數學' , '01'); insert into Course values('03' , '英語' , '03'); --教師表測試數據 insert into Teacher values('01' , '張三'); insert into Teacher values('02' , '李四'); insert into Teacher values('03' , '王五'); --成績表測試數據 insert into Score values('01' , '01' , 80); insert into Score values('01' , '02' , 90); insert into Score values('01' , '03' , 99); insert into Score values('02' , '01' , 70); insert into Score values('02' , '02' , 60); insert into Score values('02' , '03' , 80); insert into Score values('03' , '01' , 80); insert into Score values('03' , '02' , 80); insert into Score values('03' , '03' , 80); insert into Score values('04' , '01' , 50); insert into Score values('04' , '02' , 30); insert into Score values('04' , '03' , 20); insert into Score values('05' , '01' , 76); insert into Score values('05' , '02' , 87); insert into Score values('06' , '01' , 31); insert into Score values('06' , '03' , 34); insert into Score values('07' , '02' , 89); insert into Score values('07' , '03' , 98);
View Code

練習題和sql語句

-- 1、查詢"01"課程比"02"課程成績高的學生的信息及課程分數  
select a.* ,b.s_score as 01_score,c.s_score as 02_score from student a join score b on a.s_id=b.s_id and b.c_id='01'left join score c on a.s_id=c.s_id and c.c_id='02' or c.c_id = NULL where b.s_score>c.s_score-- 2、查詢"01"課程比"02"課程成績低的學生的信息及課程分數
select a.* ,b.s_score as 01_score,c.s_score as 02_score from student a left join score b on a.s_id=b.s_id and b.c_id='01' or b.c_id=NULL join score c on a.s_id=c.s_id and c.c_id='02' where b.s_score<c.s_score-- 3、查詢平均成績大于等于60分的同學的學生編號和學生姓名和平均成績
select b.s_id,b.s_name,ROUND(AVG(a.s_score),2) as avg_score from student b join score a on b.s_id = a.s_idGROUP BY b.s_id,b.s_name HAVING ROUND(AVG(a.s_score),2)>=60; -- 4、查詢平均成績小于60分的同學的學生編號和學生姓名和平均成績 -- (包括有成績的和無成績的) 
select b.s_id,b.s_name,ROUND(AVG(a.s_score),2) as avg_score from student b left join score a on b.s_id = a.s_idGROUP BY b.s_id,b.s_name HAVING ROUND(AVG(a.s_score),2)<60union
select a.s_id,a.s_name,0 as avg_score from student a where a.s_id not in (select distinct s_id from score); -- 5、查詢所有同學的學生編號、學生姓名、選課總數、所有課程的總成績 
select a.s_id,a.s_name,count(b.c_id) as sum_course,sum(b.s_score) as sum_score from student a left join score b on a.s_id=b.s_idGROUP BY a.s_id,a.s_name; 
-- 6、查詢"李"姓老師的數量 
select count(t_id) from teacher where t_name like '李%'; 
-- 7、查詢學過"張三"老師授課的同學的信息 
select a.* from student a join score b on a.s_id=b.s_id where b.c_id in(select c_id from course where t_id =(select t_id from teacher where t_name = '張三')); 
-- 8、查詢沒學過"張三"老師授課的同學的信息 
select * from student c where c.s_id not in(select a.s_id from student a join score b on a.s_id=b.s_id where b.c_id in(select c_id from course where t_id =(select t_id from teacher where t_name = '張三'))); 
-- 9、查詢學過編號為"01"并且也學過編號為"02"的課程的同學的信息 
select a.* from student a,score b,score c where a.s_id = b.s_id  and a.s_id = c.s_id and b.c_id='01' and c.c_id='02'; -- 10、查詢學過編號為"01"但是沒有學過編號為"02"的課程的同學的信息 
select a.* from student a where a.s_id in (select s_id from score where c_id='01' ) and a.s_id not in(select s_id from score where c_id='02')-- 11、查詢沒有學全所有課程的同學的信息 
select s.* from student s where s.s_id in(select s_id from score where s_id not in(select a.s_id from score a join score b on a.s_id = b.s_id and b.c_id='02'join score c on a.s_id = c.s_id and c.c_id='03'where a.c_id='01'))-- 12、查詢至少有一門課與學號為"01"的同學所學相同的同學的信息 
select * from student where s_id in(select distinct a.s_id from score a where a.c_id in(select a.c_id from score a where a.s_id='01')); 
-- 13、查詢和"01"號的同學學習的課程完全相同的其他同學的信息 
select a.* from student a where a.s_id in(select distinct s_id from score where s_id!='01' and c_id in(select c_id from score where s_id='01')group by s_id having count(1)=(select count(1) from score where s_id='01')); 
-- 14、查詢沒學過"張三"老師講授的任一門課程的學生姓名 
select a.s_name from student a where a.s_id not in (select s_id from score where c_id = (select c_id from course where t_id =(select t_id from teacher where t_name = '張三')) group by s_id); 
-- 15、查詢兩門及其以上不及格課程的同學的學號，姓名及其平均成績 
select a.s_id,a.s_name,ROUND(AVG(b.s_score)) from student a left join score b on a.s_id = b.s_idwhere a.s_id in(select s_id from score where s_score<60 GROUP BY  s_id having count(1)>=2)GROUP BY a.s_id,a.s_name-- 16、檢索"01"課程分數小于60，按分數降序排列的學生信息
select a.*,b.c_id,b.s_score from student a,score b where a.s_id = b.s_id and b.c_id='01' and b.s_score<60 ORDER BY b.s_score DESC; 
-- 17、按平均成績從高到低顯示所有學生的所有課程的成績以及平均成績 
select a.s_id,(select s_score from score where s_id=a.s_id and c_id='01') as 語文,(select s_score from score where s_id=a.s_id and c_id='02') as 數學,(select s_score from score where s_id=a.s_id and c_id='03') as 英語,round(avg(s_score),2) as 平均分 from score a  GROUP BY a.s_id ORDER BY 平均分 DESC; -- 18.查詢各科成績最高分、最低分和平均分：以如下形式顯示：課程ID，課程name，最高分，最低分，平均分，及格率，中等率，優良率，優秀率 --及格為>=60，中等為：70-80，優良為：80-90，優秀為：>=90 
select a.c_id,b.c_name,MAX(s_score),MIN(s_score),ROUND(AVG(s_score),2),ROUND(100*(SUM(case when a.s_score>=60 then 1 else 0 end)/SUM(case when a.s_score then 1 else 0 end)),2) as 及格率,ROUND(100*(SUM(case when a.s_score>=70 and a.s_score<=80 then 1 else 0 end)/SUM(case when a.s_score then 1 else 0 end)),2) as 中等率,ROUND(100*(SUM(case when a.s_score>=80 and a.s_score<=90 then 1 else 0 end)/SUM(case when a.s_score then 1 else 0 end)),2) as 優良率,ROUND(100*(SUM(case when a.s_score>=90 then 1 else 0 end)/SUM(case when a.s_score then 1 else 0 end)),2) as 優秀率from score a left join course b on a.c_id = b.c_id GROUP BY a.c_id,b.c_name-- 19、按各科成績進行排序，并顯示排名(實現不完全)
-- mysql沒有rank函數
select a.s_id,a.c_id,@i:=@i +1 as i保留排名,@k:=(case when @score=a.s_score then @k else @i end) as rank不保留排名,@score:=a.s_score as scorefrom (select s_id,c_id,s_score from score WHERE c_id='01' GROUP BY s_id,c_id,s_score ORDER BY s_score DESC
)a,(select @k:=0,@i:=0,@score:=0)sunionselect a.s_id,a.c_id,@i:=@i +1 as i,@k:=(case when @score=a.s_score then @k else @i end) as rank,@score:=a.s_score as scorefrom (select s_id,c_id,s_score from score WHERE c_id='02' GROUP BY s_id,c_id,s_score ORDER BY s_score DESC
)a,(select @k:=0,@i:=0,@score:=0)sunionselect a.s_id,a.c_id,@i:=@i +1 as i,@k:=(case when @score=a.s_score then @k else @i end) as rank,@score:=a.s_score as scorefrom (select s_id,c_id,s_score from score WHERE c_id='03' GROUP BY s_id,c_id,s_score ORDER BY s_score DESC
)a,(select @k:=0,@i:=0,@score:=0)s-- 20、查詢學生的總成績并進行排名
select a.s_id,@i:=@i+1 as i,@k:=(case when @score=a.sum_score then @k else @i end) as rank,@score:=a.sum_score as score
from (select s_id,SUM(s_score) as sum_score from score GROUP BY s_id ORDER BY sum_score DESC)a,(select @k:=0,@i:=0,@score:=0)s-- 21、查詢不同老師所教不同課程平均分從高到低顯示 select a.t_id,c.t_name,a.c_id,ROUND(avg(s_score),2) as avg_score from course aleft join score b on a.c_id=b.c_id left join teacher c on a.t_id=c.t_idGROUP BY a.c_id,a.t_id,c.t_name ORDER BY avg_score DESC; -- 22、查詢所有課程的成績第2名到第3名的學生信息及該課程成績 
select d.*,c.排名,c.s_score,c.c_id from (select a.s_id,a.s_score,a.c_id,@i:=@i+1 as 排名 from score a,(select @i:=0)s where a.c_id='01'    )cleft join student d on c.s_id=d.s_idwhere 排名 BETWEEN 2 AND 3UNIONselect d.*,c.排名,c.s_score,c.c_id from (select a.s_id,a.s_score,a.c_id,@j:=@j+1 as 排名 from score a,(select @j:=0)s where a.c_id='02'    )cleft join student d on c.s_id=d.s_idwhere 排名 BETWEEN 2 AND 3UNIONselect d.*,c.排名,c.s_score,c.c_id from (select a.s_id,a.s_score,a.c_id,@k:=@k+1 as 排名 from score a,(select @k:=0)s where a.c_id='03'    )cleft join student d on c.s_id=d.s_idwhere 排名 BETWEEN 2 AND 3; -- 23、統計各科成績各分數段人數：課程編號,課程名稱,[100-85],[85-70],[70-60],[0-60]及所占百分比 select distinct f.c_name,a.c_id,b.`85-100`,b.百分比,c.`70-85`,c.百分比,d.`60-70`,d.百分比,e.`0-60`,e.百分比 from score aleft join (select c_id,SUM(case when s_score >85 and s_score <=100 then 1 else 0 end) as `85-100`,ROUND(100*(SUM(case when s_score >85 and s_score <=100 then 1 else 0 end)/count(*)),2) as 百分比from score GROUP BY c_id)b on a.c_id=b.c_idleft join (select c_id,SUM(case when s_score >70 and s_score <=85 then 1 else 0 end) as `70-85`,ROUND(100*(SUM(case when s_score >70 and s_score <=85 then 1 else 0 end)/count(*)),2) as 百分比from score GROUP BY c_id)c on a.c_id=c.c_idleft join (select c_id,SUM(case when s_score >60 and s_score <=70 then 1 else 0 end) as `60-70`,ROUND(100*(SUM(case when s_score >60 and s_score <=70 then 1 else 0 end)/count(*)),2) as 百分比from score GROUP BY c_id)d on a.c_id=d.c_idleft join (select c_id,SUM(case when s_score >=0 and s_score <=60 then 1 else 0 end) as `0-60`,ROUND(100*(SUM(case when s_score >=0 and s_score <=60 then 1 else 0 end)/count(*)),2) as 百分比from score GROUP BY c_id)e on a.c_id=e.c_idleft join course f on a.c_id = f.c_id-- 24、查詢學生平均成績及其名次 select a.s_id,@i:=@i+1 as '不保留空缺排名',@k:=(case when @avg_score=a.avg_s then @k else @i end) as '保留空缺排名',@avg_score:=avg_s as '平均分'from (select s_id,ROUND(AVG(s_score),2) as avg_s from score GROUP BY s_id)a,(select @avg_score:=0,@i:=0,@k:=0)b; -- 25、查詢各科成績前三名的記錄 -- 1.選出b表比a表成績大的所有組 -- 2.選出比當前id成績大的 小于三個的 
select a.s_id,a.c_id,a.s_score from score a left join score b on a.c_id = b.c_id and a.s_score<b.s_scoregroup by a.s_id,a.c_id,a.s_score HAVING COUNT(b.s_id)<3ORDER BY a.c_id,a.s_score DESC-- 26、查詢每門課程被選修的學生數 
select c_id,count(s_id) from score a GROUP BY c_id-- 27、查詢出只有兩門課程的全部學生的學號和姓名 
select s_id,s_name from student where s_id in(select s_id from score GROUP BY s_id HAVING COUNT(c_id)=2); -- 28、查詢男生、女生人數 
select s_sex,COUNT(s_sex) as 人數  from student GROUP BY s_sex-- 29、查詢名字中含有"風"字的學生信息
select * from student where s_name like '%風%'; -- 30、查詢同名同性學生名單，并統計同名人數 
select a.s_name,a.s_sex,count(*) from student a  JOIN student b on a.s_id !=b.s_id and a.s_name = b.s_name and a.s_sex = b.s_sexGROUP BY a.s_name,a.s_sex-- 31、查詢1990年出生的學生名單
select s_name from student where s_birth like '1990%'-- 32、查詢每門課程的平均成績，結果按平均成績降序排列，平均成績相同時，按課程編號升序排列 
select c_id,ROUND(AVG(s_score),2) as avg_score from score GROUP BY c_id ORDER BY avg_score DESC,c_id ASC-- 33、查詢平均成績大于等于85的所有學生的學號、姓名和平均成績 
select a.s_id,b.s_name,ROUND(avg(a.s_score),2) as avg_score from score aleft join student b on a.s_id=b.s_id GROUP BY s_id HAVING avg_score>=85-- 34、查詢課程名稱為"數學"，且分數低于60的學生姓名和分數 
select a.s_name,b.s_score from score b LEFT JOIN student a on a.s_id=b.s_id where b.c_id=(select c_id from course where c_name ='數學') and b.s_score<60-- 35、查詢所有學生的課程及分數情況； 
select a.s_id,a.s_name,SUM(case c.c_name when '語文' then b.s_score else 0 end) as '語文',SUM(case c.c_name when '數學' then b.s_score else 0 end) as '數學',SUM(case c.c_name when '英語' then b.s_score else 0 end) as '英語',SUM(b.s_score) as  '總分'from student a left join score b on a.s_id = b.s_id left join course c on b.c_id = c.c_id GROUP BY a.s_id,a.s_name-- 36、查詢任何一門課程成績在70分以上的姓名、課程名稱和分數； 
select a.s_name,b.c_name,c.s_score from course b left join score c on b.c_id = c.c_idleft join student a on a.s_id=c.s_id where c.s_score>=70-- 37、查詢不及格的課程
select a.s_id,a.c_id,b.c_name,a.s_score from score a left join course b on a.c_id = b.c_idwhere a.s_score<60 --38、查詢課程編號為01且課程成績在80分以上的學生的學號和姓名； 
select a.s_id,b.s_name from score a LEFT JOIN student b on a.s_id = b.s_idwhere a.c_id = '01' and a.s_score>80-- 39、求每門課程的學生人數 
select count(*) from score GROUP BY c_id; -- 40、查詢選修"張三"老師所授課程的學生中，成績最高的學生信息及其成績 -- 查詢老師id   
select c_id from course c,teacher d where c.t_id=d.t_id and d.t_name='張三'-- 查詢最高分（可能有相同分數）select MAX(s_score) from score where c_id='02'-- 查詢信息select a.*,b.s_score,b.c_id,c.c_name from student aLEFT JOIN score b on a.s_id = b.s_idLEFT JOIN course c on b.c_id=c.c_idwhere b.c_id =(select c_id from course c,teacher d where c.t_id=d.t_id and d.t_name='張三')and b.s_score in (select MAX(s_score) from score where c_id='02')-- 41、查詢不同課程成績相同的學生的學生編號、課程編號、學生成績 select DISTINCT b.s_id,b.c_id,b.s_score from score a,score b where a.c_id != b.c_id and a.s_score = b.s_score-- 42、查詢每門功成績最好的前兩名 
-- 牛逼的寫法
select a.s_id,a.c_id,a.s_score from score awhere (select COUNT(1) from score b where b.c_id=a.c_id and b.s_score>=a.s_score)<=2 ORDER BY a.c_id-- 43、統計每門課程的學生選修人數（超過5人的課程才統計）。要求輸出課程號和選修人數，查詢結果按人數降序排列，若人數相同，按課程號升序排列  
select c_id,count(*) as total from score GROUP BY c_id HAVING total>5 ORDER BY total,c_id ASC-- 44、檢索至少選修兩門課程的學生學號 
select s_id,count(*) as sel from score GROUP BY s_id HAVING sel>=2-- 45、查詢選修了全部課程的學生信息 
select * from student where s_id in(        select s_id from score GROUP BY s_id HAVING count(*)=(select count(*) from course))--46、查詢各學生的年齡-- 按照出生日期來算，當前月日 < 出生年月的月日則，年齡減一select s_birth,(DATE_FORMAT(NOW(),'%Y')-DATE_FORMAT(s_birth,'%Y') - (case when DATE_FORMAT(NOW(),'%m%d')>DATE_FORMAT(s_birth,'%m%d') then 0 else 1 end)) as agefrom student; -- 47、查詢本周過生日的學生 
select * from student where WEEK(DATE_FORMAT(NOW(),'%Y%m%d'))=WEEK(s_birth)select * from student where YEARWEEK(s_birth)=YEARWEEK(DATE_FORMAT(NOW(),'%Y%m%d'))select WEEK(DATE_FORMAT(NOW(),'%Y%m%d'))-- 48、查詢下周過生日的學生select * from student where WEEK(DATE_FORMAT(NOW(),'%Y%m%d'))+1 =WEEK(s_birth)-- 49、查詢本月過生日的學生select * from student where MONTH(DATE_FORMAT(NOW(),'%Y%m%d')) =MONTH(s_birth)-- 50、查詢下月過生日的學生select * from student where MONTH(DATE_FORMAT(NOW(),'%Y%m%d'))+1 =MONTH(s_birth)
View Code

?

轉載于:https://www.cnblogs.com/xiaofengfree/p/10232214.html

本文來自互聯網用戶投稿，該文觀點僅代表作者本人，不代表本站立場。本站僅提供信息存儲空間服務，不擁有所有權，不承擔相關法律責任。
如若轉載，請注明出處：http://www.pswp.cn/news/278506.shtml
繁體地址，請注明出處：http://hk.pswp.cn/news/278506.shtml
英文地址，請注明出處：http://en.pswp.cn/news/278506.shtml

如若內容造成侵權/違法違規/事實不符，請聯系多彩編程網進行投訴反饋email:809451989@qq.com，一經查實，立即刪除！

相關文章

OpenCV3 識別圖中表格-JAVA 實現

OpenCV3 識別圖中表格-JAVA 實現

2019獨角獸企業重金招聘Python工程師標準>>> 關于 JAVA 學習 OpenCV 的內容&#xff0c;函數講解。內容我均整理在 GitHubd的OpenCV3-Study-JAVA OpenCV 3 識別圖中表格-Java 實現 1. 說明 網上大部分資料&#xff0c;都是針對 C的&#xff0c;python、java 的例子太…
閱讀更多...
內存泄露 體現在哪個數字上_Microsoft剛剛泄漏了一個新的開始菜單。 你喜歡哪個？...

內存泄露 體現在哪個數字上_Microsoft剛剛泄漏了一個新的開始菜單。 你喜歡哪個？...

內存泄露 體現在哪個數字上NTAuthority on TwitterTwitter上的NTAuthorityMicrosoft messed up today, releasing an internal build of Windows 10 to Windows Insiders. This build was never meant to see the light of day, but it features a new Start menu design—with…
閱讀更多...
簡述 Spring Cloud 是什么

簡述 Spring Cloud 是什么

很多同學都了解了Spring &#xff0c;了解了 Spring Boot, 但對于 Spring Cloud 是什么還是比較懵逼的。 本文帶你簡單的了解下&#xff0c;什么是Spring Cloud。 Spring Cloud 是什么 從字面理解&#xff0c;Spring Cloud 就是致力于分布式系統、云服務的框架。 Spring Cloud …
閱讀更多...
js DOM節點

js DOM節點

元素節點 4種方式獲取 var oDiv document.getElementById("box");　　　　　　　　//通過Id獲取元素var oDiv document.getElementsByClassName("div")[0];　　 //通過類名獲取元素　　--》[ 0 ]　必須寫var oDiv document.getElementsByTagName("…
閱讀更多...
python web scraping

python web scraping

2019獨角獸企業重金招聘Python工程師標準>>> 最近在看《Web Scraping with Python》&#xff0c;借此來熟悉Python2.7如何開始編程。 發現書上主要使用的 http://example.webscraping.com/ 網站有部分變化&#xff0c;書中的代碼有點無法對照使用&#xff0c;因此稍…
閱讀更多...
傅里葉變換的物理意義

傅里葉變換的物理意義

用三角函數表示周期函數 傅里葉的相關理論始于下面假設&#xff1a;對于周期為1的信號$f(t)$&#xff0c;可以由不同頻率的三角函數組成&#xff0c; $f(t) \frac{a_0}{2}\displaystyle{\sum^{\infty}_{k1}}(a_kcos(2\pi kt)b_ksin(2\pi kt))$ 組成的基礎波形為一個信號對&…
閱讀更多...
天貓年度總結

天貓年度總結

2019獨角獸企業重金招聘Python工程師標準>>> 魯大師天貓工作總結 時間&#xff1a;2017年10月22日-1月30日 1、對代理商進行6大區域的劃分管理&#xff0c;有專門的客服指導。 2、加班費申請和車費報銷制度。 3、簡化了特權訂金2階段改成1階段&#xff0c;極大的方便…
閱讀更多...
因特網使用期限_Internet死亡時使用PC的其他方式

因特網使用期限_Internet死亡時使用PC的其他方式

因特網使用期限Nothing is more annoying than getting your Internet connection shut down, due to weather, or perhaps forgetting to pay your bill. Let’s take a look at some ways you can be productive and entertained without the Internet. 沒有什么比由于天氣原…
閱讀更多...
【基礎操作】線性基詳解

【基礎操作】線性基詳解

線性基是一個奇妙的集合&#xff08;我摘的原話&#xff09; 這里以非 $OI$ 的角度介紹了線性基 基礎部分 模板題 給你 $n$ 個數的集合&#xff0c;讓你選出任意多個不重復的數&#xff0c;使得它們的異或和最大。 線性基是什么 我們稱集合 $B$ 是集合 $S$ 的線性基&#xff0c…
閱讀更多...
節省大量教科書的三種潛在風險方法

節省大量教科書的三種潛在風險方法

Photo by Sultry 攝影&#xff1a; Sultry You can always save money on textbooks by buying online, going ebook, or renting what you need. But there are riskier ways to save a buck that just may yield even greater payoff, such as getting the international or …
閱讀更多...
解決內網搭建本地yum倉庫。

解決內網搭建本地yum倉庫。

2019獨角獸企業重金招聘Python工程師標準>>> 一、使用iso鏡像搭建本地yum倉庫&#xff1b; 1、掛載鏡像到/mnt目錄下&#xff1a; [rootDasoncheng ~]# mount /dev/cdrom /mnt mount: /dev/sr0 is write-protected, mounting read-only2、備份配置文件&#xff0c;并…
閱讀更多...
通過用 .NET 生成自定義窗體設計器來定制應用程序

通過用 .NET 生成自定義窗體設計器來定制應用程序

本文討論&#xff1a; ? 設計時環境基本原理 ? 窗體設計器體系結構 ? Visual Studio .NET 中窗體設計器的實現 ? 為自己的應用程序編寫窗體設計器而需要實現的服務 在很多年中&#xff0c;MFC 一直是生成基于 Windows? 的應用程序的流行框架。MFC 包含一個可以使窗體生成、…
閱讀更多...
airdrop 是 藍牙嗎_您可以在Windows PC或Android手機上使用AirDrop嗎？

airdrop 是 藍牙嗎_您可以在Windows PC或Android手機上使用AirDrop嗎？

airdrop 是 藍牙嗎Aleksey Khilko/Shutterstock.comAleksey Khilko / Shutterstock.comApple’s AirDrop is a convenient way to send photos, files, links, and other data between devices. AirDrop only works on Macs, iPhones, and iPads, but similar solutions are av…
閱讀更多...
vue加百度統計代碼（親測有效）

vue加百度統計代碼（親測有效）

申請百度統計后&#xff0c;會得到一段JS代碼&#xff0c;需要插入到每個網頁中去&#xff0c;在Vue.js項目首先想到的可能就是&#xff0c;把統計代碼插入到index.html入口文件中&#xff0c;這樣就全局插入&#xff0c;每個頁面就都有了;這樣做就涉及到一個問題&#xff0c;V…
閱讀更多...
如何將Rant變成生產力電動工具

如何將Rant變成生產力電動工具

Ranting doesn’t have to be a waste of breathe and time. You can turn a rant into a powerful tool for productivity. Learn how to transform your sense of victim hood and irritability to self-empowerment and mental clarity. 狂歡不必浪費呼吸和時間。 您可以將r…
閱讀更多...
linux 下使用 curl post

linux 下使用 curl post

命令&#xff1a; curl -X POST -d /etc/lazada/lazada_tracking.txt http://localhost:8080/booking/rs/LazadaService/post --header "Content-Type:application/json" -d 后臺 / &#xff1a; post 的 body　體 &#xff45;&#xff47;&#xff1a; {"a…
閱讀更多...
服務治理·理論篇(一)

服務治理·理論篇(一)

0、故事主角 呱呱樂 是一家互聯網金融公司。主營現金貸、p2p理財、消費分期業務。 公司現有技術人員800名&#xff0c;系統極其龐雜&#xff0c;每日穩定處理25w左右的訂單量&#xff0c;有搶購活動時&#xff0c;系統的QPS(Query Per Second)峰值達到了3w。 系統雖然龐雜&…
閱讀更多...
2019-1-92.4G射頻芯片培訓資料

2019-1-92.4G射頻芯片培訓資料

2019-1-92.4G射頻芯片培訓資料 培訓 RF 小書匠 歡迎走進zozo的學習之旅。 2.4G芯片選型2.4G芯片開發Q&A2.4G芯片選型 芯片類型 soc防盜標簽2.4G無線芯片選型發射器收發器LSD2RF-1600-V1.1 調制方式射頻基礎 2.4G芯片開發 原理圖 發射優先收發均衡PCB topbottomlayout規…
閱讀更多...
在Outlook 2010中使用對話視圖

在Outlook 2010中使用對話視圖

One of the new features in Outlook 2010 is the ability to use Conversation View for easier management of your email conversations. Here we will take a quick look at how to use the new feature. Outlook 2010中的新功能之一是可以使用“對話視圖”來更輕松地管理電…
閱讀更多...
openresty capture

openresty capture

local args {} args["name"] "張三" args["sex"] "男"local captureRes; if ngx.var.request_method "POST" thencaptureRes ngx.location.capture(/dsideal_yy/test, {method ngx.HTTP_POST, headers { ["Cont…
閱讀更多...
最新文章

Copyright @ 2022~2023