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

chanpon0 id:chanpon0

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

${{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*Loader ã®ä½¿ã„æ–¹ - ã‚ªãƒ©ã‚¯ãƒ«ãƒ»Oracleã‚’ãƒžã‚¹ã‚¿ãƒ¼ã™ã‚‹ãŸã‚ã®åŸºæœ¬ã¨ä»•çµ„ã¿
SQL Loader (SQL ãƒãƒ¼ãƒ€) ãƒ¦ãƒ¼ãƒ†ã‚£ãƒªãƒ†ã‚£ã®ä½¿ç”¨æ–¹æ³• SQL Loader æ¦‚è¦ SQLLoader ã‚’ä½¿ç”¨ã™ã‚‹ã“ã¨ã§å¤–éƒ¨ãƒ•ã‚¡ã‚¤ãƒ«ã«è¨˜è¿°ã•ã‚Œã¦ã„ã‚‹åˆ¶å¾¡ãƒ•ã‚¡ã‚¤ãƒ«ã¨ä¸€å®šã®æ›¸å¼ã§è¨˜è¿°ã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ãƒ¬ã‚³ãƒ¼ãƒ‰ã®ã¿ã®å¤§é‡ã®ãƒ†ã‚ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿(â€»)ã‚’åŠ¹çŽ‡ã‚ˆãé«˜é€Ÿã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®è¡¨ã«ãƒãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã™ã‚‹ã“ã¨ãŒã§ãã‚‹ã€‚ (â€») ãƒ†ã‚ã‚¹ãƒˆå½¢å¼ã ã‘ã§ã¯ãªãã€Native ãªåž‹ã®ãƒ‡ãƒ¼ã‚¿ã‚„ LOB åž‹ã®ãƒ‡ãƒ¼ã‚¿ã‚‚ã‚³ãƒ³ãƒˆãƒãƒ¼ãƒ«ãƒ•ã‚¡ã‚¤ãƒ«ã®è¨å®šã«ã‚ˆã£ã¦ãƒãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã™ã‚‹ã“ã¨ãŒå¯èƒ½ã€‚ SQL Loader ã®ä¸»ãªç‰¹å¾´ ãƒ€ã‚¤ãƒ¬ã‚¯ãƒˆãƒ»ãƒ‘ã‚¹ API ã‚’ä½¿ç”¨ã—ãŸé«˜é€Ÿãªãƒ‡ãƒ¼ã‚¿ã®ãƒãƒ¼ãƒ‡ã‚£ãƒ³ã‚°(ãƒ€ã‚¤ãƒ¬ã‚¯ãƒˆãƒ»ãƒ‘ã‚¹ãƒ»ã‚¤ãƒ³ã‚µãƒ¼ãƒˆ) è¤‡æ•°ã®ãƒ‡ãƒ¼ã‚¿ãƒ•ã‚¡ã‚¤ãƒ«ã‹ã‚‰ã®ãƒ‘ãƒ©ãƒ¬ãƒ«ãƒãƒ¼ãƒ‰ æ¼¢å—ã‚³ãƒ¼ãƒ‰(ã‚ãƒ£ãƒ©ã‚¯ã‚¿ã‚»ãƒƒãƒˆ)ã®å¤‰æ› SQL é–¢æ•°ã€ãƒ¦ãƒ¼ã‚¶ãƒ¼é–¢æ•°ã€ã‚·ãƒ¼ã‚±ãƒ³ã‚¹ãªã©ã‚’ä½¿ç”¨ã—ã¦ãƒ‡ãƒ¼ã‚¿ã®ç”Ÿæˆã€åˆæˆã€å¤‰æ›ãŒå¯èƒ½ ä¸é©æ ¼ãƒ‡ãƒ¼ã‚¿ã®æŽ’é™¤ã¨ãƒ¬ãƒãƒ¼ãƒˆã€ãƒã‚° SQL Loa
chanpon0 2016/06/03
ã‚ã¨ã§èªã‚€

ORACLE

SQL

sqlloader
ãƒªãƒ³ã‚¯
è¡¨ã®çµåˆã‚’æ¥µã‚ã‚‹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ãƒ»ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯
æœ¬é€£è¼‰ã§ã¯ã€Oracleãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒ»ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ä¸ã‹ã‚‰ã€ç‰¹ã«SQLã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«æ³¨ç›®ã—ã¦ã€å®Ÿè·µãƒ¬ãƒ™ãƒ«ã®æ‰‹æ³•ã‚’è§£èª¬ã™ã‚‹ã€‚èªè€…ã¯Oracleãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã‚’ç†è§£ã—ã€é‹ç”¨ç®¡ç†ã®å®Ÿå‹™çµŒé¨“ã‚’ç©ã‚“ã§ã„ã‚‹ã“ã¨ãŒæœ›ã¾ã—ã„ã€‚å¯¾è±¡ã¨ã™ã‚‹ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯ç¾çŠ¶ã§åºƒãä½¿ã‚ã‚Œã¦ã„ã‚‹Oracle9iã®æ©Ÿèƒ½ã‚’åŸºæœ¬ã¨ã™ã‚‹ãŒã€Oracle 10gã§æœ‰åŠ¹ãªæƒ…å ±ã‚‚éšæ™‚ç´¹ä»‹ã—ã¦ã„ãã€‚ï¼ˆç·¨é›†å±€ï¼‰ é€£è¼‰ç›®æ¬¡ å‰å›žã¾ã§ã¯ã€ç´¢å¼•ã«é–¢ã™ã‚‹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ãƒ»ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã‚’èª¬æ˜Žã—ã¾ã—ãŸã€‚ä»Šå›žã‹ã‚‰ã¯è¡¨ã®çµåˆã«é–¢ã™ã‚‹ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹å‘ä¸Šæ–¹æ³•ã‚’è€ƒãˆã¦ã¿ã¾ã™ã€‚çµåˆå‡¦ç†ã¯ã€æ£è¦åŒ–ã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã¯ã€å¿…ãšå¿…è¦ã«ãªã‚‹å‡¦ç†ã§ã‚ã‚Šã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãŒå•é¡Œã¨ãªã‚Šã‚„ã™ã„éƒ¨åˆ†ã§ã‚‚ã‚ã‚Šã¾ã™ã€‚ã“ã“ã§ã¯ã€å‚ç…§ã™ã‚‹è¡¨ã®ä»¶æ•°ã€çµžã‚Šè¾¼ã¿æ¡ä»¶ã®æœ‰ç„¡ãªã©ã‚’å¤‰æ›´ã—ã€çµåˆã®ç¨®é¡žã«ã‚ˆã£ã¦å‡¦ç†æ™‚é–“ã€ã‚¢ã‚¯ã‚»ã‚¹ãƒ–ãƒãƒƒã‚¯æ•°ãªã©ãŒã©ã®ã‚ˆã†ã«å¤‰ã‚ã‚‹ã‹ã€å®Ÿä¾‹ã‚’æŒ™ã’ã¦èª¬æ˜Žã—ã¦ã„ã
chanpon0 2016/05/31
ã‚ã¨ã§èªã‚€

oracle

SQL
ãƒªãƒ³ã‚¯
SQLã®æš—é»™ã®åž‹å¤‰æ›ã¯ãƒ¯ãƒŠãŒã„ã£ã±ã„
è£œè¶³ ã“ã®è¨˜äº‹ã¯æ—§å¾³ä¸¸æµ©ã®æ—¥è¨˜ã‹ã‚‰ã®è»¢è¼‰ã§ã™ã€‚å…ƒURLã€ã‚¢ãƒ¼ã‚«ã‚¤ãƒ–ã€ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯1ã€ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯2ã€‚ å‚™å¿˜ã®ãŸã‚è»¢è¼‰ã„ãŸã—ã¾ã™ãŒã€ã“ã®è¨˜äº‹ã¯2009å¹´9æœˆ24æ—¥ã«å…¬é–‹ã•ã‚ŒãŸã‚‚ã®ã§ã€å½“æ™‚ã®å¾³ä¸¸ã®è€ƒãˆã‚’ç¤ºã™ã‚‚ã®ã‚’ã€åŸºæœ¬çš„ã«å†…å®¹ã‚’å¤‰æ›´ã›ãšã«ãã®ã¾ã¾è»¢è¼‰ã™ã‚‹ã‚‚ã®ã§ã™ã€‚ è£œè¶³çµ‚ã‚ã‚Š ã“ã®ã‚¨ãƒ³ãƒˆãƒªã§ã¯ã€SQLã«ãŠã„ã¦ã€Œæš—é»™ã®åž‹å¤‰æ›ã€ã‚’ä½¿ã†ã¹ãã§ãªã„ç†ç”±ã¨ã—ã¦ã€å…·ä½“çš„ãªã€Œãƒ¯ãƒŠã€ã‚’ã„ãã¤ã‹ç´¹ä»‹ã—ã¾ã™ã€‚Â æ•°å€¤é …ç›®ã«å¯¾ã™ã‚‹SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³å¯¾ç–ã®ã¾ã¨ã‚ã«ã¦èª¬æ˜Žã—ãŸã‚ˆã†ã«ã€RDBã®æ•°å€¤åž‹ã®åˆ—ã«å¯¾ã—ã¦SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³å¯¾ç–ã‚’ã™ã‚‹æ–¹æ³•ã¨ã—ã¦ã€ä»¥ä¸‹ã®ä¸‰ç¨®é¡žãŒçŸ¥ã‚‰ã‚Œã¦ã„ã¾ã™ã€‚ ãƒã‚¤ãƒ³ãƒ‰æ©Ÿæ§‹ã‚’ç”¨ã„ã‚‹ ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã®æ•°å€¤ã¨ã—ã¦ã®å¦¥å½“æ€§ç¢ºèªã‚’è¡Œã† ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã‚’æ–‡å—åˆ—ãƒªãƒ†ãƒ©ãƒ«ã¨ã—ã¦ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ã™ã‚‹ ã“ã®ã†ã¡ã€æ–¹æ³•3ã‚’ä½¿ã†ã¹ãã§ãªã„èª¬æ˜Žã®è£œè¶³ã§ã™ã€‚å…·ä½“çš„ã«ã¯ã€æ–¹æ³•3ã«ã¯ã€ã€Œæš—é»™ã®åž‹å¤‰æ›ã€ãŒç™ºç”Ÿã—ã¾ã™ãŒã€ãã‚ŒãŒæ€ã‚
chanpon0 2015/12/10
castã¾ã§ã™ã‚‹å¿…è¦ãŒã‚ã‚‹ã‹ã€‚ã€‚

SQL
ãƒªãƒ³ã‚¯
Sublime Text ã§SQLã‚’æ•´å½¢ã™ã‚‹ - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
chanpon0 2015/11/17
SQL

Sublime
ãƒªãƒ³ã‚¯
ãƒã‚¹ãƒ†ãƒƒãƒ‰ãƒ»ãƒ«ãƒ¼ãƒ—çµåˆ - ã‚ªãƒ©ã‚¯ãƒ«ãƒ»Oracleã‚’ãƒžã‚¹ã‚¿ãƒ¼ã™ã‚‹ãŸã‚ã®åŸºæœ¬ã¨ä»•çµ„ã¿
ãƒã‚¹ãƒ†ãƒƒãƒ‰ãƒ»ãƒ«ãƒ¼ãƒ—çµåˆ ï¼ˆNESTED LOOP JOINï¼‰ ãƒã‚¹ãƒ†ãƒƒãƒ‰ãƒ«ãƒ¼ãƒ—çµåˆã¨ã¯ã€ã‚‚ã£ã¨ã‚‚åŸºæœ¬çš„ãªçµåˆã§ã‚ã‚‹ã€‚ä¾‹ãˆã°ï¼’ã¤ã®è¡¨ã«ãŠã‘ã‚‹ãƒã‚¹ãƒ†ãƒƒãƒ‰ãƒ«ãƒ¼ãƒ—çµåˆã‚’ï¼’é‡ãƒ«ãƒ¼ãƒ—ã—ãŸç¹°ã‚Šè¿”ã—å‡¦ç†ã®ãƒ—ãƒã‚°ãƒ©ãƒ ã‚’æƒ³åƒã™ã‚‹ã¨ã‚·ãƒ³ãƒ—ãƒ«ã«ç†è§£ã§ãã‚‹ã€‚ SELECT t1.colA, t2.colB FROM t1, t2 WHERE t1.key1 = t2.key2 and t1.colA = 'A' and t2.colB = 'B' ã¨ã„ã† SQL ã«ã¤ã„ã¦è€ƒãˆã¦ã¿ã‚‹ã€‚ ãƒ†ãƒ¼ãƒ–ãƒ« t1 ã¯é…åˆ— a1ã€ãƒ†ãƒ¼ãƒ–ãƒ« t2 ã‚’é…åˆ— a2 ã¨ç½®ãæ›ãˆã‚‹ã¨ æŽ¢ç´¢ã™ã‚‹ ã‚¢ãƒ«ã‚´ãƒªã‚ºãƒ (A) ã¯ æº–å‚™ å¤‰æ•° conditionA ã«æ¡ä»¶ 'A' ã‚’ä»£å…¥ã™ã‚‹ å¤‰æ•° conditionBã«æ¡ä»¶ 'B' ã‚’ä»£å…¥ã™ã‚‹ å¤‰æ•° conditionAã€conditionB ã‚’å¼•æ•°ã«ä»¥ä¸‹ã®å‡¦ç†ã‚’å‘¼ã³å‡ºã™ å‡¦ç†ã®å†…å®¹ é…åˆ— a1 ã‚’
chanpon0 2014/10/16
NLJï¼ˆNested loop joinï¼‰

SQL

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
SQLã§order byã¨group byã‚’ä½µç”¨ã™ã‚‹æ™‚ã®æ›¸ãæ–¹ - ã¾ã‚“ã¨ã‚‹ã½ã£ã¨
çã—ãSQLæ›¸ã„ã¦ãŸã‚‰è©°ã¾ã£ãŸã®ã§ãƒ¡ãƒ¢ã—ã¦ãŠãã¾ã™ã€‚ ã‚„ã‚ŠãŸã„ã“ã¨ ã©ã°ãƒ¼ã£ã¨ãƒ‡ãƒ¼ã‚¿ãŒè²¯ã¾ã£ã¦ã„ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ãŒã‚ã£ãŸã¨ã—ã¦ã€‚ä¾‹ãˆã°è‰²ã‚“ãªãƒ¦ãƒ¼ã‚¶ã®ã‚¢ã‚¯ã‚»ã‚¹ãƒã‚°ãŒè²¯ã¾ã£ã¦ã„ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’æƒ³å®šã—ã¾ã™ã€‚ãã®ä¸ã‹ã‚‰å„ãƒ¦ãƒ¼ã‚¶ã®æœ€æ–°ã‚¢ã‚¯ã‚»ã‚¹æƒ…å ±ã‚’å–ã‚ŠãŸã„æ™‚ã«ã©ã†ã™ã‚‹ã‹ã€‚ ã€Œdateã§order byã—ã¦ã‹ã‚‰ã€group byã™ã‚Œã°ã„ã„ã‚“ã˜ã‚ƒãªã„ã®ï¼Ÿã€ã¨æ€ã£ã¦ãŸã‚“ã™ã‘ã©ã€ã©ã†ã‚„ã‚‰ã“ã®2ã¤ã¯ä½µç”¨ã™ã‚‹ã¨å…ˆã«group byã•ã‚Œã¦ãã®çµæžœãŒorder byã•ã‚Œã‚‹ãã†ãªã€‚ãã†ã„ã†ä»•æ§˜ã‚‰ã—ã„â€¦ã€‚ä»¥ä¸‹ã®è¨˜äº‹ãŒå‚è€ƒã«ãªã‚Šã¾ã—ãŸã€‚ Mysqlã®ã‚µãƒ–ã‚¯ã‚¨ãƒªã¨groupã€orderã®å„ªå…ˆåº¦ â€“ Life order byã¨group byã‚’ä½µç”¨ã™ã‚‹æ™‚ã®ã‚µãƒ–ã‚¯ã‚¨ãƒª ã˜ã‚ƒã‚ã€ã‚µãƒ–ã‚¯ã‚¨ãƒªã§dateã§order byã—ãŸçµæžœã«å¯¾ã—ã¦group byã—ãŸã‚‰ãˆãˆã‚„ã‚“ã¨è¨€ã†è©±ã«ãªã‚Šã¾ã—ã¦ã€å…·ä½“çš„ã«ã¯ã“ã‚“ãªæ„Ÿã˜ã«ãªã‚Šã¾ã—ãŸã€‚å†…å®¹ã¯å¤‰æ•°åã‚’è¦‹ã¦å¯Ÿ
chanpon0 2014/04/08
ã‚ã‚‹é …ç›®ã§ä¸¦ã¹ãŸæœ€åˆã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã ã‘group by ã—ã¦å‡ºåŠ›ã—ãŸã„ã€‚

SQL
ãƒªãƒ³ã‚¯
Rails ã§ã€Controller ã«å®šç¾©ã•ã‚Œã¦ã„ã‚‹ action ã‚’ä¸€åº¦ã«å–å¾—ã™ã‚‹æ–¹æ³•ã¯ã‚ã‚Šã¾ã™ã‹ï¼Ÿ - QA@IT
å¹³ç´ ã‚ˆã‚ŠQAï¼ ITã‚’ã”åˆ©ç”¨ã„ãŸã ãã€èª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ QAï¼ ITã¯ã€Œè³ªå•ã‚„å›žç”ã‚’ã€Žå…±æœ‰ã€ã—ã€Žç·¨é›†ã€ã—ã¦ã„ãã“ã¨ã§ãƒ™ã‚¹ãƒˆãªQAã‚’è“„ç©ã§ãã‚‹ã€IT ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ãŸã‚ã®å•é¡Œè§£æ±ºã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãƒ¼ã€ã¨ã—ã¦ç´„7å¹´é–“é‹å–¶ã‚’ã—ã¦ãã¾ã—ãŸã€‚ã“ã‚Œã¾ã§ã‚µãƒ¼ãƒ“ã‚¹ã‚’ç¶šã‘ã‚‹ã“ã¨ãŒã§ããŸã®ã¯ã€QAï¼ ITã®ã‚³ãƒ³ã‚»ãƒ—ãƒˆã«å…±æ„Ÿã‚’ã„ãŸã ãã€é©åˆ‡ãªè³ªå•ã‚„å›žç”ã‚’ãŠå¯„ã›ã„ãŸã ã„ãŸçš†ã•ã¾ã®ã”æ”¯æ´ãŒã‚ã£ãŸã‹ã‚‰ã“ãã¨è€ƒãˆã¦ãŠã‚Šã¾ã™ã€‚é‡ãã¦å¾¡ç¤¼ç”³ã—ä¸Šã’ã¾ã™ã€‚ ã—ã‹ã—ãªãŒã‚‰ã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®æƒ…å ±å…¥æ‰‹æ–¹æ³•ã®å¤šæ§˜åŒ–ã‚„QAã‚µãƒ¼ãƒ“ã‚¹å¸‚å ´ã®çŠ¶æ³ã€ï¼ ITã®ä»Šå¾Œã®ãƒ¡ãƒ‡ã‚£ã‚¢é‹å–¶æ–¹é‡ãªã©ã‚’æ¤œè¨Žã—ãŸçµæžœã€2020å¹´2æœˆ28æ—¥ï¼ˆé‡‘ï¼‰15:00ã‚’ã‚‚ã¡ã¾ã—ã¦QAï¼ ITã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã™ã‚‹ã“ã¨ã«ã—ã¾ã—ãŸã€‚ ã“ã‚Œã¾ã§ã”åˆ©ç”¨ã‚’ã„ãŸã ãã¾ã—ãŸçš†ã•ã¾ã«ã¯æ®‹å¿µãªãŠçŸ¥ã‚‰ã›ã¨ãªã‚Šã€èª ã«å¿ƒè‹¦ã—ãæ€ã£ã¦ãŠã‚Šã¾ã™ã€‚ä½•ã¨ãžã€ã”ç†è§£ã‚’ã„ãŸã ã‘ã¾ã™ã¨å¹¸ã„ã§ã™ã€‚ QAï¼ ITã®7å¹´é–“ã§çš†ã•ã¾ã®çŸ¥è˜
chanpon0 2014/01/24
selectã€€updateã€€å‰å·æ§˜ã®æ–¹æ³•ã§ã€‚

select

SQL
ãƒªãƒ³ã‚¯
MySQLã§VIEWã‚’ä½¿ã†ãƒ¡ãƒªãƒƒãƒˆã‚’æ•™ãˆã¦ãã ã•ã„ã€‚ - MySQLã‚’ã‚ˆãä½¿ã£ã¦ã„ã¾ã™ã€‚MySQL5ã‚ãŸã‚Šã‹ã‚‰VIEWãŒä½¿ãˆã‚‹... - Yahoo!çŸ¥æµè¢‹
MySQLã§VIEWã‚’ä½¿ã†ãƒ¡ãƒªãƒƒãƒˆã‚’æ•™ãˆã¦ãã ã•ã„ã€‚ MySQLã‚’ã‚ˆãä½¿ã£ã¦ã„ã¾ã™ã€‚MySQL5ã‚ãŸã‚Šã‹ã‚‰VIEWãŒä½¿ãˆã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸãŒã€ç¾åœ¨ã‚ã¾ã‚Šä½¿ç”¨ã—ã¦ãŠã‚Šã¾ã›ã‚“ã€‚VIEWã‚’ä½¿ç”¨ã™ã‚‹ãƒ¡ãƒªãƒƒãƒˆã‚’æ•™ãˆã¦ã„ãŸã ã‘ã¾ã™ã§ã—ã‚‡ã†ã‹ã€‚ ã‚µãƒ–ã‚¯ã‚¨ãƒªã¨ã—ã¦ã‚ˆãä½¿ç”¨ã™ã‚‹SQLæ–‡ãŒã‚ã‚‹å ´åˆã€ãã‚Œã‚’VIEWã¨ã—ã¦ç™»éŒ²ã—ã¦ãŠãã¨ã€SQLã‚’è¨˜è¿°ã™ã‚‹éš›ã®é–“é•ã„ãŒæ¸›ã£ãŸã‚Šã€ã‚µãƒ–ã‚¯ã‚¨ãƒªã‚’å¤‰æ›´ã™ã‚‹éš›ã«ã€VIEWã‚’ä¿®æ£ã™ã‚Œã°ã€è©²å½“ã™ã‚‹ã™ã¹ã¦ã®ã‚µãƒ–ã‚¯ã‚¨ãƒªæ–‡ã«é©ç”¨ã•ã‚Œã‚‹ã¨ã„ã†ãƒ¡ãƒªãƒƒãƒˆã‚’æ€ã„ã¤ãã¾ã—ãŸã€‚ãã‚Œä»¥å¤–ã®ãƒ¡ãƒªãƒƒãƒˆã¯ã‚ã‚‹ã®ã§ã—ã‚‡ã†ã‹ã€‚ ä¾‹ãˆã°ã‚µãƒ–ã‚¯ã‚¨ãƒªã‚’VIEWã¨ã—ã¦ç™»éŒ²ã—ã¦ãŠãã“ã¨ã«ã‚ˆã£ã¦é€Ÿåº¦ãŒå‘ä¸Šã™ã‚‹ã®ã§ã‚ã‚Œã°ã€ãã†ã„ã†é¢ã§ã‚‚ç©æ¥µçš„ã«ä½¿ç”¨ã—ã¦ã„ããŸã„ã¨æ€ã†ã®ã§ã™ãŒãƒ»ãƒ»ãƒ»ã€‚ è˜è€…ã®æ–¹ã€ã”æ•™æŽˆã®ã»ã©ãŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
chanpon0 2012/09/18
SQL

view

ã‚ã¨ã§è¦‹ã‚‹
ãƒªãƒ³ã‚¯
ã€SQLã€‘é‡è¤‡ã—ãŸè¡Œã‚’å–ã‚Šå‡ºã™
--ãƒ†ãƒ¼ãƒ–ãƒ«ã‹ã‚‰ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰Aã®å€¤ãŒé‡è¤‡ã—ã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ã‚’å–ã‚Šå‡ºã™ã€‚ --æ‰‹é †ï¼š --â‘ GROUP BYã§ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰Aã‚’æŒ‡å®šã—ã€HAVINGå¥ã‚’ç”¨ã„ã¦ --ã€€COUNT()ã®çµæžœãŒï¼’ä»¥ä¸Šã®ãƒ‡ãƒ¼ã‚¿ã®ãƒªã‚¹ãƒˆã‚’å–å¾—ã™ã‚‹ã€‚ --ã€€ä¾‹ï¼‰ãƒªã‚¹ãƒˆã®å–å¾—æ–¹æ³• SELECT [key] FROM [test].[dbo].[tbl_union1] GROUP BY [key] HAVING COUNT([key])>1 --â‘¡â‘ ã§å–å¾—ã—ãŸãƒªã‚¹ãƒˆã«å…¥ã£ã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ã‚’ãƒ†ãƒ¼ãƒ–ãƒ«ã‹ã‚‰å–å¾—ã™ã‚‹ã€‚ SELECT [key] FROM [test].[dbo].[tbl_union1] WHERE [key] in (SELECT [key] FROM [test].[dbo].[tbl_union1] GROUP BY [key] HAVING COUNT([key])>1) ã€çµæžœã€‘ key ---------- uni
chanpon0 2012/06/18
sql
ãƒªãƒ³ã‚¯
category/ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹/MySQL - ãƒšãƒ³ã‚®ãƒ³ã®æœ ã€œ Linux ã‚½ãƒ•ãƒˆé›† ã€œ
chanpon0 2012/05/04
SQL

ãƒ•ãƒªãƒ¼ã‚½ãƒ•ãƒˆ

db
ãƒªãƒ³ã‚¯
ãƒ•ãƒªãƒ¼ã‚½ãƒ•ãƒˆã€€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é–‹ç™ºã®å¿…éœ€å“ã€€é»’çŒ« SQL Studio : SEãŒè–¦ã‚ã‚‹å½¹ã«ç«‹ã¤ãƒ•ãƒªãƒ¼ã‚½ãƒ•ãƒˆï¼†ã‚½ãƒ•ãƒˆ
SEãŒè–¦ã‚ã‚‹å½¹ã«ç«‹ã¤ãƒ•ãƒªãƒ¼ã‚½ãƒ•ãƒˆï¼†ã‚½ãƒ•ãƒˆ ç„¡æ–™ã®ãƒ•ãƒªãƒ¼ã‚½ãƒ•ãƒˆã‹ã‚‰æœ‰æ–™ã®ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã¾ã§æ§˜ã€…ãªã‚½ãƒ•ãƒˆãŒè±Šå¯Œã«å˜åœ¨ã—ã¾ã™ ãã“ã§SEã‚ªã‚¹ã‚¹ãƒ¡ã®å½¹ã«ç«‹ã¤ã‚½ãƒ•ãƒˆï¼†æƒ…å ±ã‚’ç´¹ä»‹ï¼ ã“ã®ã‚µã‚¤ãƒˆã‚’è¦‹ã¦ã„ã¦ãã‚Œã¦ã„ã‚‹äººã®ä¸ã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«é–¢ã‚ã£ã¦ã„äººã¯ã©ã‚Œãã‚‰ã„ã‚‹ã§ã—ã‚‡ã†ã‹ï¼Ÿç†è€…ã‚‚SqlServer ORACLE MySQL Accessãªã©ã•ã¾ã–ã¾ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½¿ç”¨ã—ã¾ã™(æœ€è¿‘ã¯SqlServerãŒã»ã¨ã‚“ã©ã§ã™ãŒãƒ»ãƒ»ãƒ»æ±—)å¤§ä½“ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã”ã¨ã«ã•ã¾ã–ã¾ãªä¾¿åˆ©ãªé–‹ç™ºç’°å¢ƒãŒã¤ã„ã¦ãŠã‚Šä¾¿åˆ©ã«SQLã‚’ä½œæˆã—å®Ÿè¡Œã™ã‚‹ã“ã¨ãŒã§ãã‚‹ã®ã§ã™ãŒã€é–‹ç™ºç’°å¢ƒãŒã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œã¦ã„ãªã‹ã£ãŸã‚ŠMSDEã®ã‚ˆã†ãªãã‚‚ãã‚‚é–‹ç™ºç’°å¢ƒãŒå˜åœ¨ã—ãªã„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç’°å¢ƒã§ä½œæˆãŒå¿…è¦ãªã“ã¨ãŒã—ã°ã—ã°ã‚ã‚Šã¾ã™ã€‚ã‚‚ã¡ã‚ã‚“ã€Œã‚³ãƒžãƒ³ãƒ‰ ãƒ—ãƒãƒ³ãƒ—ãƒˆã€ã‚’ä½¿ç”¨ã—ã‚³ãƒžãƒ³ãƒ‰ã§ä½œæ¥ã™ã‚‹ã“ã¨ã¯å¯èƒ½ãªã®ã§ã™ãŒã€ä¾¿åˆ©ãªç’°å¢ƒã§ä½œæˆã—å®Ÿè¡Œã™ã‚‹ã“ã¨ã«ãªã‚ŒãŸç†è€…ã®ã‚ˆã†ãªäººé–“ã«ã¯è‹¦ç—›
chanpon0 2012/05/04
ãƒ•ãƒªãƒ¼ã‚½ãƒ•ãƒˆ

SQL

db
ãƒªãƒ³ã‚¯
prepareãƒ¡ã‚½ãƒƒãƒ‰ - PDOã®åˆ©ç”¨ - PHPå…¥é–€
prepareãƒ¡ã‚½ãƒƒãƒ‰ã¯queryãƒ¡ã‚½ãƒƒãƒ‰ã¨ä¼¼ãŸã‚ˆã†ãªæ©Ÿèƒ½ã‚’æä¾›ã—ã¾ã™ãŒã€SQLæ–‡ã®åŸºæœ¬éƒ¨åˆ†ãŒåŒã˜ã§å€¤ã ã‘ç•°ãªã‚‹ã‚ˆã†ãªå ´åˆ(ä¾‹ãˆã°åŒã˜ãƒ†ãƒ¼ãƒ–ãƒ«ã«å€¤ã ã‘å¤‰ãˆã¦ä½•å›žã‚‚ãƒ‡ãƒ¼ã‚¿ã‚’æŒ¿å…¥ã™ã‚‹ã‚ˆã†ãªå ´åˆã§ã™)ã«åŠ¹çŽ‡ã‚ˆãè¡Œãˆã‚‹æ©Ÿèƒ½ã‚’æä¾›ã—ã¦ãã‚Œã¾ã™ã€‚ PDOStatement PDO::prepare ( string statement [, array driver_options] ) PDOStatement::execute() ãƒ¡ã‚½ãƒƒãƒ‰ã«ã‚ˆã£ã¦å®Ÿè¡Œã•ã‚Œã‚‹ SQL ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã‚’ æº–å‚™ã—ã¾ã™ã€‚ SQL ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã¯ã€æ–‡ãŒå®Ÿè¡Œã•ã‚Œã‚‹ã¨ãã«å®Ÿéš›ã®å€¤ã«ç½®ãæ› ãˆã‚‰ã‚Œã‚‹ 0 å€‹ã‚‚ã—ãã¯ãã‚Œä»¥ä¸Šã®åå‰ (:name) ã‚‚ã—ãã¯ç–‘å•ç¬¦(?) ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ ãƒžãƒ¼ã‚¯ã‚’å«ã‚€ã“ã¨ãŒã§ãã¾ã™ã€‚ åå‰ã¨ç–‘å•ç¬¦ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã‚’åŒä¸€ SQL ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ ãƒ³ãƒˆä¸ã§ä½¿ç”¨ã™ã‚‹ã“ã¨ã¯ã§ãã¾ã›ã‚“ã€‚ ã©ã¡ã‚‰ã‹ä¸€æ–¹ã‹ã€ä»–ã®ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿å½¢å¼
chanpon0 2012/02/16
SQL

pdo
ãƒªãƒ³ã‚¯
Create it! | MySQL-ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã®æ”¹è¡Œã‚’å‰Šé™¤
PHPã€AJAXã€CodeIgniter,Javascriptã€XHTMLã€CSSã€SEO,ã‚¢ãƒ•ã‚§ãƒªã‚¨ã‚¤ãƒˆã€WEBãªã‚‰ãªã‚“ã§ã‚‚æ¥ã„ã€‚ << August 2008 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 >>
chanpon0 2011/04/11
mysql

SQL
ãƒªãƒ³ã‚¯
ã€ŽMySQLã®UNIONæ§‹æ–‡ã¨ã‹ã§è©¦è¡ŒéŒ¯èª¤ã—ãŸãƒ¡ãƒ¢ã€
æŽ²ç¤ºæ¿ï¼ˆã§ã‚‚ãªã‚“ã§ã‚‚ã„ã„ãŒï¼‰ã‚’ä½œã‚‹ã«ã‚ãŸã‚Šã€ãŸã¨ãˆã°ä»¥ä¸‹ã®ã‚ˆã†ã«ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ãã£ã¤ã‘ã¦ã‹ã‚‰è¨˜äº‹ã‚’å–å¾—ã™ã‚‹ã€‚ mysql> (SELECT id, user, message, create_date FROM BBS_MESSAGE) -> UNION -> (SELECT id, user, message, create_date FROM BBS_REPLY) -> ORDER BY create_date DESC -> LIMIT 0, 5 -> ; ã“ã®å ´åˆã€ã€Œè¨˜äº‹æ•°ã€ã‚’å–å¾—ã™ã‚‹ã«ã¯ã©ã†ã™ã‚Œã°ã„ã„ã‹ï¼Ÿ æœ€åˆã«è©¦ã—ãŸã®ãŒä»¥ä¸‹ã®SQLã€‚ mysql> SELECT count(*) FROM ( -> (SELECT id FROM BBS_MESSAGE) -> UNION -> (SELECT id FROM BBS_REPLY) -> ); ã“ã‚Œã¯å¤±æ•—ã™ã‚‹ã€‚ ERROR 124
chanpon0 2011/04/06
ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ã¾ãŸã„ã§ãƒ‡ãƒ¼ã‚¿ã‚’countã€‚é‡è¤‡ã¯çœãã€‚å‰ã«ã‚‚ã‚„ã£ãŸãªãƒ¼ã€ã“ã‚“ãªã“ã¨ã€‚ã€‚

mysql

union

SQL
ãƒªãƒ³ã‚¯
ã‚«ãƒ©ãƒ ã‚’è¿½åŠ ã™ã‚‹æ–¹æ³•ã€MySQLã€‘ - Programming Magic
MySQLã§ã¯ä»¥ä¸‹ã®ã‚ˆã†ãªã‚¯ã‚¨ãƒªãƒ¼ã§ã‚«ãƒ©ãƒ ã‚’è¿½åŠ ã™ã‚‹ã“ã¨ãŒã§ãã‚‹ã€‚ ALTER TABLE <ãƒ†ãƒ¼ãƒ–ãƒ«å> ADD <ã‚«ãƒ©ãƒ å> <åž‹æƒ…å ±>; ALTER TABLE test ADD name varchar(255); ALTER TABLE test ADD num int unsigned; ALTER TABLE sample ADD address varchar(1023) NOT NULL; ã¾ãŸã€ä»¥ä¸‹ã®ã‚ˆã†ã«ã‚«ãƒ©ãƒ ã‚’è¿½åŠ ã™ã‚‹ä½ç½®ã‚’æŒ‡å®šã™ã‚‹ã“ã¨ã‚‚ã§ãã‚‹ã€‚ ALTER TABLE <ãƒ†ãƒ¼ãƒ–ãƒ«å> ADD <ã‚«ãƒ©ãƒ å> <åž‹æƒ…å ±> AFTER <ã‚«ãƒ©ãƒ å>; ALTER TABLE <ãƒ†ãƒ¼ãƒ–ãƒ«å> ADD <ã‚«ãƒ©ãƒ å> <åž‹æƒ…å ±> FIRST; ALTER TABLE test ADD comment text AFTER name; ALTER TABLE test ADD
chanpon0 2011/04/06
alter tableã§ä½ç½®æŒ‡å®šã—ã¦é …ç›®è¿½åŠ ï¼ˆæŒ¿å…¥ï¼‰

SQL

MySQL

db
ãƒªãƒ³ã‚¯
åŸºç¤Žã‹ã‚‰ç†è§£ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã—ãã¿ï¼ˆ5ï¼‰ï¼šITpro
SQLæ–‡ã‚’å®Ÿè¡Œã™ã‚‹éš›ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«å¤§ããªå½±éŸ¿ã‚’åŠã¼ã™ã‚‚ã®ã¨ã—ã¦ï¼Œã‚‚ã†ä¸€ã¤ï¼Œã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒã‚ã‚Šã¾ã™ã€‚ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã¤ã„ã¦ã¯ï¼Œã©ã†å®šç¾©ã™ã¹ãã‹ã¨ã„ã†ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆä¸Šã®å•é¡Œã¨ï¼Œã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’æœ‰åŠ¹ã«ä½¿ã†ãŸã‚ã®SQLæ–‡ã‚’ã©ã†æ›¸ãã¹ãã‹ã¨ã„ã†ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ä¸Šã®å•é¡ŒãŒã‚ã‚Šã¾ã™ã€‚ ã“ã“ã§ã¯ãƒ†ãƒ¼ãƒ–ãƒ«è¨è¨ˆä¸Šã®å•é¡Œã‚’ä¸»ã«å–ã‚Šä¸Šã’ã¾ã™ã€‚SQLæ–‡ã®ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã«ã¤ã„ã¦ã¯å›²ã¿è¨˜äº‹ã€ŒSQLæ–‡ã‚’æœ€é€Ÿã«ã™ã‚‹11ã®ãƒã‚¤ãƒ³ãƒˆã€ã‚’å‚ç…§ã—ã¦ãã ã•ã„ã€‚ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯ï¼Œãƒ†ãƒ¼ãƒ–ãƒ«ã®æ¤œç´¢é€Ÿåº¦ã‚’å‘ä¸Šã•ã›ã‚‹ãŸã‚ã®ã‚‚ã®ã§ã™ã€‚ãã‚Œãžã‚Œã®SQLæ–‡ã«å¯¾ã—ã¦æœ€é©ãªã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’å®šç¾©ã™ã‚‹ã®ãŒç†æƒ³çš„ã§ã™ãŒï¼Œå®Ÿéš›ã«ã¯ã‚ã‚‹ç¨‹åº¦é™ã‚‰ã‚ŒãŸã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã§ï¼Œå¿…è¦ãªãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è¦ä»¶ã‚’æº€ãŸã™ã‚ˆã†ã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’å®šç¾©ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚åŠ ãˆã¦ï¼Œã©ã‚“ãªSQLæ–‡ãŒå®Ÿéš›ã«ç™ºè¡Œã•ã‚Œã‚‹ã®ã‹ãŒã‚ã‚‰ã‹ã˜ã‚ã‚ã‹ã£ã¦ã„ãªã„å ´åˆã¯ï¼Œé©å½“ãªæƒ³å®šã«åŸºã¥ã„ã¦ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’å®šç¾©ã—ã¦ãŠã‹ãªãã¦ã¯
chanpon0 2011/03/30
index

SQL

ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹

mysql

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
MySQL :: MySQL 8.0 ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢ãƒ« :: 12.8.2 æ£è¦è¡¨ç¾
æ£è¦è¡¨ç¾ã¯ã€è¤‡é›‘ãªæ¤œç´¢ã§ãƒ‘ã‚¿ãƒ¼ãƒ³ã‚’æŒ‡å®šã™ã‚‹å¼·åŠ›ãªæ–¹æ³•ã§ã™ã€‚ ã“ã®ã‚»ã‚¯ã‚·ãƒ§ãƒ³ã§ã¯ã€æ£è¦è¡¨ç¾ã®ç…§åˆã«ä½¿ç”¨ã§ãã‚‹é–¢æ•°ã¨æ¼”ç®—åã«ã¤ã„ã¦èª¬æ˜Žã—ã€æ£è¦è¡¨ç¾ã®æ“ä½œã«ä½¿ç”¨ã§ãã‚‹ç‰¹æ®Šæ–‡å—ã¨æ§‹é€ ã®ä¸€éƒ¨ã‚’ä¾‹ã¨ã¨ã‚‚ã«ç¤ºã—ã¾ã™ã€‚ ã‚»ã‚¯ã‚·ãƒ§ãƒ³3.3.4.7ã€Œãƒ‘ã‚¿ãƒ¼ãƒ³ãƒžãƒƒãƒãƒ³ã‚°ã€ã‚‚å‚ç…§ã—ã¦ãã ã•ã„ã€‚ MySQL ã§ã¯ã€Unicode ã®å›½éš›ã‚³ãƒ³ãƒãƒ¼ãƒãƒ³ãƒˆ (ICU) ã‚’ä½¿ç”¨ã—ãŸæ£è¦è¡¨ç¾ã‚µãƒãƒ¼ãƒˆãŒå®Ÿè£…ã•ã‚Œã¦ã„ã¾ã™ã€‚ICU ã¯å®Œå…¨ãª Unicode ã‚µãƒãƒ¼ãƒˆã‚’æä¾›ã—ã€ãƒžãƒ«ãƒãƒã‚¤ãƒˆã‚»ãƒ¼ãƒ•ã§ã™ã€‚ (MySQL 8.0.4 ã‚ˆã‚Šå‰ã§ã¯ã€MySQL ã¯ Henry Spencer ã«ã‚ˆã‚‹æ£è¦è¡¨ç¾ã®å®Ÿè£…ã‚’ä½¿ç”¨ã—ã¦ã„ã¾ã—ãŸã€‚ã“ã‚Œã¯ãƒã‚¤ãƒˆå˜ä½ã§å‹•ä½œã—ã€ãƒžãƒ«ãƒãƒã‚¤ãƒˆã‚»ãƒ¼ãƒ•ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ æ£è¦è¡¨ç¾ã‚’ä½¿ç”¨ã™ã‚‹ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒå®Ÿè£…ã®å¤‰æ›´ã®å½±éŸ¿ã‚’å—ã‘ã‚‹æ–¹æ³•ã®è©³ç´°ã¯ã€æ£è¦è¡¨ç¾ã®äº’æ›æ€§ã«é–¢ã™ã‚‹è€ƒæ…®äº‹é … ã‚’å‚ç…§ã—ã¦ãã ã•ã„ã€‚) expr NOT R
chanpon0 2011/03/11
sqlã§æ£è¦è¡¨ç¾æ›¸ã‘ã‚“ã®ã‹ã€‚çŸ¥ã‚‰ãªã‚“ã ã€‚ã€‚

SQL

æ£è¦è¡¨ç¾

mysql
ãƒªãƒ³ã‚¯
MySQLã®æœ€é©åŒ– | æ ªå¼ä¼šç¤¾ãƒ•ã‚©ãƒ¬ã‚¹ãƒˆãƒ»ã‚³ãƒ³ã‚µãƒ«ã‚¿ãƒ³ãƒ„
01/13 Re2:ã€Œç¦æ²¢è«å‰ã®æ£ä½“ã€ï¼è£œè¶³ï¼‘ï¼æ±å¤§è©±æ³•ã®å…ƒç¥–(å±±æ ¹æ²») 01/13 Re1:ã€Œç¦æ²¢è«å‰ã®æ£ä½“ã€ï¼è£œè¶³ï¼‘ï¼æ±å¤§è©±æ³•ã®å…ƒç¥–(Kan Yabumoto) 01/07 Re6: ãƒ›ãƒªã‚¨ãƒ¢ãƒ³ã®å¼è§£è¡“ ï¼ï¼‘(Smitha695) 01/07 Re1:è¬¹ã‚“ã§æ–°å¹´ã®ã”æŒ¨æ‹¶ã‚’ç”³ã—ä¸Šã’ã¾ã™(é ˆå¢—) 12/01 Re25: å€‰ç”°ã¾ã‚Šåäº‹ä»¶ã®çœŸç›¸ ï¼ãã®ï¼“(ãƒŠãƒžãƒŠãƒž) â€»ä»¥å‰åˆ¥ã®å ´æ‰€ã§æ›¸ã„ãŸæ–‡ç« ã‚’å‚™å¿˜çš„ã«æ›¸ãè¨˜ã—ã¦ãŠãã¾ã™ã€‚ å‡¦ç†é€Ÿåº¦æ”¹å–„ç‰ã«ã‚ãŸã£ã¦å®Ÿæ–½ã—ãŸMySQLã®æœ€é©åŒ–ã«ã¤ã„ã¦ãƒ¡ãƒ¢çš„ã«æ®‹ã—ã¦ãŠãã¾ã™ã€‚å¤§é‡ã®ãƒ‡ãƒ¼ã‚¿ã‚’æ‰±ã†SQLã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’è¨˜è¿°ã™ã‚‹éš›ã€å½¹ã«ç«‹ã¤ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚ å¯èƒ½ãªé™ã‚ŠSQLæ–‡ã¯å¾Œã‹ã‚‰ä¸€æ‹¬ã—ã¦å®Ÿè¡Œã€‚ LIMITã‚’ä½¿ã„ã€å‘¼ã³å‡ºã™ãƒ¬ã‚³ãƒ¼ãƒ‰æ•°ã‚’åˆ¶é™ã€‚ SELECTç‰ã«ãŠã„ã¦ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã‚’å‘¼ã³å‡ºã™éš›ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒã‚ã‚‹ã‚‚ã®ã‚’å„ªå…ˆã—ã¦æŒ‡å®šã€‚ ã‚½ãƒ¼ãƒˆã™ã‚‹å ´åˆã¯ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒã‚ã‚‹ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã‚’
chanpon0 2011/01/27
ãƒžãƒ«ãƒãƒ—ãƒ«insert æœ€å¾Œã®æ–‡å—å‰Šé™¤

SQL

mysql

insert
ãƒªãƒ³ã‚¯
BIGLOBEãªã‚“ã§ã‚‚ç›¸è«‡å®¤ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã›
ãªã‚“ã§ã‚‚ç›¸è«‡å®¤ ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› å¹³ç´ ã‚ˆã‚ŠBIGLOBEã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ BIGLOBEãªã‚“ã§ã‚‚ç›¸è«‡å®¤ã¯ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ã“ã‚Œã¾ã§ã”æ„›é¡§ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã—ãŸã€‚ ä»Šå¾Œã¯BIGLOBEãªã‚“ã§ã‚‚ç›¸è«‡å®¤ã®ãƒ‡ãƒ¼ã‚¿æä¾›å…ƒã§ã‚ã‚‹ã‚ªã‚¦ã‚±ã‚¤ã‚¦ã‚§ã‚¤ãƒ´ç¤¾ã®ã€ŒOKWAVEã€ã‚’ã”åˆ©ç”¨ãã ã•ã„ã€‚ ãªãŠBIGLOBEãªã‚“ã§ã‚‚ç›¸è«‡å®¤ã«ä¼šå“¡ç™»éŒ²ã•ã‚Œã¦ã„ãŸæ–¹ã¯ã€ç™»éŒ²ã•ã‚Œã¦ã„ãŸOKWAVE IDã‚’åˆ©ç”¨ã—ã¦ã€ŒOKWAVEã€ã«ãƒã‚°ã‚¤ãƒ³ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ ãƒã‚°ã‚¤ãƒ³ã«å¿…è¦ãªãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã¯12æœˆ2æ—¥ã«ã‚ªã‚¦ã‚±ã‚¤ã‚¦ã‚§ã‚¤ãƒ´ç¤¾ã‹ã‚‰ç™»éŒ²ãƒ¡ãƒ¼ãƒ«ã‚¢ãƒ‰ãƒ¬ã‚¹å®›ã«ãƒ¡ãƒ¼ãƒ«ã§é€šçŸ¥ã•ã‚Œã¾ã™ã€‚å½“æ—¥ã¯ãƒ¡ãƒ¼ãƒ«ã®åˆ°ç€ã¾ã§ãŠå¾…ã¡ãã ã•ã„ã€‚ 12æœˆ3æ—¥ã«ãªã£ã¦ã‚‚ãƒ¡ãƒ¼ãƒ«ãŒæ¥ãªã„å ´åˆã¯ä¸‹è¨˜ãƒšãƒ¼ã‚¸ã‹ã‚‰ãŠå•ã„åˆã‚ã›ãã ã•ã„ã€‚ï¼ˆã‚ªã‚¦ã‚±ã‚¤ã‚¦ã‚§ã‚¤ãƒ´ç¤¾ã®ãƒšãƒ¼ã‚¸ã«ç§»å‹•ã—ã¾ã™ï¼‰ ãƒ‘ã‚½ã‚³ãƒ³ç‰ˆ https://secure.okbiz.ok
chanpon0 2010/12/28
[try/catch]

mysql

SQL

PDO

transaction
ãƒªãƒ³ã‚¯
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã›
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
chanpon0 2010/12/02
é€Ÿåº¦ã€€é€Ÿã•

SQL

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°

db
ãƒªãƒ³ã‚¯
1 2 3 æ¬¡ã®ãƒšãƒ¼ã‚¸