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

yanbow id:yanbow

sqlã¨SQLã«é–¢ã™ã‚‹yanbowã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (5)

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

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

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
MySQLã®è¤‡åˆINDEX - æ†‚é¬±ãªãƒ—ãƒã‚°ãƒ©ãƒžã®å½¢è€Œä¸Šå¦
MySQL MySQLã®è¤‡åˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã¤ã„ã¦ã€‚MySQLã‚’ä½¿ã„ã“ãªã—ã¦ã„ã‚‹äººã«ã¯å¸¸è˜ã®ç¯„ç–‡ã«ã¯ã„ã‚‹çŸ¥è˜ã ã¨æ€ã†ã®ã§ã™ãŒã€ã‹ã¤ã¦ã®ç§ã®ã‚ˆã†ã«ã€çŸ¥ã‚‰ãªã„ã¨ãƒ‰ãƒ„ãƒœã«ã¯ã¾ã‚‹ã®ã§ã€ã“ã“ã«ã¾ã¨ã‚ã¦ãŠãã¾ã™ã€‚ã‚¿ã‚¤ãƒˆãƒ«ã§ã©ã†ã„ã†å†…å®¹ã‹ã€ã‚‚ã—ã‹ã—ãŸã‚‰å¤§ä½“ã€æƒ³åƒãŒã¤ãã‹ãªã¨æ€ã†ã®ã§ã™ãŒã€MySQLã¯1ã¤ã®ã‚¯ã‚¨ãƒªãƒ¼ã§1ã¤ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã«å¯¾ã—ã€1ã¤ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã—ã‹æ©Ÿèƒ½ã—ãªã„ã¨ã„ã†ã“ã¨ã§ã™ã€‚ã‚ˆã†ã™ã‚‹ã«ã€ã‚ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ã«å¯¾ã—ã¦ã€æ™®é€šã«å¤§é‡ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’å¼µã£ã¦ã‚‚ã‚ã¾ã‚Šæ„å‘³ãŒã‚ã‚Šã¾ã›ã‚“ã€‚ãã“ã§ã€ä»Šå›žã¯ã€æœ€é©ãªè¤‡åˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯ã©ã®ã‚ˆã†ã«ã—ã¦ã¯ã‚‹ã“ã¨ãŒã§ãã‚‹ã‹è€ƒãˆã¦ã„ã“ã†ã˜ã‚ƒãªã„ã‹ã€ã¨ã„ã†è¶£æ—¨ã§æ›¸ã„ã¦ã„ããŸã„ã¨æ€ã„ã¾ã™ã€‚ã¾ãšã¯åˆ†æžã€‚ãƒ†ã‚¹ãƒˆç’°å¢ƒã§ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒä½¿ã‚ã‚Œã¦ã„ãªã„SQLã‚’é›†ã‚ã‚‹ã¾ãšã¯ã€/etc/my.cnfã®ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã‚’ä»¥ä¸‹ã®ã‚ˆã†ã«è¨å®šã—ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒä½¿ã‚ã‚Œã¦ã„ãªã„SQLã‚’ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªãƒ¼ã«åãå‡ºã—ã¾ã™ã€‚ slow
yanbow 2014/09/26
sql

mysql

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
SQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ - é–‹ç™ºè€…ã‚’å¾…ã¡å—ã‘ã‚‹25ã®è½ã¨ã—ç©´ (æ‹¡å¤§ç‰ˆ)
14. SELECT c1.*, c2.*, c3.*, c4.* FROM Comments c1 -- 1éšŽå±¤ç›® LEFT OUTER JOIN Comments c2 ON c2.parent_id = c1.comment_id -- 2éšŽå±¤ç›® LEFT OUTER JOIN Comments c3 ON c3.parent_id = c2.comment_id -- 3éšŽå±¤ç›® LEFT OUTER JOIN Comments c4 ON c4.parent_id = c3.comment_id -- 4éšŽå±¤ç›® ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã«ã‚ˆã‚Šèµ·ã“ã‚‹ã“ã¨ ç´ æœ´ã™ãŽã‚‹æ•…ã« ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³
yanbow 2013/04/23
ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³

