CHJBootCamp2018/DAY1b - OGI-Wiki

CHJBootCamp2018

SQL(0) 賞ɛ

VPN / SSMS本永氾奴件弘

优邰卅手及

VPN濤糧失市它件玄
- 陸侳樊迕WiFi﹋kokken01引凶反eduroam﹌匹生永玄伐□弁濤糧詨﹜澎賜卞蝨中VPN濤糧
Microsoft SQL Server Management Studio﹋SSMS﹌及奶件旦玄□伙
- https://docs.microsoft.com/ja-jp/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-2017
- 犯□正矛□旦﹋SQL Server﹌毛厙迕允月讓寧棕雁
犯□正矛□旦失市它件玄
- 輔寰腺蜃及心

SQL(1) SELECT妐及湘呿

楮溢犯□正矛□旦午SQL

湃繡及犯□正矛□旦毛銀丹仇午分仃毛濩抸仄引允

楮溢犯□正矛□旦﹋伉伊□扑亦瓜伙犯□正矛□旦“RDB﹌

丐日斗月犯□正毛刓及賺心寧歹六匹刓蜇允月
犯□正毛潸曰請允及互簧中﹜犯□正互莽木卅中﹜⑺凜卞質咥匹五月

(輔嗶)犯□正矛□旦湘謄醱及湘謄
- 伉伊□扑亦瓜伙犯□正矛□旦及湘呿 https://thinkit.co.jp/article/1042/1
(輔嗶)SQL仇木分仃襞勻化中木壬釐暹屺〞

迕賄

犯□正矛□旦棟咥扑旦氾丞﹋DBMS﹌
- SQL Server, MySQL, PostgreSQL, Oracle, etc.
犯□正矛□旦扔□田□
犯□正矛□旦奶件旦正件旦

刓﹋氾□皮伙﹌
- 昫﹋市仿丞﹌“氾□皮伙及澀煌曉瑁引勻化中月﹋戶勻凶卞餵支仄凶曰仄卅中﹌
- 伊戊□玉﹋墊﹌“馨笛今木升氏升氏餵尹月仇午互聶中

氾□皮伙

	昫抩1	昫抩2	昫抩3	＿
伊戊□玉1	襖	襖	襖
伊戊□玉2	襖	襖	襖
“

弁巨伉﹋杽中寧歹六﹌“犯□正矛□旦卞覆允月今引介引卅質咥戊穴件玉

牖僅鳳恔/刓及懇筋祭

SQL午反

犯□正矛□旦杽中寧歹六蛻賄

SQL及湘呿 https://thinkit.co.jp/article/1046/1

SQL及踏摯卅升﹋Microsoft SQL Server 及樺寧﹌

戊穴件玉午筏寞反蟈化�剩
戊穴件玉反釐妐儂凝妐儂及嗉帎反﹋葆禮午仄化﹌卅中
- 氾□皮伙抩支昫抩羈反釐妐儂凝妐儂及嗉帎丐曰﹋DB及澀爛卞方月﹌
戊穴件玉及濠木杴及旦矢□旦支正皮反芴煌卞じ勻化中化手﹜荼墊毛じ木化手中中
妐儂昫毛襖午仄化隙爛允月午五反'襖'及方丹卞扑件弘伙弁左□氾□扑亦件匹區戈
- Unicode妐儂午仄化抸憎允月午五反N'襖'午允月
- 襖午仄化'毛じ木凶中午五反''午仄化巨旦弗□皿
--匹戊丟件玄失它玄﹋撢墊覆擂陸卞卅月﹌
- 墊及籣醱井日匹手第
/*﹛℅﹛*/ 匹呁醒墊戊丟件玄失它玄

CHJ犯□正矛□旦及厙迕

厙迕允月犯□正矛□旦及薊鎗
```
use chunagon_chj
```

氾□皮伙
- 羶簽匏
- 贏簽匏
- 踏鳴樹扷

SELECT妐

午曰丐尹內仇木分仃〞創尹月

SELECT“犯□正矛□旦及刓井日犯□正毛薊鎗仄化請恘允月戊穴件玉
- SELECT妐卞方月請恘手刓溥摯

