[B! sql] nakamu_mã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

nakamu_m id:nakamu_m

sqlã«é–¢ã™ã‚‹nakamu_mã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (7)

${{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}}

Rã¨SQLã‚’å¯¾å¿œä»˜ã‘ã¦ã¿ãŸ - ã‚ã‚‰ã³ãæ—¥è¨˜
ã“ã®è¨˜äº‹ã¯ abicky.net ã® Rã¨SQLã‚’å¯¾å¿œä»˜ã‘ã¦ã¿ãŸ ã«ç§»è¡Œã—ã¾ã—ãŸ
nakamu_m 2012/08/10
sql

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

toread
ãƒªãƒ³ã‚¯
SQLã§é›†åˆæ¼”ç®—
ãƒ†ãƒ¼ãƒ–ãƒ«åŒå£«ã®ã‚³ãƒ³ãƒšã‚¢â€•é›†åˆã®ç›¸ç‰æ€§ãƒã‚§ãƒƒã‚¯ï¼šå¿œç”¨ç·¨ å‰ã®è§£æ³•ã§ã¯ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã®æ¯”è¼ƒã‚’ã™ã‚‹ã®ã«ã€äº‹å‰æº–å‚™ã¨ã—ã¦2ã¤ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã®è¡Œæ•°ã‚’èª¿ã¹ã¦ãŠãå¿…è¦ãŒã‚ã‚Šã¾ã—ãŸã€‚ãã‚Œã»ã©å¤§ããªæ‰‹é–“ã§ã¯ã‚ã‚Šã¾ã›ã‚“ãŒã€ã“ã®æº–å‚™ãªã—ã§ã€ã„ããªã‚Šç›¸ç‰æ€§ãƒã‚§ãƒƒã‚¯ã‚’è¡Œãˆã‚‹ã‚ˆã†ãªæ”¹è‰¯ç‰ˆã‚’è€ƒãˆã¾ã—ã‚‡ã†ã€‚ã‚µãƒ³ãƒ—ãƒ«ã¯ã€ã•ã£ãã®ã€Œtbl_Aã€ã¨ã€Œtbl_Bã€ã‚’ä½¿ã„ã¾ã™ã€‚ é›†åˆè«–ã§ã¯ã€ä¸€èˆ¬çš„ã«é›†åˆã®ç›¸ç‰æ€§ã‚’èª¿ã¹ã‚‹å…¬å¼ã¨ã—ã¦ã€ä»¥ä¸‹ã®2ã¤ãŒçŸ¥ã‚‰ã‚Œã¦ã„ã¾ã™ã€‚ (A âŠ† B ) ã‹ã¤ (A âŠ‡ B) â‡’ (A = B) (A âˆª B ) = (A âˆ© B) â‡’ (A = B) 1ç•ªã®æ–¹æ³•ã¯ã€é›†åˆã®åŒ…å«é–¢ä¿‚ã‚’ã‚‚ã¨ã«ç›¸ç‰æ€§ã‚’èª¿ã¹ã‚‹æ–¹æ³•ã§ã™ã€‚ã€ŒAãŒBã‚’å«ã¿ã€ã‹ã¤BãŒAã‚’å«ã‚€ãªã‚‰ã€ä¸¡è€…ã¯ç‰ã—ã„ã€ã¨ã„ã†æ„å‘³ã§ã™ã€‚ã“ã‚Œã‚’åˆ©ç”¨ã™ã‚‹ã“ã¨ã‚‚å¯èƒ½ã§ã™ãŒã€å°‘ã—é¢å€’ã§ã™ï¼ˆã“ã®æ–¹æ³•ã«ã¤ã„ã¦ã¯ã€å¾Œã®ä¾‹é¡Œã§è§¦ã‚Œã¾ã™ï¼‰ã€‚ ä¸€æ–¹ã€2ç•ªã®æ–¹æ³•ã¯ã€é›†åˆã®å’Œã¨äº¤å·®ã‚’ã‚‚ã¨ã«ç›¸ç‰æ€§ã‚’
nakamu_m 2012/08/09
sql

