[B! SQL] maangieã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

maangie id:maangie

SQLã«é–¢ã™ã‚‹maangieã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (115)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

SQLãƒ•ã‚©ãƒ¼ãƒžãƒƒã‚¿ãƒ¼For WEB
ä»Šã¾ã§é€šã‚ŠSQLã®æ•´å½¢ã«ãŠå½¹ç«‹ã¦ãã ã•ã„ã€‚ ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ã—ãŸéš›ã¯æœ¬ãƒšãƒ¼ã‚¸ã§ãŠçŸ¥ã‚‰ã›ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ 2021/3/21è¿½è¨˜ ãƒ»==ãŒ1ãƒˆãƒ¼ã‚¯ãƒ³ã«ãªã‚‹ã‚ˆã†ä¿®æ£ ãƒ»[table]![column]ãŒå´©ã‚Œãªã„ã‚ˆã†ä¿®æ£ ãƒ»cross join ãŒå´©ã‚Œãªã„ã‚ˆã†ä¿®æ£ 2019/7/1è¿½è¨˜ ãƒ»ã‚«ãƒ³ãƒžæ•´å½¢å‰ã®å ´åˆã«order byã¯group byã§æ¡ãžã‚ãˆãŒæœ‰åŠ¹ã«ãªã‚‰ãªã„ãƒã‚°ã‚’ä¿®æ£ ãƒ»ã‚«ãƒ³ãƒžæ•´å½¢å‰ã®å ´åˆã«ã€limit 1, 10ãŒ limit 1 , 10ã¨ãªã‚‹ãƒã‚°ã‚’ä¿®æ£ 2018/8/28è¿½è¨˜ ãƒ»ie11ã§localStorageãŒå‹•ä½œã—ãªã‹ã£ãŸãƒã‚°ã‚’ä¿®æ£ 2018/8/27è¿½è¨˜ ãƒ»localStorageã«æ•´å½¢æ›¸å¼ã‚’ä¿å˜ã™ã‚‹ã‚ˆã†å¯¾å¿œ 2018/8/4è¿½è¨˜ ãƒ»ã‚«ãƒ³ãƒžæ•´å½¢ãŒå‰ã®å ´åˆã€ã€Œæ¡ãžã‚ãˆã€ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã‚’è¿½åŠ ã‚³ã‚¢éƒ¨åˆ†ã«æ‰‹ã‚’å…¥ã‚ŒãŸãŸã‚ã€ãŠã‹ã—ãªå‹•ä½œã‚’ã—ãŸå ´åˆã¯ãŠçŸ¥ã‚‰ã›ãã ã•ã„ã€‚ 2018/5/1
maangie 2018/08/02
*

SQL
ãƒªãƒ³ã‚¯
Cloud IDE - AWS Cloud9 - AWS
maangie 2016/04/02
*

SQL

Webã‚µãƒ¼ãƒ“ã‚¹
ãƒªãƒ³ã‚¯
MySQL 5.7ã®ç½ ãŒã‚ãªãŸã‚’ç‹™ã£ã¦ã„ã‚‹
31. ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚¹ãƒ¬ãƒ¼ãƒ–ã«æ³¨æ„ (FIXED by 5.7.9) REPLICATION SLAVEæ¨©é™ã® *ä»–ã«* SELECT ON performanceÌ²schema.* ãŒå¿…è¦ mysql> show slave statusG *************************** 1. row *************************** .. Last_IO_Errno: 1142 Last_IO_Error: The slave I/O thread stops becaus e a fatal error is encountered when it try to get the value of SE RVER_ID variable from master. Error: SELECT command denied to use r 'replic
maangie 2015/08/23
ã‚ã¨ã§èªã‚€

*

SQL
ãƒªãƒ³ã‚¯
ã€Œé€²æ—ãƒ»ã©ã†ãƒ»ã§ã™ãƒ»ã‹ã€ã‚’ãƒ©ãƒ³ãƒ€ãƒ ã«è¡¨ç¤ºã—ã€Œé€²æ—ã©ã†ã§ã™ã‹ã€ãŒå®Œæˆã—ãŸã‚‰ç…½ã£ã¦ãã‚‹SQL - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
maangie 2015/07/22
SQL

ã‚ã¨ã§èªã‚€
ãƒªãƒ³ã‚¯
MAMP TV
MAMP & MAMP PRO: See our latest tutorials on MAMP.tv
maangie 2015/05/29
SQL

php

YouTube