SQL

db
ãƒªãƒ³ã‚¯
CakePHPã®é˜²å¾¡åŠ›ã‚’è©¦ã™1ã€œSQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã€œ - ã™ãŸã‚‰æ—¥è¨˜
ã€CakePHP 1.3.2ã€‘ CakePHPã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®çŠ¶æ…‹ã§ã€ã©ã“ã¾ã§ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£å¯¾ç–ãŒ æ–½ã•ã‚Œã¦ã„ã‚‹ã®ã‹ã‚’å®Ÿé¨“ã—ã¾ã™ã€‚ ã€å®Ÿé¨“æ–¹æ³•ã€‘ãƒ‡ãƒãƒƒã‚°ã‚’"2"ã«è¨å®šã—ã€äºˆæƒ³ã•ã‚Œã‚‹æ”»æ’ƒã«ã‚ˆã£ã¦ã©ã®ã‚ˆã†ãª SQLãŒç”Ÿæˆã•ã‚Œã‚‹ã®ã‹ã‚’ç¢ºèªã—ã¾ã™ã€‚ ã€/app/config/core.phpã€‘ Configure::write('debug', 2); 1. SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ ã€å®Ÿé¨“ç’°å¢ƒã€‘ä¸‹è¨˜ã®3ã¤ã®ãƒ¡ã‚½ãƒƒãƒ‰ã«ã¤ã„ã¦ã€CakePHPã®å¯¾å¿œã‚’è¦‹ã¦ã¿ã¾ã™ã€‚ read() find() findById() ã€ã‚³ãƒ³ãƒˆãƒãƒ¼ãƒ©ã€‘ function view($id){ //ã€1ã€‘ $this->data = $this->User->read(null, $id); //ã€2ã€‘ $this->data = $this->User->find('first', array('conditions'=>arr
yanbow 2010/07/15
CakePHP

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

sql
ãƒªãƒ³ã‚¯
ãƒ©ãƒ³ã‚ãƒ³ã‚°ã‚’å–å¾—ã™ã‚‹SQL | Sun Limited Mt.
ãƒ©ãƒ³ã‚ãƒ³ã‚°ã‚’å–å¾—ã™ã‚‹SQL ã§ã™ã€‚ åŒã˜ã‚¹ã‚³ã‚¢ã®å ´åˆã¯åŒã˜é †ä½ã«ã™ã‚‹ãªã©ã®å¿…è¦ãŒã‚ã‚‹ãŸã‚çµæ§‹é¢å€’ã§ã™ãŒã€ ä¸‹è¨˜SQL ã§ã‚¤ãƒƒãƒ‘ãƒ„ã§å–å¾—ã§ãã¾ã™ã€‚ å®Ÿéš›ã«æºå¸¯ã‚²ãƒ¼ãƒ ã®ãƒ©ãƒ³ã‚ãƒ³ã‚°ã‚’å–å¾—ã™ã‚‹ã®ã«ä½¿ç”¨ã—ã¦ã„ã‚‹SQLã§ã™ã€‚ ranking ãƒ†ãƒ¼ãƒ–ãƒ« CREATE TABLE ranking ( id bigint(20) NOT NULL auto_increment, name varchar(20) NOT NULL, score bigint(20) NOT NULL, ); SQL SELECT r1.name, r1.score, (SELECT count(r2.score) FROM ranking as r2 WHERE r2.score>r1.score)+1 as rank FROM ranking as r1 ORDER BY r1.score DESC LIMIT 10; r
yanbow 2010/06/25
sql

ãƒ©ãƒ³ã‚ãƒ³ã‚°

MySQL
ãƒªãƒ³ã‚¯
1