tipcs
ãƒªãƒ³ã‚¯
SQLã«ã‚ˆã‚‹æ•°ç‹¬ã®è§£æ³•
ã¯ã˜ã‚ã« SQLã‚’ä½¿ã£ã¦æ•°ç‹¬ï¼ˆãƒŠãƒ³ãƒ—ãƒ¬ï¼‰ã‚’è§£ãæ–¹æ³•ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ“ä½œã™ã‚‹ãŸã‚ã®è¨€èªžã§ã‚ã‚‹SQLã‚’åˆ¥ã®ç”¨é€”ã«ä½¿ãŠã†ã¨ã™ã‚‹ç†ç”±ã¯ã€SQLãŒå®£è¨€çš„ãªè¨˜è¿°ãŒå¯èƒ½ãªè¨€èªžã®ä¸ã§æœ€ã‚‚æ™®åŠã—ã¦ã„ã‚‹ã¨æ€ã‚ã‚Œã‚‹ã‹ã‚‰ã§ã™ï¼ˆå®£è¨€çš„è¨€èªžã¨è¨€ãˆã°Prologã‚’æ€ã„æµ®ã‹ã¹ã‚‹æ–¹ã‚‚å¤šã„ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ãŒã€æ®‹å¿µãªã“ã¨ã«Prologã¯ã€SQLã»ã©ã«ã¯æ™®åŠã—ã¦ã„ã¾ã›ã‚“ï¼‰ã€‚ ã¾ãšã€å®£è¨€çš„ãªè¨˜è¿°ã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã—ã‚‡ã†ã€‚ã‚¿ã‚¯ã‚·ãƒ¼ã«ä¹—ã‚‹ã“ã¨ã‚’æƒ³åƒã—ã¦ãã ã•ã„ã€‚ã€Œæ¸‹è°·ã«è¡Œã£ã¦ãã ã•ã„ã€ã¨ã„ã†ã‚ˆã†ã«ã€æ¬²ã—ã„çµæžœã‚’æ›¸ãã®ãŒå®£è¨€çš„ãªè¨˜è¿°ã§ã™ã€‚å…·ä½“çš„ãªé“ç‹ã¯é‹è»¢æ‰‹ãŒè€ƒãˆã¦ãã‚Œã¾ã™ã€‚ãã‚Œã«å¯¾ã—ã¦ã€Œã¾ãšAé€šã‚Šã‚’åŒ—ã«è¡Œã£ã¦ã€Bäº¤å·®ç‚¹ã‚’å·¦æŠ˜ã—ã¦ãƒ»ãƒ»ãƒ»ã€ã¨ã„ã†ã‚ˆã†ã«ã€å…·ä½“çš„ãªé“ç‹ã‚’ç¤ºã™ã®ã¯æ‰‹ç¶šãçš„è¨˜è¿°ã§ã™ã€‚ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžã®å ´åˆã‚‚åŒæ§˜ã§ã™ã€‚SQLã‚„Prologã«ãŠã„ã¦ã¯ã€æ¬²ã—ã„çµæžœã‚’ãƒ—ãƒã‚°ãƒ©ãƒžãŒæ›¸ã‘ã°ã€å…·ä½“çš„ãªå®Ÿç¾æ–¹æ³•ã¯ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿ãŒè€ƒãˆã¦
nakamu_m 2012/07/09
toread

sql
ãƒªãƒ³ã‚¯
cut, sort, uniq ã§ç”Ÿç”£æ€§ã‚’5%å‘ä¸Šã•ã›ã‚‹ - bonar note
ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã€ç‰¹ã«ã‚¦ã‚§ãƒ–ç³»ã®ãŠä»•äº‹ã‚’ã—ã¦ã„ã‚‹ã¨ã€ã„ã‹ã« windows ã‚„ mac ãŒå¥½ãã§ã‚‚ linux ã‚„ BSDï¼ˆmac ã‚‚ä»Šã‚„ BSD ã§ã™ãŒã€ã€ï¼‰ã§ä½œæ¥ã™ã‚‹æ™‚é–“ãŒåœ§å€’çš„ã«é•·ããªã‚Šã¾ã™ã‚ˆãã€‚ã—ã‹ã‚‚å¤§æŠµã®å ´åˆ X ã‚‚ãªã„ CUI ãªç’°å¢ƒã§å»¶ã€…ä½•æ™‚é–“ã‚‚ä½œæ¥ã™ã‚‹ã‚ã‘ã§ã™ã€‚ ã§ã€åƒ•ã ã‘ã‹ã‚‚ãªã®ã§ã™ãŒã€ãã®æ™‚é–“ã®ã»ã¨ã‚“ã©ã¯ã€Œãƒ†ã‚ã‚¹ãƒˆå‡¦ç†ã€ã«ã‚ã¦ã‚‰ã‚Œã‚‹ã‚ã‘ã§ã™ã€‚TSV ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ç‰¹å®šã®é …ç›®ã§ä¸¦ã¹æ›¿ãˆãŸã‚Šã€ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ã‹ã‚‰ä½•ã‹ã®é …ç›®ã‚’æŠœãå‡ºã—ã¦(UA ã¨ã‹)ã€ãã‚Œã‚’ç¨®é¡žã”ã¨ã«ã‚«ã‚¦ãƒ³ãƒˆã—ã¦ã‚½ãƒ¼ãƒˆã—ã¦å‡ºã—ãŸã‚Šã€‚ ãã‚“ãªè¨³ã§ UNIXç’°å¢ƒã§ perl ã‚„ sedã€awk ç‰ã®æ–‡å—åˆ—å‡¦ç†ãŒå¾—æ„ãªã‚¹ã‚¯ãƒªãƒ—ãƒˆè¨€èªžã‚’è‰¯ãä½¿ã†ã‚ˆã†ã«ãªã‚Šã¾ã™ã‚ˆãã€‚ã¡ã‚‡ã£ã¨ã—ãŸã‚‚ã®ã§ã‚ã‚Œã° perl ã§çŸã„ã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’æ›¸ã„ã¦ã—ã¾ãˆã°OKãªã®ã§ã™ãŒã€ã‚ã‚‰ã‹ã˜ã‚å…¥ã£ã¦ã„ã‚‹ã‚³ãƒžãƒ³ãƒ‰ã‚’ä½¿ã†ã ã‘ã§ã‚‚ç›¸å½“ã®äº‹ãŒã§ãã‚‹ãªã‚ã¨æœ€è¿‘æ€ã£ãŸã®ã§ãƒ¡ãƒ¢ã§ã™
nakamu_m 2012/05/30
linux