*
ãƒªãƒ³ã‚¯
ActiveRecordã‚’æ”¯ãˆã‚‹æŠ€è¡“ - Arelã¨ã¯ä½•è€…ãªã®ã‹? (å…¨5å›ž) ãã®1 | Webã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºï¼æ•™è‚²ã‚½ãƒªãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã®ã‚¿ã‚¤ãƒ ã‚¤ãƒ³ã‚¿ãƒ¼ãƒ¡ãƒ‡ã‚£ã‚¢
ActiveRecordã‚’æ”¯ãˆã‚‹æŠ€è¡“ â€“ Arelã¨ã¯ä½•è€…ãªã®ã‹? (å…¨5å›ž) ãã®1 #activerecord#Arel#rails#ruby#sql 2014å¹´ 05æœˆ 04æ—¥ nishio Rails3, ActiveRecordã‹ã‚‰ã¯ã€å†…éƒ¨ã§Arelã¨å‘¼ã°ã‚Œã‚‹SQLç”Ÿæˆç”¨ã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªãŒåˆ©ç”¨ã•ã‚Œã¦ã„ã¾ã™ã€‚ ä»Šå›žã€ArelãŒå†…éƒ¨ã§ã©ã®ã‚ˆã†ã«SQLã‚’ç”Ÿæˆã—ã¦ã„ã‚‹ã®ã‹ã‚’èª¿æŸ»ã—ãŸã®ã§ã€å½“ãƒ–ãƒã‚°ã«ã¦å…¬é–‹ã„ãŸã—ã¾ã™ã€‚ ã¡ã‚‡ã£ã¨é•·ããªã£ã¦ã—ã¾ã£ãŸãŸã‚ã€å…¨5å›žã«åˆ†å‰²ã—ã¾ã—ãŸã€‚ ä»¥ä¸‹ã€ç›®æ¬¡ã¨ãªã‚Šã¾ã™ã€‚ ActiveRecordã‚’æ”¯ãˆã‚‹æŠ€è¡“ â€“ Arelã¨ã¯ä½•è€…ãªã®ã‹?(å…¨5å›ž) ãã®1 [ã“ã®è¨˜äº‹]Arelã«ã¤ã„ã¦ãªãœèª¿æŸ»ã—ã‚ˆã†ã¨æ€ã£ãŸã®ã‹ã€ãã®èƒŒæ™¯ã¨ä»Šå¾Œåˆ©ç”¨ã™ã‚‹ã‚µãƒ³ãƒ—ãƒ«ã‚³ãƒ¼ãƒ‰ã‚’æŽ²è¼‰ã—ã¦ã„ã¾ã™ã€‚ActiveRecordã‚’æ”¯ãˆã‚‹æŠ€è¡“ â€“ Arelã¨ã¯ä½•è€…ãªã®ã‹?(å…¨5å›ž) ãã®2ã‚·ãƒ³ãƒ—ãƒ«ãªSQLæ–‡ã€ã€Œ
maangie 2015/05/14
ã‚ã¨ã§èªã‚€

SQL

Rails
ãƒªãƒ³ã‚¯
Time-based SQL Injectionã¯æ„å¤–ã«å®Ÿç”¨çš„ã ã£ãŸ
ã“ã®ã‚¨ãƒ³ãƒˆãƒªã§ã¯ã€Time-based SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã€ã™ãªã‚ã¡æ™‚é–“å·®ã‚’åˆ©ç”¨ã—ãŸSQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ãŒæ„å¤–ã«å®Ÿç”¨çš„ã ã£ãŸã¨ã„ã†å ±å‘Šã‚’ã—ã¾ã™ã€‚ãƒ‡ãƒ¢æ˜ åƒã‚ã‚Šã§ã™ã€‚ ã¯ã˜ã‚ã« Time-based SQL Injectionã¨ã„ã†æ”»æ’ƒãŒã‚ã‚Šã¾ã™ã€‚ã“ã‚Œã¯ãƒ–ãƒ©ã‚¤ãƒ³ãƒ‰SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã®ä¸€ç¨®ã§ã€ã‚ã‚‹æ¡ä»¶ã®å ´åˆã«ä¸€å®šæ™‚é–“ï¼ˆä¾‹ãˆã°5ç§’ï¼‰ã‚¹ãƒªãƒ¼ãƒ—ã—ã€ãã†ã§ãªã„æ™‚ã¨ã®å¿œç”æ™‚é–“ã®å·®ã§æƒ…å ±ã‚’ç›—ã‚‚ã†ã¨ã„ã†ã‚‚ã®ã§ã™ã€‚1å›žã®HTTPãƒªã‚¯ã‚¨ã‚¹ãƒˆã§1ãƒ“ãƒƒãƒˆã®æƒ…å ±ãŒå¾—ã‚‰ã‚Œã‚‹ã®ã§ã€ãã‚Œã‚’ç©ã¿é‡ãã‚‹ã“ã¨ã«ã‚ˆã£ã¦ã€ã„ãã‚‰ã§ã‚‚æƒ…å ±ã‚’ç›—ã‚ã‚‹ã¯ãšã§ã™â€¦ç†è«–çš„ã«ã¯ã€‚ ã—ã‹ã—ã€ã€Œç†å±ˆã¯ãã†ã§ã‚‚ã€æ™‚é–“ãŒæŽ›ã‹ã‚Šã™ãŽã‚‹ã‚ˆãã€ã¨ã„ã†ã“ã¨ã§ã€æ·±ãã¯è¿½ã£ã‹ã‘ã¦ã„ã¾ã›ã‚“ã§ã—ãŸã€‚SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã®æ¤œæŸ»ã«ã¯æœ‰åŠ¹ã§ã‚‚ã€æ‚ªç”¨ã¨ã—ã¦ã®å®Ÿç”¨æ€§ã¯ã‚ã¾ã‚Šãªã„ã¨è€ƒãˆã¦ã„ãŸã®ã§ã™ã€‚ ãã£ã‹ã‘ ãã£ã‹ã‘ã¯ã€ä»¥ä¸‹ã®Yahoo!çŸ¥æµè¢‹ã«ä»¥ä¸‹ã®è³ªå•ã§ã™ã€‚ SQL
maangie 2015/04/16
*