SELECT 昫抩,昫抩2... FROM 氾□皮伙
- 羶簽匏刓井日賄袓豳,賄袓豳厶心及昫毛﹋蟈朿﹌請恘
```
SELECT 賄袓豳,賄袓豳厶心 FROM 羶簽匏
```

◢弁巨伉撢墊及潸曰壅仄 Alt+Break

羶簽匏刓井日賄袓豳,賄袓豳厶心及昫毛瘉賡及100墊請恘
```
SELECT TOP 100 賄袓豳,賄袓豳厶心 FROM 羶簽匏
```

WHERE橢瘀嗥

SELECT 昫抩,昫抩2... FROM 氾□皮伙 WHERE 昫抩='hoge'
- 羶簽匏刓井日圴髦互濤糧髦匹丐月手及及賄袓豳,賄袓豳厶心及昫毛請恘
```
SELECT 賄袓豳,賄袓豳厶心 FROM 羶簽匏 WHERE 圴髦='濤糧髦'
```
- 橢瘀毛AND﹜OR匹呁醒隙爛匹五月
  - AND及杅互穸燮賜匏互嫖中
  - OR午AND毛賺心寧歹六月午五反()匹穸燮賜匏毛憎允

LIKE 梢遙閡午伐奶伙玉市□玉

"LIKE"反"="及方丹卅手及分互﹜伐奶伙玉市□玉毛殖戈敦蟈域譙匹卅中樺寧卞銀丹
伐奶伙玉市□玉*1
- %“エ啦及妐儂昫﹋妐儂卅仄匹手第﹌
- _“エ啦及域妐儂
- [abc]“市永戊〇及中內木井及妐儂﹋妐儂弁仿旦﹌
- [^abc]“市永戊〇及妐儂動陸﹋怀螂寧﹌
- [a-z]“妐儂戊□玉及＇區匹隙爛

羶簽匏刓井日圴髦互溥芢髦匹反元引月手及及賄袓豳,賄袓豳厶心及昫毛請恘
```
SELECT 賄袓豳,賄袓豳厶心 FROM 羶簽匏 WHERE 圴髦 LIKE '溥芢髦%'
```
羶簽匏刓井日圴髦互濤糧髦匹賄袓豳厶心互市墊匹銨引月手及及賄袓豳,賄袓豳厶心及昫毛請恘
```
SELECT 賄袓豳,賄袓豳厶心 FROM 羶簽匏 WHERE 圴髦 LIKE '溥芢髦%' AND 賄袓豳厶心 LIKE '[市-戊]%'
```

ORDER BY 嗥﹋岈屯贅尹﹌

ORDER BY 昫抩 (DESC)*2
- 羶簽匏刓井日圴髦互濤糧髦匹丐月手及及賄袓豳,賄袓豳厶心及昫毛賄袓豳厶心賜卞請恘
```
SELECT 賄袓豳,賄袓豳厶心 FROM 羶簽匏 WHERE 圴髦='濤糧髦' ORDER BY 賄袓豳厶心
```

◢ORDER BY嗥互卅中午犯□正矛□旦反贗癲卅賜⺀匹請恘允月〞
- 犯□正螂寧午仄化反中勾手⑺元分互﹜ORDER BY嗥互卅中午岈太賜反忡據今木卅中

OGISO.NET

瘉蕙及10瘀

2020-07-03

嶽檎2020/ざ呿賄ざ呿妐喀及凶戶及戊件疋亙□正

2020-06-11

嶽檎2020

2020-05-22

牖僅鳳恔/懇筋刓蜇

2020-04-23

牖僅鳳恔/妐儂戊□玉楮洘伉件弁

2020-01-17

嶽檎2019/ざ呿賄ざ呿妐喀及凶戶及戊件疋亙□正

2019-11-15

牖僅鳳恔/Himawari及懇筋刓蜇

2019-09-11

懦環2019螂醱

2019-09-02

2019-08-21

CHJBootCamp2019/DAY2-2

*1 ＞醱ダ蛻＝匹銀尹月手及午⑺元﹝懇筋刓蜇午反唱卅月
*2 DESC毛尥仃月午菅賜﹋嫦賜﹌卞請恘

Last-modified: 2018-08-22 (踹) 15:08:14