锘??xml version="1.0" encoding="utf-8" standalone="yes"?> --select * from authors --select au_lname, au_fname from authors where state ='CA' --select * from publishers --select distinct state from publishers --select *from titles --select * from titles where price is null -- select case when price is null then 0 else price end from titles-- it works!!!!!!!!!! -- 4 Functions --select varchar_format(current date - date('2011-01-01') + date, 'DD-MM-YY') as newDate, -- varchar_format(date,'DD-MM-YY') as olddate from sales --values current date - date('2014-01-01') + date('2014-01-02') --select *from roysched --select hex(lorange) from roysched --select * from titles where price in (20,19) -- in one shot ZANZANZANZANZAN!!! select --select * from authors --select au_lname, au_fname from authors where state ='CA' --select * from publishers --select distinct state from publishers --select *from titles --select * from titles where price is null -- select case when price is null then 0 else price end from titles-- it works!!!!!!!!!! -- 4 Functions --select varchar_format(current date - date('2011-01-01') + date, 'DD-MM-YY') as newDate, -- varchar_format(date,'DD-MM-YY') as olddate from sales --values current date - date('2014-01-01') + date('2014-01-02') --select *from roysched --select hex(lorange) from roysched --select * from titles where price in (20,19) -- in one shot ZANZANZANZANZAN!!! --select case type when 'business' then Title else 'other' end from titles --select syscolumns.length from syscolumns where syscolumns.id = 'titles' and syscolumns.name = 'title' --5 Grouping --select (days(max(pubdate)) - days(min(pubdate)) )/365 from titles --select title from titles order by length(title) --select *from titles --select count(*) from authors group by city --select title from titles where length(title) = (select max(length(title)) from titles) --select coalesce(price,0) from titles -- yuan lai bushi yong is null shi yong zhe ge a!!!! --select length(price) from titles /* select title from titles where length(title) >= all ( select length(title) from titles ) */ --select pubdate from titles /* select title,pubdate from titles where pubdate >= all ( select pubdate from titles ) */ --select count(*) from sales group by stor_num --select * from sales --select * from publishers --select * from titles as a inner join publishers as b on a.pub_id = b.pub_id --select title,city,a.pub_id from titles as a inner join publishers as b on a.pub_id = b.pub_id where city not in ('Boston') --select * from psales /* select b.ord_num,b.discount,d.discounttype from psales as a inner join salesdetail as b on a.stor_id = b. stor_id and a.ord_num = b.ord_num inner join stores as c on a.stor_id = c.stor_id inner join discounts as d on c.stor_id = d.stor_id order by b.ord_num */ --select * from authors --select * from publishers --select * from authors as a inner join publishers as b on a.city = b.city --select sum(qty) from salesdetail --select pub_name, count(distinct type) from publishers as a inner join titles as b on a.pub_id = b.pub_id group by pub_name --select *from titleauthor --7 Sub-Queries /* select pub_name from publishers where pub_id in ( select pub_id from titles ) */ --select * from publishers --nice !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! /* select type,title,t1.price from titles as t1 where price > (select avg(price) from titles as t2 where t2.type = t1.type) */ -- nice !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! 銆 select from where 銆 --select * from titles --select t1.type,t1.title,t1.price,(select avg(price) from titles as t2 where t2.type = t1.type) --from titles as t1 --where price > (select avg(price) from titles as t2 where t2.type = t1.type) 銆 --select avg(price) from titles --select abs(13.93750000000000000000000000- price) from titles --select coalesce(abs((select avg(price) from titles) - price),0) from titles --select count(*) as ANS from SB_AUCTION where (days(enddate) - days(startdate) < 10) /* select */ 銆 --select * from sb_bid --select name from (sb_bid as a inner join sb_auction as b on a.bidder = b.userid) inner join sb_user as c on b.userid = c.userid group by name --select * from authors --select newA.name from --( --select name,c.itemid from (sb_user as a inner join sb_auction as b on a.userid = b.userid) -- inner join sb_item as c on b.itemid = c.itemid --) AS newA --select * from sb_auction /* create as select */ --select * from weitaol_view 銆 select select * from sb_auction */
鏈泭姣旀槸鏌愮鑲$エ鏅氳偂姣忚偂甯備環涓庢瘡鑲$泩鍒╃殑姣旂巼銆傛墍浠ュ畠涔熺О涓鴻偂浠鋒敹鐩婃瘮鐜囨垨甯備環鐩堝埄姣旂巼銆?濡傛錛屾湰鐩婃瘮搴旇鏄氬父鎵璇寸殑甯傜泩鐜囥?
椹潵瑗夸簹鍜屾柊鍔犲潯璐㈢粡鎶ョ珷涓鑸皢鍏剁О涓?#8220;鏈泭姣?#8221;錛岃岄娓拰涓浗涓鑸О浣?#8220;甯傜泩鐜?#8221;錛屽叾瀹炲彧鏄О鍛間笉鍚岋紝浣嗗唴瀹瑰拰鍚箟鐩稿悓錛岃嫳鏂囧垯縐頒負P/E RATIO鎴栬匬ER錛屽氨鏄疨RICE/EARNING RATIO鐨勭緝鍐欍?
鏈泭姣旂殑璁$畻鏂瑰紡錛?
Market Value per Share錛堣偂紲ㄥ綋浠婁環鏍鹼級
Earnings per Share (EPS)錛堟瘡鑲$泩鍒╋級
鑲$エ褰撲粖浠鋒牸涔熷氨鏄偂紲ㄩ棴甯傜殑浠鋒牸銆?
姣忚偂鐩堝埄鍒欐槸鍏徃鐩堝埄闄や簬鑲$エ鏁伴噺銆?
渚嬪瓙錛氫竴闂翠笂甯傚叕鍙告嫢鏈?00涓囪偂錛?012騫村害鍏徃鐩堝埄涓?0涓囥?
姣忚偂鐩堝埄灝辯瓑浜?50涓?#247;100涓?= 0.50 錛堟瘡鑲″垎寰?.50鐨勭泩鍒╋級
EPS(Earning Per Share) 灝辨槸0.50
濡傛灉璇ュ叕鍙擱棴甯備環鏍間負RM2.00 鏈泭姣斿氨鏄?.00/0.50 = 4鍊?
鐢ㄧ櫧璇濊В閲婃湰鐩婃瘮錛屼竴鍙ュ氨鎼炲畾浜嗭細 鏈泭姣斿叾瀹炲氨鏄洖鏈勾浠斤紝濡傛灉璇ヨ偂鏈泭姣斾負4鍊嶏紝浠h〃鎴戜滑璐拱璇ヨ偂錛?騫存墠鑳藉洖鏈?
鑲′環灝卞ソ姣斾綘鐨勬姇璧勯錛孍PS灝辨槸鎴戜滑鐨勫洖鎶ャ?濡傛灉璇ヨ偂闂競浠鋒牸RM2.00錛屾垜浠喘涔拌鑲℃湰閽卞氨RM2.00錛孍PS灝辨槸鎴戜滑鐨勫洖鎶ワ紝濡傛灉璇ヨ偂EPS鏄?.50錛屼唬琛ㄦ垜浠姇璧凴M2.00錛屾瘡騫磋兘鎷垮洖0.50錛岃4騫存墠鑳藉洖鏈紝榪?騫村叾瀹炲氨鏄垜浠父璇寸殑鏈泭姣斻?br />棰勬祴鏈泭姣斿氨鏄牴鎹鍏徃浠婂勾鐨勭泩鍒╋紝棰勬祴鏄庡勾鐨勭泩鍒╋紝鍐嶈綆楀嚭鏉ョ殑鏈泭姣斻?鏈泭姣斿叾瀹炲氨鏄洖鏈勾浠斤紝濡傛灉璇ュ叕鍙告病鏈夌泩鍒╋紝浣犳案榪滈兘涓嶈兘鍥炴湰錛岄偅涔堣鍏徃灝變笉浼氭湁鏈泭姣斻?椹埅灝辨槸娌℃湁鏈泭姣旂殑鏈濂戒緥瀛愩?寰堝浜哄彲鑳戒細璇達紝濡傛灉鏈泭姣斾唬琛ㄥ洖鏈勾浠斤紝閭d箞鏄笉鏄秺浣庤秺濂斤紵閭d箞灝辮〃紺鴻秺蹇洖鏈?鍏跺疄涓嶇劧錛屾湰鐩婃瘮铏界劧鏄唬琛ㄧ潃鍥炴湰騫翠喚錛屼絾涓嶄竴瀹氳秺浣庤秺濂斤紝瑕佽鍏徃鑰屽畾錛屽緢澶氳摑絳硅偂鐨勬湰鐩婃瘮閮藉緢楂橈紝涔熸湁寰堝鍨冨溇鑲℃湰鐩婃瘮閮藉緢浣庛?涓鑸笂浜掕仈緗戠鎶鑲$殑鏈泭姣旈兘寰堥珮銆?椹潵瑗夸簹鍩烘湰闈㈠ぇ甯堝喎鐪艱寰楁湰鐩婃瘮鍦?0浠ヤ笅鐨勫叕鍙革紝閮芥瘮杈冨悎鐞嗭紝鏈泭姣旇秴榪?0錛岃鑲℃湁琚珮浼扮殑鍙兘銆?br />杞嚜鐧懼害鐭ラ亾銆?/div>
.tar
瑙e寘錛歵ar -xvf FileName.tar
鎵撳寘錛歵ar -cvf FileName.tar DirName
錛堟敞錛歵ar鏄墦鍖咃紝涓嶆槸鍘嬬緝錛侊級
---------------------------------------------
.gz
瑙e帇1錛歡unzip FileName.gz
瑙e帇2錛歡zip -d FileName.gz
鍘嬬緝錛歡zip FileName
.tar.gz
瑙e帇錛歵ar zxvf FileName.tar.gz
鍘嬬緝錛歵ar zcvf FileName.tar.gz DirName
---------------------------------------------
.bz2
瑙e帇1錛歜zip2 -d FileName.bz2
瑙e帇2錛歜unzip2 FileName.bz2
鍘嬬緝錛?bzip2 -z FileName
.tar.bz2
瑙e帇錛歵ar jxvf FileName.tar.bz2
鍘嬬緝錛歵ar jcvf FileName.tar.bz2 DirName
---------------------------------------------
.bz
瑙e帇1錛歜zip2 -d FileName.bz
瑙e帇2錛歜unzip2 FileName.bz
鍘嬬緝錛氭湭鐭?nbsp;
---------------------------------------------
.tar.bz
瑙e帇錛歵ar jxvf FileName.tar.bz
鍘嬬緝錛氭湭鐭?nbsp;
---------------------------------------------
.Z
瑙e帇錛歶ncompress FileName.Z
鍘嬬緝錛歝ompress FileName
.tar.Z
瑙e帇錛歵ar Zxvf FileName.tar.Z
鍘嬬緝錛歵ar Zcvf FileName.tar.Z DirName
---------------------------------------------
.tgz
瑙e帇錛歵ar zxvf FileName.tgz
鍘嬬緝錛氭湭鐭?nbsp;
.tar.tgz
瑙e帇錛歵ar zxvf FileName.tar.tgz
鍘嬬緝錛歵ar zcvf FileName.tar.tgz FileName
---------------------------------------------
.zip
瑙e帇錛歶nzip FileName.zip
鍘嬬緝錛歾ip FileName.zip DirName
---------------------------------------------
.rar
瑙e帇錛歳ar a FileName.rar
鍘嬬緝錛歳ar e FileName.rar
---------------------------------------------
鍘嬬緝瑙e帇緙?nbsp;
zip鏂囦歡錛?nbsp;
鍔熻兘璇存槑錛氬帇緙╂枃浠躲?nbsp;
璇銆娉曪細zip [-AcdDfFghjJKlLmoqrSTuvVwXyz$][-b <宸ヤ綔鐩綍>][-ll][-n <瀛楀熬瀛楃涓?gt;][-t <鏃ユ湡鏃墮棿>][-<鍘嬬緝鏁堢巼>][鍘嬬緝鏂囦歡][鏂囦歡...][-i <鑼冩湰鏍峰紡>][-x <鑼冩湰鏍峰紡>]
琛ュ厖璇存槑錛歾ip鏄釜浣跨敤騫挎硾鐨勫帇緙╃▼搴忥紝鏂囦歡緇忓畠鍘嬬緝鍚庝細鍙﹀浜х敓鍏鋒湁".zip"鎵╁睍鍚嶇殑鍘嬬緝鏂囦歡銆?nbsp;
鍙傘銆鏁幫細
-A 璋冩暣鍙墽琛岀殑鑷姩瑙e帇緙╂枃浠躲?nbsp;
-b<宸ヤ綔鐩綍> 鎸囧畾鏆傛椂瀛樻斁鏂囦歡鐨勭洰褰曘?nbsp;
-c 鏇挎瘡涓鍘嬬緝鐨勬枃浠跺姞涓婃敞閲娿?nbsp;
-d 浠庡帇緙╂枃浠跺唴鍒犻櫎鎸囧畾鐨勬枃浠躲?nbsp;
-D 鍘嬬緝鏂囦歡鍐呬笉寤虹珛鐩綍鍚嶇О銆?nbsp;
-f 姝ゅ弬鏁扮殑鏁堟灉鍜屾寚瀹?-u"鍙傛暟綾諱技錛屼絾涓嶄粎鏇存柊鏃㈡湁鏂囦歡錛屽鏋滄煇浜涙枃浠跺師鏈笉瀛樺湪浜庡帇緙╂枃浠跺唴錛屼嬌鐢ㄦ湰鍙傛暟浼氫竴騫跺皢鍏跺姞鍏ュ帇緙╂枃浠朵腑銆?nbsp;
-F 灝濊瘯淇宸叉崯鍧忕殑鍘嬬緝鏂囦歡銆?nbsp;
-g 灝嗘枃浠跺帇緙╁悗闄勫姞鍦ㄦ棦鏈夌殑鍘嬬緝鏂囦歡涔嬪悗錛岃岄潪鍙﹁寤虹珛鏂扮殑鍘嬬緝鏂囦歡銆?nbsp;
-h 鍦ㄧ嚎甯姪銆?nbsp;
-i<鑼冩湰鏍峰紡> 鍙帇緙╃鍚堟潯浠剁殑鏂囦歡銆?nbsp;
-j 鍙繚瀛樻枃浠跺悕縐板強鍏跺唴瀹癸紝鑰屼笉瀛樻斁浠諱綍鐩綍鍚嶇О銆?nbsp;
-J 鍒犻櫎鍘嬬緝鏂囦歡鍓嶉潰涓嶅繀瑕佺殑鏁版嵁銆?nbsp;
-k 浣跨敤MS-DOS鍏煎鏍煎紡鐨勬枃浠跺悕縐般?nbsp;
-l 鍘嬬緝鏂囦歡鏃訛紝鎶奓F瀛楃緗崲鎴怢F+CR瀛楃銆?nbsp;
-ll 鍘嬬緝鏂囦歡鏃訛紝鎶奓F+CR瀛楃緗崲鎴怢F瀛楃銆?nbsp;
-L 鏄劇ず鐗堟潈淇℃伅銆?nbsp;
-m 灝嗘枃浠跺帇緙╁茍鍔犲叆鍘嬬緝鏂囦歡鍚庯紝鍒犻櫎鍘熷鏂囦歡錛屽嵆鎶婃枃浠剁Щ鍒板帇緙╂枃浠朵腑銆?nbsp;
-n<瀛楀熬瀛楃涓?gt; 涓嶅帇緙╁叿鏈夌壒瀹氬瓧灝懼瓧絎︿覆鐨勬枃浠躲?nbsp;
-o 浠ュ帇緙╂枃浠跺唴鎷ユ湁鏈鏂版洿鏀規椂闂寸殑鏂囦歡涓哄噯錛屽皢鍘嬬緝鏂囦歡鐨勬洿鏀規椂闂磋鎴愬拰璇ユ枃浠剁浉鍚屻?nbsp;
-q 涓嶆樉紺烘寚浠ゆ墽琛岃繃紼嬨?nbsp;
-r 閫掑綊澶勭悊錛屽皢鎸囧畾鐩綍涓嬬殑鎵鏈夋枃浠跺拰瀛愮洰褰曚竴騫跺鐞嗐?nbsp;
-S 鍖呭惈緋葷粺鍜岄殣钘忔枃浠躲?nbsp;
-t<鏃ユ湡鏃墮棿> 鎶婂帇緙╂枃浠剁殑鏃ユ湡璁炬垚鎸囧畾鐨勬棩鏈熴?nbsp;
-T 媯鏌ュ浠芥枃浠跺唴鐨勬瘡涓枃浠舵槸鍚︽紜棤璇?nbsp;
-u 鏇存崲杈冩柊鐨勬枃浠跺埌鍘嬬緝鏂囦歡鍐呫?nbsp;
-v 鏄劇ず鎸囦護鎵ц榪囩▼鎴栨樉紺虹増鏈俊鎭?nbsp;
-V 淇濆瓨VMS鎿嶄綔緋葷粺鐨勬枃浠跺睘鎬с?nbsp;
-w 鍦ㄦ枃浠跺悕縐伴噷鍋囧鐗堟湰緙栧彿錛屾湰鍙傛暟浠呭湪VMS鎿嶄綔緋葷粺涓嬫湁鏁堛?nbsp;
-x<鑼冩湰鏍峰紡> 鍘嬬緝鏃舵帓闄ょ鍚堟潯浠剁殑鏂囦歡銆?nbsp;
-X 涓嶄繚瀛橀澶栫殑鏂囦歡灞炴с?nbsp;
-y 鐩存帴淇濆瓨絎﹀彿榪炴帴錛岃岄潪璇ヨ繛鎺ユ墍鎸囧悜鐨勬枃浠訛紝鏈弬鏁頒粎鍦║NIX涔嬬被鐨勭郴緇熶笅鏈夋晥銆?nbsp;
-z 鏇垮帇緙╂枃浠跺姞涓婃敞閲娿?nbsp;
-$ 淇濆瓨絎竴涓鍘嬬緝鏂囦歡鎵鍦ㄧ鐩樼殑鍗峰唽鍚嶇О銆?nbsp;
-<鍘嬬緝鏁堢巼> 鍘嬬緝鏁堢巼鏄竴涓粙浜?-9鐨勬暟鍊箋?nbsp;
rar鏂囦歡錛?nbsp;
Rar 鐢ㄦ硶: rar 錛滃懡浠わ紴 -錛滈夐」1錛?....-錛滈夐」N錛?錛滄搷浣滄枃妗o紴 錛滄枃浠?..錛?錛淍鏂囦歡鍒楄〃...錛?錛滆В鍘嬭礬寰勶紴 h/](J k!P x l"w:G v K q7i6v
銆銆閫氬父rar鍛戒護鐢變竴涓富鍛戒護鍔犺嫢騫查夐」錛堝彲閫夛級鏋勬垚錛屾搷浣滄枃妗d負鎿嶄綔鏂藉姞鐨?rar鏂囦歡瀵硅薄錛屾枃浠舵垨鏂囦歡鍒楄〃涓哄鎿嶄綔鏂囨。瀹炵幇淇グ鐨勫叿浣撴枃浠舵垨鐩綍錛堝彲閫夛級銆?nbsp;
銆銆Y0`-o r#V r n ~"p9f5N rar甯哥敤鍛戒護涓昏鏈?
銆銆1) a 娣誨姞鏂囦歡鍒版搷浣滄枃妗?涓句緥rar a test.rar file1.txt
銆銆鑻est.rar鏂囦歡涓嶅瓨鍦紝鍒欐墦鍖協ile1.txt鏂囦歡鎴恡est.rar rar a test.rar file2.txt 鑻est.rar鏂囦歡宸茬粡瀛樺湪錛屽垯娣誨姞file2.txt鏂囦歡鍒皌est.rar涓?榪欐牱 test.rar涓氨鏈変袱涓枃浠朵簡錛夋敞錛屽鏋滄搷浣滄枃妗d腑宸叉湁鏌愭枃浠剁殑涓浠芥嫹璐濓紝鍒檃鍛戒護鏇存柊璇ユ枃浠?鍙︼紝瀵圭洰褰曚篃鍙互榪涜鎿嶄綔 eg. rar a test.rar dir1 銆?nbsp;
銆銆2) e test.rar 娉紝鐢╡瑙e帇鐨勮瘽錛屼笉浠呭師鏉ョ殑file1.txt鍜宖ile2.txt琚В鍘嬪埌褰撳墠鐩綍錛屽氨榪瀌ir1閲岄潰鐨勬墍鏈夋枃浠朵篃琚В鍘嬪埌褰撳墠鐩綍涓嬶紝涓嶈兘淇濇寔鍘嬬緝鍓嶇殑鐩綍緇撴瀯錛屽鏋滄兂淇濇寔鍘嬬緝鍓嶇殑鐩綍緇撴瀯錛岀敤x瑙e帇銆?nbsp;
銆銆3) c 瀵規搷浣滄枃妗f坊鍔犺鏄庢敞閲?eg. rar c test.rar
銆銆錛堜細鍑虹幇Reading comment from stdin瀛楁牱錛岀劧鍚庤緭鍏ヤ竴琛屾垨澶氳娉ㄩ噴錛屼互ctrl+d緇撴潫錛夈?nbsp;
銆銆4) cf 娣誨姞鏂囦歡娉ㄩ噴錛岀被浼間笂闈㈢殑c錛屼笉榪囪繖涓槸瀵瑰帇緙╂枃妗d腑姣忎釜鏂囦歡榪涜娉ㄩ噴 cw 灝嗘枃妗f敞閲婂啓鍏ユ枃浠?eg. rar cw test.rar comment.txt銆?nbsp;
銆銆5) d 浠庢枃妗d腑鍒犻櫎鏂囦歡 eg. rar d test.rar file1.txt e
銆銆灝嗘枃浠惰В鍘嬪埌褰撳墠鐩綍 eg. rar銆?nbsp;
銆銆6) e test.rar 娉紝鐢╡瑙e帇鐨勮瘽錛屼笉浠呭師鏉ョ殑file1.txt鍜宖ile2.txt琚В鍘嬪埌褰撳墠鐩綍錛屽氨榪瀌ir1閲岄潰鐨勬墍鏈夋枃浠朵篃琚В鍘嬪埌褰撳墠鐩綍涓嬶紝涓嶈兘淇濇寔鍘嬬緝鍓嶇殑鐩綍緇撴瀯錛屽鏋滄兂淇濇寔鍘嬬緝鍓嶇殑鐩綍緇撴瀯錛岀敤x瑙e帇銆?nbsp;
銆銆7) r 淇鏂囨。 eg. rar r test.rar
銆銆褰搑ar鏂囦歡鏈夐棶棰樻椂錛屽彲浠ュ皾璇曠敤璇ュ懡浠よ繘琛屼慨澶嶏紙楝肩煡閬撴湁澶氬皯鐢級 銆?nbsp;
銆銆8) s 杞崲鏂囨。鎴愯嚜瑙e帇鏂囨。 eg. rar s test.rar
銆銆浼氱敓鎴愪竴涓猼est.sfx鐨勫彲鎵ц鏂囨。錛岃繍琛屽畠鐨勬晥鏋滃氨鐩稿綋浜巖ar x test.rar錛?閫傚悎浜庡悜娌℃湁rar鐨勭敤鎴蜂紶杈撴枃浠躲?nbsp;
銆銆9) t 媯嫻嬫枃妗?eg. rar t test.rar
銆銆媯嫻媡est.rar鐨勫畬鏁存с?nbsp;
銆銆10) k 閿佸畾鏂囨。 eg. rar k test.rar
銆銆閿佸畾鏂囨。鍚庯紝璇ユ枃妗e氨鏃犳硶榪涜浠諱綍鏇存柊鎿嶄綔浜嗐?nbsp;
.Z鏂囦歡錛?nbsp;
鍛戒護錛?compress
鏍煎紡錛?compress 閫夐」 鏂囦歡鍒楄〃
鍔熻兘錛?鐢↙empel-ziv鍘嬬緝鏂規硶鏉ュ帇緙╂枃浠舵垨鍘嬬緝鏍囧噯杈撳叆
閫夐」錛?-r 閫掑綊鎿嶄綔錛屽鏋滄寚瀹氱洰褰曞彉鍏冿紝鍒欏帇緙╄鐩綍鍙婂叾瀛愮洰褰曚腑鐨勬墍鏈夋枃浠躲?nbsp;
-c 灝嗗帇緙╂暟鎹繑鍥炴爣鍑嗚緭鍑猴紝鑰岀己鐪佹儏鍐典笅涓哄帇緙╂枃浠舵椂灝嗗帇緙╂暟鎹繑鍥炴枃浠躲?nbsp;
-v 鏄劇ず姣忎釜鏂囦歡澶圭殑鍘嬬緝鐧懼垎姣斻?nbsp;
瑙i噴錛?鍦ㄧ敤compress鍘嬬緝鏂囦歡鏃訛紝灝嗗湪鍘熸枃浠跺悕涔嬪悗鍔犱笂鎵╁睍鍚?Z銆傚鏋滀笉鎸囧畾鏂囦歡錛屽垯鍘嬬緝鏍囧噯杈撳叆錛屽叾緇撴灉榪斿洖鏍囧噯杈撳嚭銆?nbsp;
瀹炰緥錛?鐩殑錛氬帇緙?mnt/lgx/a1.doc鏂囦歡
鍛戒護錛氾純compress /mnt/lgx/a1.doc
緇撴灉錛氬帇緙╁悗鐢熸垚a1.doc.Z鏂囦歡銆?nbsp;
鍛戒護錛?uncompress
鏍煎紡錛?uncompress 閫夐」 鏂囦歡鍒楄〃
鍔熻兘錛?瑙e帇緙╃敤compress 紼嬪簭鍘嬬緝榪囩殑鏂囦歡
閫夐」錛?-c 瀹冨皢鍘嬬緝鏁版嵁鍙戝線鏍囧噯杈撳嚭鑰屼笉鏄敼鍐欐棫鐨勫帇緙╂枃浠?nbsp;
瑙i噴錛?濡傛灉涓嶆寚瀹氭枃浠訛紝鍒欒В鍘嬬緝鏍囧噯杈撳叆銆傜己鐪?c鏃訛紝涓鴻В鍘嬬緝銆?nbsp;
瀹炰緥錛?鐩殑錛氳В鍘嬬緝/mnt/lgx/a1.doc.Z
鍛戒護錛? uncompress /mnt/lgx/a1.doc.Z
.gz鏂囦歡錛?nbsp;
鍛戒護錛?gzip
鏍煎紡錛?gzip 閫夐」 鏂囦歡鐩綍鍒楄〃
鍔熻兘錛?鐢↙empel-ziv緙栫爜鍘嬬緝鏂囦歡
閫夐」錛?-c 鍘嬬緝緇撴灉鍐欏叆鏍囧噯杈撳嚭錛屽師鏂囦歡淇濇寔涓嶅彉銆傜己鐪佹椂gzip灝嗗師鏂囦歡鍘嬬緝涓?gz鏂囦歡錛屽茍鍒犻櫎鍘熸枃浠躲?nbsp;
-v 杈撳嚭澶勭悊淇℃伅銆?nbsp;
-d 瑙e帇緙╂寚瀹氭枃浠躲?nbsp;
-t 嫻嬭瘯鍘嬬緝鏂囦歡鐨勫畬鏁存с?nbsp;
瑙i噴錛?鍊煎緱涓鎻愮殑鏄紝gzip姣攃ompress鍘嬬緝鏇村姞鏈夋晥銆?nbsp;
瀹炰緥錛?鐩殑錛氬帇緙?mnt/lgx/a1.doc
鍛戒護錛氾純gzip -v /mnt/lgx/a1.doc
緇撴灉錛氫駭鐢焌1.doc.gz鐨勫帇緙╂枃浠?nbsp;
鍛戒護錛?gunzip
鏍煎紡錛?gunzip 閫夐」 鏂囦歡鍒楄〃
鍔熻兘錛?瑙e帇緙╃敤gzip鍛戒護錛堜互鍙奵ompress鍜寊ip鍛戒護錛夊帇緙╄繃鐨勬枃浠?nbsp;
閫夐」錛?-c 灝嗚緭鍑哄啓鍏ユ爣鍑嗚緭鍑猴紝鍘熸枃浠朵繚鎸佷笉鍙樸傜己鐪佹椂錛実unzip灝嗗帇緙╂枃浠跺彉鎴愯В鍘嬬緝鏂囦歡銆?nbsp;
-l 鍒楀嚭鍘嬬緝鏂囦歡涓殑鏂囦歡鑰屼笉瑙e帇緙┿?nbsp;
-r 閫掑綊瑙e帇緙╋紝娣卞叆鐩綍緇撴瀯涓紝瑙e帇緙╁懡浠よ鍙樺厓鎵鎸囧畾鐩綍涓殑鎵鏈夊瓙鐩綍鍐呯殑鏂囦歡銆?nbsp;
瀹炰緥錛?鐩殑錛氳В鍘嬬緝/mnt/lgx/a1.doc.gz
鍛戒護錛氾純gunzip /mnt/lgx/a1.doc.gz
.tar鏂囦歡錛?nbsp;
鍛戒護錛?tar
鏍煎紡錛?tar 閫夐」 鏂囦歡鐩綍鍒楄〃
鍔熻兘錛?瀵規枃浠剁洰褰曡繘琛屾墦鍖呭浠?nbsp;
閫夐」錛?-c 寤虹珛鏂扮殑褰掓。鏂囦歡
-r 鍚戝綊妗f枃浠舵湯灝捐拷鍔犳枃浠?nbsp;
-x 浠庡綊妗f枃浠朵腑瑙e嚭鏂囦歡
-O 灝嗘枃浠惰В寮鍒版爣鍑嗚緭鍑?nbsp;
-v 澶勭悊榪囩▼涓緭鍑虹浉鍏充俊鎭?nbsp;
-f 瀵規櫘閫氭枃浠舵搷浣?nbsp;
-z 璋冪敤gzip鏉ュ帇緙╁綊妗f枃浠訛紝涓?x鑱旂敤鏃惰皟鐢╣zip瀹屾垚瑙e帇緙?nbsp;
-Z 璋冪敤compress鏉ュ帇緙╁綊妗f枃浠訛紝涓?x鑱旂敤鏃惰皟鐢╟ompress瀹屾垚瑙e帇緙?nbsp;
瀹炰緥1錛?鐩殑錛氱敤tar鎵撳寘涓涓洰褰曚笅鐨勬枃浠?nbsp;
鍛戒護錛氾純tar -cvf /mnt/lgx/a1.doc
緇撴灉錛氫駭鐢熶竴涓互.tar涓烘墿灞曞悕鐨勬墦鍖呮枃浠?nbsp;
瀹炰緥2錛?鐩殑錛氱敤tar瑙e紑鎵撳寘鏂囦歡
鍛戒護錛氾純tar -xvf /mnt/lgx/a1.doc.tar
闄勫姞璇存槑錛氬湪閫氬父鎯呭喌涓嬶紝tar鎵撳寘涓巊zip錛堝帇緙╋級緇忓父鑱斿悎浣跨敤錛屾晥鏋滄洿濂姐傛柟娉曟槸錛?nbsp;
棣栧厛鐢╰ar鎵撳寘錛屽錛氾純tar -cvf /mnt/lgx/a1.doc 錛堜駭鐢焌1.doc.tar鏂囦歡錛?nbsp;
鐒跺悗鐢╣zip鍘嬬緝a1.doc.tar鏂囦歡錛屽錛氾純gzip /mnt/lgx/a1.doc.tar 錛堜駭鐢焌1.doc.tar.gz鏂囦歡錛?nbsp;
瀹炰緥3錛?鐩殑錛氳В鍘媋1.doc.tar.gz鏂囦歡
鏂規硶1錛?nbsp;
錛僩zip -dc /mnt/lgx/a1.doc.tar.gz 錛堜駭鐢焌1.doc.tar鏂囦歡錛?nbsp;
錛僼ar -xvf /mnt/lgx/a1.doc.tar 錛堜駭鐢焌1.doc鏂囦歡錛?nbsp;
榪欎袱嬈″懡浠や篃鍙嬌鐢ㄧ閬撳姛鑳斤紝鎶婁袱涓懡浠ゅ悎浜屼負涓錛?nbsp;
錛僩zip -dc /mnt/lgx/a1.doc.tar.gz | tar -xvf
鏂規硶2錛氫嬌鐢╰ar鎻愪緵鐨勮嚜鍔ㄨ皟鐢╣zip瑙e帇緙╁姛鑳?nbsp;
錛僼ar -xzvf /mnt/lgx/a1.doc.tar.gz
緇忚繃tar鎵撳寘鍚庯紝涔熷彲鐢╟ompress鍛戒護鍘嬬緝錛堟敞錛歡zip姣攃ompress鍘嬬緝鏇村姞鏈夋晥錛夛紝浜х敓涓涓互.tar.Z鐨勬枃浠訛紝鍦ㄨВ鍖呮椂錛屽彲鍏堢敤 “uncompress 鏂囦歡鍚?#8221;鏍煎紡瑙e帇錛岀劧鍚庣敤“tar -xvf 鏂囦歡鍚?#8221;瑙e寘銆備篃鍙洿鎺ヨ皟鐢?#8220;tar -Zxvf 鏂囦歡鍚?#8221;瑙e寘銆?br />
杞嚜:http://bjxuguoli.iteye.com/blog/761964
榪愯鍛戒護
V:\AP\APBO\KU\USERS\weitaol\Desktop\TAP\Course\System Architecture\SOAP & REST A
ssessment\mybank>xjc -b .\src\binding.xml -d .\src\ -p src.java.mybank.soap.generated .\src\src\xml\SOAPRequestResponse.xsd
鍘誨嚭鏌愪竴瀛楃涓茬殑鐨勪竴涓崟璇嶏紝絀烘牸涓哄垎闅旂
select substr(title,1,instr(title,' ')-1) from titles
灝嗗瓧絎︿覆鐨勪竴涓┖鏍兼浛鎹負'--hello--'
select substr(title,1,locate(' ',title)-1) || '--hello--' || substr(title,locate(' ',title)+1) from titles
db2鐢熸垚闅忔満鏁?br />select case when price is null then INT(rand()*100) else price end from titles
涓ゆ棩鏈熺浉宸灝戞湀錛?4浠h〃鏈堛傚弬鏁板彲浠ユ洿鏀規眰鍑哄懆錛屽皬鏃剁瓑絳夈?br />select TIMESTAMPDIFF(64,char(TIMESTAMP(CURRENT DATE) - TIMESTAMP(pubdate)) )from titles
鏈夊叧db2鏃ユ湡鎿嶄綔鍙弬鑰冩鍗氬銆?br />http://www.cnblogs.com/wanghonghu/archive/2012/05/25/2518604.html
寤虹珛鏁版嵁琛紝鏈塯enerated always鍒?br />create table t1
(
c1 char(30),
c2 double,
c3 int not null generated always as identity
(start with 100, increment by 5)
)
絎竴嬈℃洿鏂扮敤insert into t1(c1,c2,c3) values('123',34,default)
浠ュ悗鐢?insert into t1(c1,c2) values('hi',45)
濡傛灉鏄痝enerated by default
create table t1
(
c1 char(30),
c2 double,
c3 int not null generated by default as identity
(start with 100, increment by 5)
)
濡傛灉鎻掑叆鏃跺彧鏈変袱涓弬鏁幫紝灝辨寜榛樿鐨勬潵
濡傛灉涓変釜鍙傛暟錛屽氨鏄彃鍏ョ殑閭d釜鏁?br />榛樿鐢熸垚鐨勭涓変釜鏁板彲浠ヤ慨鏀癸紝緋葷粺浼氭湁璁板綍錛屽嵆浣夸慨鏀逛簡涔熶細浠庝笂涓嬈$殑榛樿浣嶇疆寮濮嬪彔鍔犮備笉浼氬啀鍥炲埌100.
1銆佸畾闀挎暟緇勶細闀垮害涓嶅彉鐨勬暟緇凙rray錛屽錛氬0鏄庝竴涓暱搴︿負10鐨勬暣褰㈡暟緇勶紝val arr = Array[Int](10)錛涘0鏄庡茍鍒濆鍖栦竴涓瓧絎︿覆鏁扮粍錛?nbsp;val arrStr = Array(“wo”,”cha”,”yo”)銆傝闂暟緇勬柟寮?璁塊棶arrStr絎竴涓厓绱狅紝arrStr(1)鍗沖彲
2銆佸彉闀挎暟緇勶紙鍗蟲暟緇勭紦鍐詫級錛歫ava涓湁ArrayList鍜宻cala涓殑ArrayBuffer絳夋晥錛涗絾鏄疉rrayBuffer鏇村姞寮哄ぇ錛岄氳繃涓嬮潰鐨勪簨鍒楁潵鐔熸倝ArrayBuffer錛?br />import collection.mutable.ArrayBuffer
val arrbuff1 = ArrayBuffer[Int]()
val arrBuff2 = ArrayBuffer(1,3,4,-1,-4)
arrbuff1 += 23 //鐢?=鍦ㄥ熬绔坊鍔犲厓绱?/span>
arrbuff1 += (2,3,4,32) //鍚屾椂鍦ㄥ熬绔坊鍔犲涓厓绱?/span>
arrbuff1 ++= arrBuff2 //鍙互鐢?nbsp;++=鎿嶄綔絎﹁拷鍔犱換浣曢泦鍚?/span>
arrbuff1 ++= Array(2,43,88,66)
arrbuff1.trimEnd(2) //縐婚櫎鏈鍚庣殑2涓厓绱?/span>
arrbuff1.remove(2) //縐婚櫎arr(2+1)涓厓绱?/span>
arrbuff1.remove(2,4) //浠庣涓変釜鍏冪礌寮濮嬬Щ闄?涓厓绱?/span>
val arr = arrbuff1.toArray //灝嗘暟緇勭紦鍐茶漿鎹負Array
val arrbuff2 = arr.toBuffer //灝咥rray杞崲涓烘暟緇勭紦鍐?/span>
3銆侀亶鍘嗘暟緇勫拰鏁扮粍緙撳啿錛氬湪java涓暟緇勫拰鏁扮粍鍒楄〃/鍚戦噺涓婅娉曟湁浜涗笉鍚屻俿cala鍒欐洿鍔犵粺涓錛岄氬父鎯呭喌錛屾垜浠彲浠ョ敤鐩稿悓鐨勪唬鐮佸鐞嗚繖涓ょ鏁版嵁緇撴瀯錛?span style="color: #0000FF; ">for(…) yield 寰幆鍒涘緩涓涓被鍨嬪拰鍘熼泦鍚堢被鍨嬬浉鍚岀殑鏂伴泦鍚堛俧or寰幆涓繕鍙互甯﹀畧鍗細鍦╢or涓敤if鏉ュ疄鐜般?br /> for(i <- 0 until arrbuff1.length) yield arrbuff1(i) * 2 //灝嗗緱鍒癆rrayBuffer(2,6,4,-2,-4)
for(i <- 0 until (arrbuff1.length,2)) yield arrbuff1(i) * 2 //灝嗗緱鍒癆rrayBuffer(12,-4)
for(elem <-0 arrbuff1) print(elem) //濡傛灉涓嶉渶瑕佷嬌鐢ㄤ笅鏍囷紝鐢ㄨ繖縐嶆柟寮忔渶綆鍗曚簡
for(i <- arrbuff1 if arrbuff1 > 0) print i //鎵撳嵃鍑篴rrbuff1涓負鏁存暟鐨勫?/span>
arrbuff1.filter( _ > 0).map{ 2 * _} //鐢熸垚arrbuff1涓殑姝f暟鐨勪袱鍊嶇殑鏂伴泦鍚?/span>
arrbuff1.filter {_ > 0} map {2 * _} //鍙︿竴縐嶅啓娉?/span>
4銆佸父鐢ㄧ畻娉曪細scala鏈夊緢澶氫究鎹峰唴寤哄嚱鏁幫紝濡?br /> arrbuff1.sum //瀵筧rrbuff1鍏冪礌姹傚拰
Array("asd","sdf","ss").max //姹傛渶澶у厓绱?/span>
arrbuff1.sorted(_ < _) //灝哸rrbuff1鍏冪礌浠庡皬鍒板ぇ鎺掑簭
arrbuff1.sorted(_ > _) //浠庡ぇ鍒板皬鎺掑簭
util.Sorting.quickSort(Array) //閽堝鏁扮粍鎺掑簭錛屽崟涓嶈兘瀵規暟緇勭紦鍐叉帓搴?/span>
val arr = Array(1,23,4,2,45)
arr.mkString(",") //鎸囧畾鍒嗗壊絎?/span>
arr.mkString("(",",",")") //鎸囧畾鍓嶇紑銆佸垎闅旂銆佸悗緙
鏇村鍑芥暟鍙傝Scaladoc
5銆佸緇存暟緇勶細
val matrix = Array.ofDim[Int](5,4) //涓夎鍥涘垪鐨勪簩緇存暟緇?/span>
matrix(2)(3) //璁塊棶絎簩琛屻佺涓変釜鍏冪礌
6銆乻cala鏁扮粍鍜宩ava浜掓搷浣滐細鐢變簬scala鏁扮粍鏄敤java鏁扮粍瀹炵幇鐨勶紝鎵浠ュ彲浠ュ湪java鍜宻cala涔嬮棿鏉ュ洖浼犻掞紝寮曞叆scala.collectin.JavaConversion 錛屽彲浠ュ湪浠g爜涓嬌鐢╯cala緙撳啿錛屽湪璋冪敤java鏂規硶鏃訛紝榪欎簺瀵硅薄浼氳鑷姩鍖呰鎴恓ava鍒楄〃銆傚弽榪囨潵璁詫紝寮曞叆scala.collection.asScalaBuffer鏃訛紝褰搄ava鏂規硶榪斿洖java.util.List鏃訛紝鎴戜滑鍙互璁╁畠杞崲鎴愪竴涓狟uffer
杞嚜錛?span style="font-size: 14px;">http://www.kankanews.com/ICkengine/archives/128572.shtml
using namespace std;
template <class OutputIterator, class Iterator, class predicate>
void copy(OutputIterator o, Iterator f, Iterator l, predicate p)
{
while(f!=l)
{
if(p(*f))
{
*o = *f;
++f;
++o;
}
else
{
++f;
}
}
}
template <class Predicate>
class negate
{
Predicate p;
public :
typedef typename Predicate::value_type value_type;
negate(const Predicate &pred):p(pred){}
bool operator()(const value_type v)const
{
return !p(v);
}
};
template<class Number>
struct smallerThanX
{
typedef Number value_type;
int x;
smallerThanX(int x):x(x)
{
}
bool operator()(const Number& n) const
{
return n< this->x;
}
};
template <class Predicate>
inline negate<Predicate > NOT (const Predicate &p)
{
return negate<Predicate>(p);
}
int main()
{
int a[] = {1,2,3,4,5,6,7,8};
int *b = new int [10];
copy(b,a,a+8,NOT(smallerThanX<int>(5)));
return 0;
}
榪欑鏂瑰紡瀹炲湪鏄湁鐐歸毦鐪嬪晩銆傘傘?浠g爜涓嶄粩緇嗙湅榪樼湅涓嶆噦錛屼笉鐭ラ亾涓轟粈涔堣榪欐牱鍐欏憿銆傘傘?/div>
using System.Collections.Generic;
using System.Linq;
using System.Text;
class MagicDictionary
{
private Dictionary<String, String> dic;
public MagicDictionary()
{
dic = new Dictionary<string, string>();
}
void Add(String key, String value)
{
if (dic.ContainsKey(key)&&dic[key]==value)
throw new Exception("KeyValuePair already exsits");
dic.Add(key, value);
}
void Remove(String key)
{
if (!dic.ContainsKey(key))
throw new Exception("it doesn't exsit");
dic.Remove(key);
}
void Set(String key, String value)
{
if (dic.ContainsKey(key))
dic[key] = value;
else
dic.Add(key, value);
}
String Get(String key)
{
return dic[key];
}
void PrintAll()
{
foreach (KeyValuePair<String, String> i in dic)
{
Console.WriteLine(i.Key + " " + i.Value);
}
}
String TryGetValue(String key)
{
if (dic.ContainsKey(key))
return dic[key];
else
return "";
}
public String this[String key]
{
set
{
dic[key] = value;
}
get
{
return dic[key];
}
}
public static void Main()
{
try
{
MagicDictionary t = new MagicDictionary();
t.Add("Hi", "Hello");
// t.Add("Hi", "Hello");
t.Add("What", "ever");
t.Add("Pretty", "Girl");
t.Add("Apple", "Google");
t.PrintAll();
t.Remove("Pretty");
t.Remove("#$@#*$");
t.Set("What", "Whatever");
if (t.TryGetValue("Hi") != "")
Console.WriteLine("OK");
else
Console.WriteLine("Bu OK");
if (t.TryGetValue("Appoe") != "")
Console.WriteLine("OK");
else
Console.WriteLine("Bu OK");
Console.WriteLine(t.Get("Apple"));
t["Apple"] = "BIG GOOGLE";
t.PrintAll();
}
catch (System.Exception ex)
{
Console.WriteLine(ex.Message);
Console.WriteLine(ex.Message);
}
}
}
using System.Collections.Generic;
using System.Linq;
using System.Text;
class iTimer:IDisposable
{
String mes;
DateTime s;
public iTimer(String mes)
{
this.mes = mes;
s = DateTime.Now;
}
public void Dispose()
{
DateTime t = DateTime.Now;
TimeSpan ts = t - s;
Console.Error.WriteLine("spent time(in Milliseconds):");
Console.Error.WriteLine(ts.TotalMilliseconds);
}
public static void Main()
{
using (iTimer t = new iTimer("game"))
{
int ans = 10;
int input = Int32.Parse(Console.ReadLine());
while(ans!=input)
{
Console.WriteLine("please try again.");
input = Int32.Parse(Console.ReadLine());
}
Console.WriteLine("Correct!");
}
Console.Error.WriteLine("the program is terminated");
}
}