SQL

ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£
ãƒªãƒ³ã‚¯
DBã‚³ãƒžãƒ³ãƒ‰æ¨ªæ–æ¯”è¼ƒãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã‚’ä½œã‚Šã¾ã—ãŸ - clock-up-blog
æ¨ªæ–çš„ã«DBæ“ä½œã®é¡žä¼¼ã‚³ãƒžãƒ³ãƒ‰ã‚’æŽ¢ã™ãŸã‚ã®ã‚µã‚¤ãƒˆ ä¾‹ãˆã° MySQL ã‚’çŸ¥ã£ã¦ã„ã‚‹äººãŒ æ–°ã—ãä»–ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ä¾‹ãˆã° Oracle ã‚’å¦ç¿’ã™ã‚‹éš›ã« MySQL ã§ã„ã†ã¨ã“ã‚ã®ã‚¢ãƒ¬ã¯ Oracle ã§ã¯ã©ã†ã„ã†ã‚³ãƒžãƒ³ãƒ‰ãªã‚“ã ã‚ã† ã¨ã„ã†æ„Ÿã˜ã«æƒ…å ±ã‚’æŽ¢ã™å ´é¢ãŒå¤šãã‚ã‚Šã¾ã™ã€‚ ãã†ã„ã†é¡žã®æƒ…å ±ã‚’æŽ¢ã™ã¨ãã«å½¹ã«ç«‹ã¡ãã†ãªãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã‚µã‚¤ãƒˆã‚’ä½œã‚Šã¾ã—ãŸã€‚ xref.jp xref.jp - Database è¿½è¨˜: ã‚³ãƒ³ãƒ†ãƒ³ãƒ„å¢—ã‚„ã—ã¾ã—ãŸ yum, apt-get, rpm ç‰ã€…ã®æ¨ªæ–æ¯”è¼ƒãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ - clock-up-blog ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ GitHub ã«ä¸Šã’ã¦ã‚ã‚‹ã®ã§èˆˆå‘³ã‚ã‚‹äººã¯è¦‹ã¦ã¿ã‚‹ã¨è‰¯ã„ã§ã™ã€‚ kobake/xref.jp Â· GitHub PHP ã§æ›¸ã„ã¦ã¾ã™ã€‚ã™ã‚“ã”ã„æ±šã„ã§ã™ã€‚è¬™éœã˜ã‚ƒãªãã¦æœ¬å½“ã«ã€‚ ãƒ—ãƒ«ãƒªã‚¯æ“è¿Žã€‚ æ©Ÿèƒ½ ãƒžãƒˆãƒªã‚¯ã‚¹æ–¹å‘ã®åˆ‡æ›¿ æ¯”è¼ƒè¡¨ã®è¦‹å‡ºã—ã®å‘ãã£ã¦ã€ãã®çµ„ã¿
maangie 2015/01/02
SQL