sql

tips
ãƒªãƒ³ã‚¯
WWW SQL Designer
* * * * * * *
nakamu_m 2012/05/22
sql

tool

webapp

mysql

work
ãƒªãƒ³ã‚¯
MySQLã‚¯ã‚¤ãƒƒã‚¯ãƒ»ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹
ã“ã®æ–‡æ›¸ã¯ã€osCommerceã§ä½¿ç”¨ã—ã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹MySQLã®åŸºæœ¬çš„ãªä½¿ã„æ–¹ã«ã¤ã„ã¦è§£èª¬ã—ã¦ã„ã¾ã™ã€‚ãŠã‚‚ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ç®¡ç†è€…ã‚ˆã‚Šã‚‚ã€ãƒ¦ãƒ¼ã‚¶ã«å‘ã‘ã¦æ›¸ã‹ã‚Œã¦ã„ã¾ã™ã€‚ ã¯ã˜ã‚ã« ã“ã“ã§ã¯ã€MySQLã‚µãƒ¼ãƒã¯èµ·å‹•ã—ã¦ã„ã‚‹ã‚‚ã®ã¨ã—ã¦èª¬æ˜Žã—ã¾ã™ã€‚ MySQLã®æ–‡å—ã«ã¤ã„ã¦ MySQLã§ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åã‚„ãƒ†ãƒ¼ãƒ–ãƒ«åã®å¤§æ–‡å—ã¨å°æ–‡å—ã‚’åŒºåˆ¥ã—ã¦ã„ã¾ã™ã€‚ãã‚Œä»¥å¤–ã¯åŒºåˆ¥ã—ã¾ã›ã‚“ã€‚ MySQLã®ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰åã‚„ãƒ†ãƒ¼ãƒ–ãƒ«åã«ä½¿ãˆã‚‹æ–‡å—ã¯ã€è‹±æ•°å—ã¨_ï¼ˆã‚¢ãƒ³ãƒ€ãƒ¼ãƒãƒ¼ï¼‰ã€$ã€ã‚µãƒ¼ãƒã®ã‚ãƒ£ãƒ©ã‚¯ã‚¿ã‚»ãƒƒãƒˆã«ã‚ã‚‹æ–‡å—ã§ã™ã€‚ çŸ¥ã£ã¦ãŠããŸã„ã‚³ãƒžãƒ³ãƒ‰ mysqladminï¼ˆãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä½œæˆãƒ»å‰Šé™¤ã‚„ã€MySQLã‚µãƒ¼ãƒã®æƒ…å ±ã‚’å¾—ã‚‹ï¼‰ mysqlshowï¼ˆãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã®æƒ…å ±ã‚’è¡¨ç¤ºã™ã‚‹ï¼‰ mysqlï¼ˆMySQLã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã®èµ·å‹•ï¼‰ mysqldumpï¼ˆãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ãƒ€ãƒ³ãƒ—ã™ã‚‹ï¼‰ myisamchkï¼ˆãƒ†ãƒ¼ãƒ–ãƒ«
nakamu_m 2012/05/21
sql

db

cheatsheet
ãƒªãƒ³ã‚¯
1