[B! MySQL][db] sometkã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

sometk id:sometk

MySQLã¨dbã«é–¢ã™ã‚‹sometkã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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}}

DBT-2 ã§ MySQL ã¨ä»–ã®RDBMSã®æ€§èƒ½æ¯”è¼ƒã‚’ã—ã¦ã„ã‚‹äººã«é¨™ã•ã‚Œãªã„ã‚ˆã†ã«æ³¨æ„
ä¸€å¿œã€ç«‹å ´çš„ã«ã¯ç¬¬ä¸‰è€…ã«æˆ»ã£ãŸ(MySQL/InnoDBã®æ€§èƒ½è¿½æ±‚ãŒä»•äº‹ã§ã¯ãªã„)ã®ã§ã€å¿˜ã‚Œã‚‰ã‚Œãªã„æš—ã„éŽåŽ»ã«ã‚‚è§¦ã‚Œã¦ã¿ã‚ˆã†ã¨æ€ã„ã¾ã™ã€‚ æœªã ã«é¨™ã•ã‚Œã¦ã„ã‚‹äººãŒå¤šã„ã¿ãŸã„ãªã®ã§ã€MySQL/InnoDBã®åèª‰ã®ãŸã‚ã«æ›¸ãæ®‹ã•ãªã‘ã‚Œã°ãªã‚Šã¾ã›ã‚“ã€‚ä½•åº¦ã§ã‚‚è¨€ã„ã¾ã™ãŒã€æ€§èƒ½æ¯”è¼ƒã¯è‡ªåˆ†ã®ç›®çš„ã¨ã™ã‚‹å‡¦ç†ã‚’ã¡ã‚ƒã‚“ã¨æ¯”è¼ƒã—ãªã„ã¨ã ã‚ã§ã™ã€‚ãã†ã§ãªãã¦ã¯ã€é¨™ã•ã‚Œã¦æœ¬å½“ã¯æ‚ªã„æ€§èƒ½ã®ã‚‚ã®ã‚’æŽ´ã¾ã•ã‚Œã‚‹ã“ã¨ã«ãªã‚Šã¾ã™ã€‚ DBT-2ã¨è¨€ã†(TPC-Cã‚’ãƒ™ãƒ¼ã‚¹ã«ã—ãŸ)ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ãŒã‚ã‚Šã¾ã™ãŒã€æ•°å¤šã®RDBMS(å•†ç”¨/OSSåŒæ–¹)ã«å¯¾ã—ã¦ç‹¬è‡ªã«TPC-Cãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã‚’å®Ÿè£…ãƒ»ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã—ã¦æ¯”è¼ƒã—ãŸçµŒé¨“ã®ã‚ã‚‹ç§ã‹ã‚‰è¦‹ã¦ã€æ€ªã—ã„çµæžœã—ã‹å‡ºãªã„ã®ã§ã€é•·å¹´ã€åŸºæœ¬ç„¡è¦–ã®ã‚¹ã‚¿ãƒ³ã‚¹ã‚’å–ã£ã¦ã„ã¾ã™ã€‚ ãŒã€ï¼“å¹´å‰ã«ã‚ã‚ã†ã“ã¨ã‹MySQLã®æ€§èƒ½QAãŒDBT-2(nonsp:mysql)ã‚’åˆ©ç”¨ã—ã¦ã„ã¦ã€ã¨ã‚ã‚‹æ€§èƒ½FIXã«å¯¾ã—ã¦å•é¡Œã‚’æŒ‡æ‘˜ã—ã¦
sometk 2015/07/06
1507

database

db

mysql

bench
ãƒªãƒ³ã‚¯
å‰Šé™¤ãƒ•ãƒ©ã‚°ã®ã¯ãªã—
6. id name pass is_deleted 1 ryu xxx FALSE 2 ken xxx FALSE 3 honda xxx TRUE 8. id name pass is_deleted 1 ryu xxx FALSE 2 ken xxx FALSE 3 honda xxx TRUE 3 honda xxx FALSE
sometk 2011/08/10
1108

DB

database

postgresql

SQL

MySQL
ãƒªãƒ³ã‚¯
PHP & MySQL - phpspot
PHPã¨åŒæ™‚ã«ã‚ˆãä½¿ã‚ã‚Œã‚‹MySQLã®ä½¿ã„æ–¹ã«ã¤ã„ã¦ã®èª¬æ˜Žã§ã™ã€‚ ä¸»ã«UNIXã§ã®ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³æ“ä½œã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚ MySQL4.1ã§ã®æ–‡å—åŒ–ã‘å¯¾ç–ã«ã¤ã„ã¦ã‚‚ã€‚ ã“ã®ãƒšãƒ¼ã‚¸ã®è¨˜äº‹ã¯MySQL4.1ã‚’ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦è¨˜è¿°ã•ã‚Œã¦ã„ã¾ã™ã€‚ æœ€æ–°ç‰ˆã¯5.5ç³»ã«ãªã‚Šã¾ã™ã®ã§ã”æ³¨æ„(2010/12) SQLãŒè‰¯ãåˆ†ã‹ã‚‰ãªã„æ–¹ã¯ã“ã¡ã‚‰ PHP+MySQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æ“ä½œ 1. ï¼³ï¼±ï¼¬å®Ÿè¡Œ 2. ãƒ‡ãƒ¼ã‚¿ã‚’æ¤œç´¢ 3. æ¤œç´¢ã—ãŸãƒ‡ãƒ¼ã‚¿ã®ä»¶æ•°ã‚’å¾—ã‚‹ 4. prepareã¨executeã§DBæ“ä½œ MySQLåŸºæœ¬(UNIXä¸Šã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ã§ã®æ“ä½œ) 1. MySQLã‚µãƒ¼ãƒã‚’èµ·å‹•ã™ã‚‹ 2. MySQLã‚µãƒ¼ãƒã‚’åœæ¢ã™ã‚‹ 3. ã‚µãƒ¼ãƒã®èµ·å‹•ã‚’ç¢ºèªã™ã‚‹ 4. ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã§æ“ä½œ 1. MySQLã®çŠ¶æ…‹ã‚’è¡¨ç¤º 2. ä½¿ã†ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åˆ‡æ›¿ 3. SQLã®å®Ÿè¡Œã‚’ã‚ãƒ£ãƒ³ã‚»ãƒ« 4. ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ä¸€è¦§è¡¨ç¤º 5. ãƒ†ãƒ¼ãƒ–ãƒ«ä¸€è¦§è¡¨ç¤º
sometk 2011/07/29
MySQL

DB

php

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

DB

database

SQL

sequence

MySQL
ãƒªãƒ³ã‚¯
IDEA * IDEA
ãƒ‰ãƒƒãƒˆã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ä»£è¡¨ã®ãƒ©ã‚¤ãƒ•ãƒãƒƒã‚¯ãƒ–ãƒã‚°
sometk 2011/05/01
DB

database

sql

mysql

join

tips
ãƒªãƒ³ã‚¯
1