*
ãƒªãƒ³ã‚¯
é–‹ç™ºè€…ã®ãŸã‚ã®SQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®å…¨ã¦
å‰æ›¸ã - ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ä½œæˆã¯ãªãœé–‹ç™ºè€…ã®ã‚¿ã‚¹ã‚¯ãªã®ã‹ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã® å†…éƒ¨æ§‹é€ - ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯ä½•ã«ä¼¼ã¦ã„ã‚‹ã‹ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ ãƒªãƒ¼ãƒ•ãƒŽãƒ¼ãƒ‰ - äºŒé‡é€£çµãƒªã‚¹ãƒˆ æ¤œç´¢ ãƒ„ãƒªãƒ¼(Bãƒ„ãƒªãƒ¼) - ãƒãƒ©ãƒ³ã‚¹æœ¨ é…ã„ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ ãƒ‘ãƒ¼ãƒˆI - ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’é…ãã™ã‚‹2ã¤ã®åŽŸå› where å¥ - æ¤œç´¢ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’æ”¹å–„ã™ã‚‹ãŸã‚ã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½œæˆ ç‰ä¾¡ æ¼”ç®—å - ä¸€è‡´ã™ã‚‹ã‚ãƒ¼ã®æ¤œç´¢ ãƒ—ãƒ©ã‚¤ãƒžãƒªã‚ãƒ¼ - ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ä½¿ã„æ–¹ã‚’ç¢ºèª è¤‡åˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ - è¤‡æ•°åˆ—ã«å¯¾ã™ã‚‹ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ é…ã„ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ ãƒ‘ãƒ¼ãƒˆII - å‰ã®å•é¡Œç‚¹ãŒå†ã³ é–¢æ•° - whereå¥ã® ä¸ã§ã®é–¢æ•° å¤§æ–‡å—ãƒ»å°æ–‡å—ã‚’åŒºåˆ¥ã™ã‚‹ æ¤œç´¢ - UPPERã¨ LOWER ãƒ¦ãƒ¼ã‚¶å®šç¾© é–¢æ•° - é–¢æ•°ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åˆ¶é™ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ä½œã‚ŠéŽãŽ - å†—é•·æ€§ã®æŽ’é™¤æ³• ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿åŒ– ã‚¯ã‚¨ãƒª - ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã¨ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®ãŸã‚ã« ç¯„å›² æ¤œ
maangie 2014/10/20
SQL

*
ãƒªãƒ³ã‚¯
ä»Šå¤œã“ãã‚ã‹ã‚‹å®‰å…¨ãªSQLã®å‘¼ã³å‡ºã—æ–¹ã€€ï½ž é«˜æœ¨æµ©å…‰æ°ã«èžã„ã¦ã¿ãŸ
ã€Œå®‰å…¨ãªSQLã®å‘¼ã³å‡ºã—æ–¹ã€ã¨ã„ã†SQLã®ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã«ç„¦ç‚¹ã‚’å½“ã¦ãŸãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆãŒã€2010å¹´3æœˆã«IPAï¼ˆç‹¬ç«‹è¡Œæ”¿æ³•äººæƒ…å ±å‡¦ç†æŽ¨é€²æ©Ÿæ§‹ï¼‰ã‹ã‚‰å…¬é–‹ã•ã‚ŒãŸã€‚ ã“ã‚Œã¯2006å¹´1æœˆã‹ã‚‰æä¾›ã•ã‚Œã¦ã„ã‚‹ã€Webã‚µã‚¤ãƒˆé–‹ç™ºè€…ã‚„é‹å–¶è€…å‘ã‘ã®ã‚»ã‚ãƒ¥ã‚¢Webã‚µã‚¤ãƒˆæ§‹ç¯‰ã®ãŸã‚ã®è³‡æ–™ã€Œå®‰å…¨ãªã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆã®ä½œã‚Šæ–¹ã€ã®åˆ¥å†Šã¨ã—ã¦æ›¸ã‹ã‚ŒãŸã‚‚ã®ã§ã‚ã‚‹ã€‚ã€Œå®‰å…¨ãªã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆã®ä½œã‚Šæ–¹ã€ãŒ92ãƒšãƒ¼ã‚¸ãªã®ã«å¯¾ã—ã¦ã€SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã«ã¤ã„ã¦ã ã‘ã§40ãƒšãƒ¼ã‚¸ã‚‚ã®åˆ†é‡ãŒã‚ã‚‹ã€‚ãªãœã“ã‚“ãªã«åˆ†åŽšã„ã®ã ã‚ã†ã‹ã€‚ ã“ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆä½œæˆã«å”åŠ›ã—ãŸã¨ã„ã†ã€ç‹¬ç«‹è¡Œæ”¿æ³•äººç”£æ¥æŠ€è¡“ç·åˆç ”ç©¶æ‰€ æƒ…å ±ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ç ”ç©¶ã‚»ãƒ³ã‚¿ãƒ¼ã®é«˜æœ¨æµ©å…‰æ°ã«ãŠè©±ã‚’ä¼ºã†ã“ã¨ãŒã§ããŸã€‚é«˜æœ¨æ°ã¯å€‹äººãƒ–ãƒã‚°ã€Œé«˜æœ¨æµ©å…‰ï¼ è‡ªå®…ã®æ—¥è¨˜ã€ã§ã€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£é–¢é€£ã®å•é¡Œã‚’è¿½æ±‚ã™ã‚‹è«–å®¢ã¨ã—ã¦ã‚‚çŸ¥ã‚‰ã‚Œã¦ã„ã‚‹ã€‚ç†è€…ã‚‚ä»¥å‰ã€ã“ã®é€£è¼‰ã®ã€Œä»Šå¤œã‚ã‹ã‚‹SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³å¯¾ç–ã€ã®å›žï¼ˆ2006å¹´11æœˆ
maangie 2014/10/18
SQL

ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£

*
ãƒªãƒ³ã‚¯
CMSã«æ½œã‚€SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³
CMSã«æ½œã‚€SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ï¼šè©¦ã—ã¦ã¿ãªã‘ã‚Šã‚ƒåˆ†ã‹ã‚‰ãªã„ï¼Ÿ å¤ã„Webã‚¢ãƒ—ãƒªã®è„†å¼±æ€§ï¼ˆ2ï¼‰ï¼ˆ1/2 ãƒšãƒ¼ã‚¸ï¼‰ ä»Šå›žã¯ã€å¤ã„CMSã«æ½œã‚€SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã®è„†å¼±æ€§ã‚’æ¤œè¨¼ã™ã‚‹ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ“ä½œã—ãŸçµæžœã€ã©ã‚“ãªã“ã¨ãŒå¯èƒ½ã«ãªã‚‹ã®ã‹ã€ãã®å±é™ºæ€§ã‚’ã‚ã‚‰ãŸã‚ã¦èªè˜ã—ã¦ã»ã—ã„ã€‚
maangie 2014/10/18
SQL

ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£

*
ãƒªãƒ³ã‚¯
SQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æ£ã—ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½œã‚‹ã®ã¯ èª°ã®å½¹å‰²ï¼Ÿ
SQLã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹å•é¡Œã¯ã€SQLãã®ã‚‚ã®ã¨åŒã˜ãã‚‰ã„ã®æ´å²ãŒã‚ã‚‹â€•â€• ã‚ã‚‹äººã¯ã€SQLã¯ãã‚‚ãã‚‚é…ã„ã‚‚ã®ã ã¨ã™ã‚‰è¨€ã†ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚ã“ã‚Œã¯ã€SQLã®æ´å²ãŒå§‹ã¾ã£ãŸé ƒã¯æ£ã—ã‹ã£ãŸã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ãŒã€ä»Šã¨ãªã£ã¦ã¯å…¨ã å½“ã¦ã¯ã¾ã‚‰ãªã„ã§ã—ã‚‡ã†ã€‚ã«ã‚‚ã‹ã‹ã‚ã‚‰ãšã€SQLã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹å•é¡Œã¯ä»Šã‚‚ä¸€èˆ¬çš„ã§ã‚ˆãã‚ã‚‹ã“ã¨ã§ã™ã€‚ã©ã†ã—ã¦ãã†ãªã£ã¦ã—ã¾ã†ã®ã§ã—ã‚‡ã†ã‹ï¼Ÿ SQLè¨€èªžã¯ã€æã‚‰ãæœ€ã‚‚æˆåŠŸã—ãŸç¬¬4ä¸–ä»£è¨€èªž(4GL)ã§ã—ã‚‡ã†ã€‚ãã®æœ€å¤§ã®åˆ©ç‚¹ã¯ã€ã€Œä½•ã‚’ã€ã¨ã€Œã©ã®ã‚ˆã†ã«ã€ ã‚’åˆ†é›¢ã§ãã‚‹ã“ã¨ã§ã™ã€‚SQLæ–‡ã¯ã€ã©ã®ã‚ˆã†ã«ãã‚Œã‚’å®Ÿè¡Œã™ã‚‹ã‹ã‚’è¨˜è¿°ã›ãšã«ã€å˜ç´”ã« ä½•ã‚’å¿…è¦ã¨ã—ã¦ã„ã‚‹ã‹ã®ã¿ã®è¨˜è¿°ã«ãªã£ã¦ã„ã¾ã™ã€‚ä»¥ä¸‹ã®ã‚ˆã†ãªä¾‹ã‚’è€ƒãˆã¦ã¿ã¾ã—ã‚‡ã†ã€‚ SELECT date_of_birth FROM employees WHERE last_name = 'WINAND'SQLã®ã‚¯ã‚¨ãƒªã¯ã€ãƒ‡ãƒ¼ã‚¿ã‚’è¦æ±‚ã™ã‚‹è‹±èªžã®æ–‡ã¨ã—ã¦èª
maangie 2014/10/18
ã¶ã“ã‚ã‚‚

SQL

*
ãƒªãƒ³ã‚¯
OTN Japan ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«
é–€å¤–ä¸å‡ºã®Oracleç¾å ´ãƒ¯ã‚¶ ç¬¬ï¼‘ç« ã€€ç›®ã‹ã‚‰ã‚¦ãƒã‚³ã®Oracleãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹åˆ†æžãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ æ—¥æœ¬ã‚ªãƒ©ã‚¯ãƒ«æ ªå¼ä¼šç¤¾ ã‚³ãƒ³ã‚µãƒ«ãƒ†ã‚£ãƒ³ã‚°çµ±æ‹¬æœ¬éƒ¨ãƒ†ã‚¯ãƒŽãƒã‚¸ãƒ¼ã‚³ ãƒ³ã‚µãƒ«ãƒ†ã‚£ãƒ³ã‚°æœ¬éƒ¨ å°ç”° åœäºŒ(ãŠã ã‘ã„ã˜) ç›®æ¬¡ Part1ã€€Â é–“é•ã„ã ã‚‰ã‘ã®Oracleãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹åˆ†æž Part2ã€€Â æ¨™æº–ãƒ„ãƒ¼ãƒ«ã§Oracleã®çŠ¶æ…‹ã‚’æ£ç¢ºã«çŸ¥ã‚‹æ–¹æ³• é…å»¶ã—ã¦ã„ã‚‹çž¬é–“ã¨ãã®å¾…ã¡çŠ¶æ…‹ã‚’æ•ã¾ãˆã‚‹æ–¹æ³• ãã‚‚ãã‚‚DBã®å•é¡Œãªã®ã‹ é…å»¶ã—ã¦ã„ã‚‹çž¬é–“ã®Oracleã®çŠ¶æ…‹ã¯ï¼Ÿ STATSPACKã®åŠ¹æžœ SQLãƒˆãƒ¬ãƒ¼ã‚¹ã®æ©Ÿèƒ½ Oracle Netã®ãƒˆãƒ¬ãƒ¼ã‚¹ Oracle Netã®ãƒˆãƒ¬ãƒ¼ã‚¹ã®æ³¨æ„ç‚¹ Part3ã€€Â OSã¨I/Oã¯ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ä½Žä¸‹ã«ã©ã†å½±éŸ¿ã™ã‚‹ã‹ Part2ã€€æ¨™æº–ãƒ„ãƒ¼ãƒ«ã§Oracleã®çŠ¶æ…‹ã‚’æ£ç¢ºã«çŸ¥ã‚‹æ–¹æ³• é…å»¶ã—ã¦ã„ã‚‹çž¬é–“ã¨ãã®å¾…ã¡çŠ¶æ…‹ã‚’æ•ã¾ãˆã‚‹æ–¹æ³• çš†ã•ã‚“ãŒã”å˜çŸ¥ã®ã¨ãŠã‚Šã€ç¾å®Ÿã®ã‚·ã‚¹ãƒ†ãƒ ã¯åˆ»ã€…ã¨ãã®çŠ¶æ…‹ã‚’å¤‰ãˆã¾
maangie 2014/10/06
*

SQL
ãƒªãƒ³ã‚¯
OTN Japan ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«
maangie 2014/09/18
SQL

*
ãƒªãƒ³ã‚¯
Whereç‹™ã„ã®ã‚ãƒ¼ã€order byç‹™ã„ã®ã‚ãƒ¼
11. I'm yoku0825 â— ã¨ã‚ã‚‹ä¼æ¥ã®DBA â— ã‚ªãƒ©ã‚¯ã‚Œãªã„ â— ãƒã‚¹ã‚°ã‚Œãªã„ â— ãƒžã‚¤ã‚¨ã‚¹ã‚ãƒ¥ãƒ¼ã‚¨ã‚‹ â— å®¶ã«å¸°ã‚‹ã¨ â— å«ã®å¤« â— ã›ãŒã‚Œã®çˆ¶ â— é¦¬é¹¿ã ã‹ã‚‰ã‹ã‚ã„ã„ã‚ã‘ã˜ã‚ƒãªãã¦ã€ã‹ã‚ã„ã„ ã‚¤ãƒ«ã‚«ãŒãŸã¾ãŸã¾ãƒã‚«ã ã£ãŸ 12. ã¯ã˜ã‚ã« â— ã‚µãƒ³ãƒ—ãƒ«ãƒ‡ãƒ¼ã‚¿ã¯ MySQLã®ã‚µãƒ³ãƒ—ãƒ«ãƒ‡ãƒ¼ã‚¿ ãƒ™ãƒ¼ã‚¹(worldãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹)ã‹ã‚‰ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ ã‚¹ã‚’å…¨ã¦å–ã£æ‰•ã£ãŸã‚‚ã®ã§ã™ â— http://dev.mysql.com/doc/index-other.html â— ã‚³ãƒ¼ãƒ‰ã¯githubã«ä¸Šã’ã¦ã‚ã‚Šã¾ã™ â— https://github.com/yoku0825/yapc_2014 â— ã™ã”ãâ€¦ã‚¦ãƒ³ã‚³ãƒ¼ãƒ‰ã§ã™â€¦ 13. ã¯ã˜ã‚ã« â— åŽŸå‰‡ã€MySQLã¯1ã¤ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã«ã¤ãåŒæ™‚ã«1 ã¤ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã—ã‹ä½¿ã„ã¾ã›ã‚“ â— Index mergeã¨ã‹ã‚ã‚‹ã‘ã©ã‚¢ãƒ¬ã¯ä¾‹å¤–ã ã—ç‹™ã£ã¦ ã‚„ã£ã¦ã‚‚é€Ÿããªã‚‹
maangie 2014/08/30
*

SQL
ãƒªãƒ³ã‚¯
Ruby on Railsã«SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã®è„†å¼±æ€§ã€ç›´ã¡ã«æ›´æ–°ã‚’
ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³é–‹ç™ºãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã€ŒRuby on Railsã€ã«2ä»¶ã®SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã®è„†å¼±æ€§ãŒè¦‹ã¤ã‹ã‚Šã€ä¿®æ£ã®ãŸã‚ã®æ›´æ–°ç‰ˆãŒ7æœˆ2æ—¥ã«ãƒªãƒªãƒ¼ã‚¹ã•ã‚ŒãŸã€‚ Ruby on Railsã®ã‚µã‚¤ãƒˆã«æŽ²è¼‰ã•ã‚ŒãŸæƒ…å ±ã«ã‚ˆã‚‹ã¨ã€è„†å¼±æ€§ã¯Active Recordç”¨ã®PostgreSQLã‚¢ãƒ€ãƒ—ã‚¿ã«å˜åœ¨ã—ã€ãƒ“ãƒƒãƒˆåˆ—åž‹ã€ã¾ãŸã¯ç¯„å›²åž‹ã‚’ä½¿ã£ã¦ã„ã‚‹ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒå½±éŸ¿ã‚’å—ã‘ã‚‹ã€‚ ãƒ“ãƒƒãƒˆåˆ—åž‹ã®è„†å¼±æ€§ã¯ãƒãƒ¼ã‚¸ãƒ§ãƒ³2.0.0ï½ž3.2.18ã«ã€ç¯„å›²åž‹ã®è„†å¼±æ€§ã¯ãƒãƒ¼ã‚¸ãƒ§ãƒ³4.0.0ï½ž4.1.2ã«ãã‚Œãžã‚Œå˜åœ¨ã™ã‚‹ã€‚æ‚ªç”¨ã•ã‚ŒãŸå ´åˆã€ç´°å·¥ã‚’æ–½ã—ãŸå€¤ã‚’ä½¿ã£ã¦ä»»æ„ã®SQLã‚’æŒ¿å…¥ã•ã‚Œã‚‹æã‚ŒãŒã‚ã‚‹ã€‚ ã“ã‚Œã‚‰è„†å¼±æ€§ã¯ã€æ›´æ–°ç‰ˆã®3.2.19ã€4.0.7ã€4.1.3ã§ä¿®æ£ã•ã‚ŒãŸã€‚ç›´å¾Œã«ãƒªã‚°ãƒ¬ãƒƒã‚·ãƒ§ãƒ³å•é¡Œã«å¯¾å¿œã™ã‚‹ãŸã‚ã®4.0.8ã¨4.1.4ãŒãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã¦ã„ã‚‹ã€‚
maangie 2014/07/09
rails

SQL

ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£

*
ãƒªãƒ³ã‚¯
ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’ã‚³ãƒ”ãƒ¼ã™ã‚‹éš›ä¸€éƒ¨ã®å€¤ã‚’å¤‰æ›´ã™ã‚‹ - chulip.org
å€¤ãŒå…¨ãåŒã˜ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’ä½œæˆã™ã‚‹ã¨ãã«ã¯ä»¥ä¸‹ã®ã‚ˆã†ã«ã™ã‚Œã°ã„ã„ insert into hoge(id, name, value) select id, name, value from foo; ä¾‹ãˆã°åå‰ã ã‘å¤‰ãˆã¦ã‚ã¨ã¯ä¸€ç·’ã®ãƒ‡ãƒ¼ã‚¿ã§ä½œã‚ŠãŸã„ã¿ãŸã„ãªå ´åˆã“ã†ã™ã‚‹ insert into hoge(id, name, value) select id, 'huga' as name, value from foo; ãªã‚“ã¤ãƒ¼ã‹é ã„ã„ ã€æ”¹è¨‚ç¬¬3ç‰ˆã€‘ SQLãƒã‚±ãƒƒãƒˆãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ (POCKET REFERENCE) ä½œè€…:æœäº• æ·³æŠ€è¡“è©•è«–ç¤¾Amazon
maangie 2014/06/24
SQL

*
ãƒªãƒ³ã‚¯
åƒ•ãŒOracleã‚’ä½¿ã‚ãªã„ç†ç”±
ã“ã“ã¯ã€åƒ•ãŒOracleã‚’ä½¿ã„ãŸããªã„ç†ç”±ã‚’ã©ã‚“ã©ã‚“æŒ™ã’ã¦ã„ã“ã†ã¨ã„ã†ã‚³ãƒ¼ãƒŠãƒ¼ã§ã™(ç¬‘)ã€‚ ã¨ã¯ã„ã£ã¦ã‚‚åƒ•ã¯å®Ÿéš›ç¾å ´ã§ã¯Oracleã‚’ä½¿ã†ç¾½ç›®ã«ãªã£ã¦ã„ã‚‹ã®ã§ å®Ÿéš›ã«ä½¿ã£ã¦ã¿ã¦é§„ç›®ã ã¨æ„Ÿã˜ãŸç‚¹ã«ã¤ã„ã¦ç´¹ä»‹ã—ã¦ã„ãã¾ã™ã€‚ æ–°ã—ãæ›¸ã„ãŸã‚‚ã®ãŒã€Œä¸Šã€ã«ãªã‚‹ã‚ˆã†ã«ä¸¦ã¹ã¦ã„ãã¾ã™ã€‚ PreparedStatement ã§ CHAR åž‹ã‚’ä½¿ã†ã¨ã Oracle ã® JDBC ã§ã‚‚å½“ç„¶ PreparedStatement ã¯ä½¿ãˆã¾ã™ã€‚ SELECT * FROM XXX WHERE NAME=? ã®ã‚ˆã†ã«ã€? ã‚’ä½¿ã£ãŸãƒã‚¤ãƒ³ãƒ‰å¤‰æ•°ã«ã‚ˆã‚‹SQLæ–‡ç™ºè¡ŒãŒã§ãã¾ã™ã€‚ ã¨ã“ã‚ãŒã€ã“ã®æ©Ÿèƒ½ã«ã¨ã‚“ã§ã‚‚ãªã„ãƒã‚°ãŒã‚ã‚Šã¾ã™ã€‚ NAMEã‚«ãƒ©ãƒ ãŒ CHAR(10) ã ã£ãŸã¨ã—ã¾ã—ã‚‡ã†ã€‚ PreparedStatement stmt = conn.preparedStatement("SELECT * FROM XXX WH
maangie 2014/06/03
SQL

*
ãƒªãƒ³ã‚¯
Amazon EC2ä¸Šã§å¦ã¹ã‚‹ã€Œã™ãä½¿ãˆã‚‹ JRubyOnRails with Oracle XE on Amazon EC2 å¤šè¨€èªžç‰ˆã€ã®æä¾›ã‚’é–‹å§‹
TOP > ãƒ—ãƒ¬ã‚¹ãƒªãƒªãƒ¼ã‚¹ä¸€è¦§ > ã€Œã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ï¼ˆä¼æ¥å‘ã‘ï¼‰ã€ã®ãƒ—ãƒ¬ã‚¹ãƒªãƒªãƒ¼ã‚¹ > æ ªå¼ä¼šç¤¾ãƒªãƒ¼ãƒ³ã‚·ã‚¹ãƒ†ãƒ ã®ãƒ—ãƒ¬ã‚¹ãƒªãƒªãƒ¼ã‚¹ > Amazon EC2ä¸Šã§å¦ã¹ã‚‹ ã€Œã™ãä½¿ãˆã‚‹ JRubyOnRails with Oracle XE on Amazon EC2 ... Amazon EC2ä¸Šã§å¦ã¹ã‚‹ ã€Œã™ãä½¿ãˆã‚‹ JRubyOnRails with Oracle XE on Amazon EC2 å¤šè¨€èªžç‰ˆã€ ã®æä¾›ã‚’é–‹å§‹ ï½žä»ŠãŒæ—¬ã€ã€Œãƒ ãƒ€ã‚¬ãƒŠã‚¤ã€Rubyã¨ã‚¯ãƒ©ã‚¦ãƒ‰ã®å‹‰å¼·æ–¹æ³•ã‚’æ”¯æ´ã—ã¾ã™ï½ž ã€Œãƒ ãƒ€ã‚¬ãƒŠã‚¤æŠ€èƒ½ã§è²¢çŒ®ã€ã‚’ã‚³ãƒ³ã‚»ãƒ—ãƒˆã«ã€ITæ”¯æ´äº‹æ¥ã‚’å±•é–‹ã™ã‚‹è–æµ03ã‚¤ãƒ³ãƒ•ã‚©ãƒ¡ãƒ¼ã‚·ãƒ§ãƒ³ã‚ºæœ‰é™ä¼šç¤¾(æœ¬ç¤¾ï¼šç¦å²¡çœŒç¦å²¡å¸‚å—åŒºã€å–ç· å½¹ï¼šå‰ç”° åŸºå´‡ã€ä»¥ä¸‹ ã‚»ã‚¤ã‚±ã‚¤03)ã¯ã€Amazon EC2ä¸Šã®AMI(Amazon Machine Image)ã¨ã—ã¦ã€ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºãƒ»IT æŠ€è¡“å¦ç¿’ã«ã€Œã™ãä½¿ãˆã‚‹ JRubyOnR
maangie 2014/05/08
*

ruby

SQL

ã‚¯ãƒ©ã‚¦ãƒ‰
ãƒªãƒ³ã‚¯
A basic UPSERT in PostgreSQL < SQL | The Art of Web
maangie 2014/04/09
*

SQL
ãƒªãƒ³ã‚¯
1 2 3 4 5 6 æ¬¡ã®ãƒšãƒ¼ã‚¸