[B! sql] u-ichiã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

u-ichi id:u-ichi

sqlã«é–¢ã™ã‚‹u-ichiã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (33)

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

RDBMSã‚’ãƒ–ãƒ©ãƒƒã‚¯ãƒœãƒƒã‚¯ã‚¹ã«ã—ãªã„ï¼šITpro
è¤‡æ•°ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã®åŒæ™‚å®Ÿè¡Œç·¨ ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãŒè¤‡æ•°åŒæ™‚ã«å®Ÿè¡Œã•ã‚Œã‚‹æ™‚ï¼ŒRDBMSã¯ã©ã®ã‚ˆã†ãªä»•çµ„ã¿ã§ï¼Œãã‚Œãžã‚Œã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã®ç‹¬ç«‹æ€§ã‚’ä¿ã¤ã®ã‹ã‚’èª¬æ˜Žã—ã¾ã™ã€‚ã“ã‚Œã‚’ç†è§£ã™ã‚‹ã“ã¨ã«ã‚ˆã‚Šï¼Œã•ã‚‰ã«è‰¯ã„ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å‡¦ç†ã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’é–‹ç™ºã™ã‚‹ã“ã¨ãŒã§ãã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚ ç›®æ¬¡ ç¬¬1å›žã€€ã»ã‹ã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‹ã‚‰ã®å½±éŸ¿ ç¬¬2å›žã€€1ç•ªã‚†ã‚‹ã„åˆ†é›¢ãƒ¬ãƒ™ãƒ«ï¼ˆãƒªãƒ¼ãƒ‰ã‚¢ãƒ³ã‚³ãƒŸãƒƒãƒ†ã‚£ãƒ‰ï¼‰ ç¬¬3å›žã€€2ç•ªç›®ã«ã‚†ã‚‹ã„åˆ†é›¢ãƒ¬ãƒ™ãƒ«ï¼ˆãƒªãƒ¼ãƒ‰ã‚³ãƒŸãƒƒãƒ†ã‚£ãƒ‰ï¼‰ ç¬¬4å›žã€€3ç•ªç›®ã«ã‚†ã‚‹ã„åˆ†é›¢ãƒ¬ãƒ™ãƒ«ï¼ˆãƒªãƒ”ãƒ¼ã‚¿ãƒ–ãƒ«ãƒªãƒ¼ãƒ‰ï¼‰ ç¬¬5å›žã€€1ç•ªãã¤ã„åˆ†é›¢ãƒ¬ãƒ™ãƒ«ï¼ˆã‚·ãƒªã‚¢ãƒ©ã‚¤ã‚¶ãƒ–ãƒ«ï¼‰ æ›´æ–°å‡¦ç†ã¨ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ç·¨ ã€ŒRDBMSã®æ›´æ–°å‡¦ç†ã¨ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã®é–¢ä¿‚ã¯é›£ã—ã„ã€â€•â€•ã€‚ã“ã†æ€ã£ã¦ã„ã‚‹èªè€…ã®æ–¹ã¯å°‘ãªããªã„ã§ã—ã‚‡ã†ã€‚ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’é–‹ç™ºã™ã‚‹ã ã‘ãªã‚‰ï¼Œæ›´æ–°å‡¦ç†ã¨ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã®é–¢ä¿‚ã‚’ãã¡ã‚“ã¨ç†è§£ã—ã¦ã„ãªãã¦ã‚‚ï¼Œã€Œè¦‹ã‚ˆã†è¦‹ã¾ãã€ã®é–‹
u-ichi 2007/11/30
sql
ãƒªãƒ³ã‚¯
InnoDB ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° - MySQLã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹2007 - akiyan.com ç®¡ç†äººãƒ¡ãƒ¢
http://www.mysql-ucj2007.jp/details/j25.html æœ¨ä¸‹ é–æ–‡ æ° NTTã‚³ãƒ ã‚¦ã‚§ã‚¢æ ªå¼ä¼šç¤¾ ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆç®¡ç†çµ±æ‹¬éƒ¨æŠ€è¡“SEéƒ¨é–€ DB æŠ€è¡“ã‚°ãƒ«ãƒ¼ãƒ— ï¼ˆã€ŒInnoDBã€ã¯ã€Œã„ã‚“ã®ã§ãƒ¼ã³ãƒ¼ã€ã¨è¨€ã†ã‚‰ã—ã„...ä»Šã¾ã§ã€Œã„ã®ã§ãƒ¼ã³ãƒ¼ã€ã¨è¨€ã£ã¦ã¾ã—ãŸï¼‰ InnoDBã‚’ãªãœä½¿ã†ã‹ ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ ã‚³ãƒŸãƒƒãƒˆã€ãƒãƒ¼ãƒ«ãƒãƒƒã‚¯ã€ã‚»ãƒ¼ãƒ–ãƒã‚¤ãƒ³ãƒˆ å¤–éƒ¨ã‚ãƒ¼ è¡Œãƒ¬ãƒ™ãƒ«ãƒãƒƒã‚¯ ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— ã‚¯ãƒ©ãƒƒã‚·ãƒ¥ãƒªã‚«ãƒãƒª ã‚¯ãƒ©ãƒƒã‚·ãƒ¥ãƒªã‚«ãƒãƒª MyISAMã¯ãƒ‡ãƒ¼ã‚¿é‡ã®å¢—å¤§ã¨ã¨ã‚‚ã«æ™‚é–“ãŒã‹ã‹ã‚‹ InnoDBã¯ãƒ‡ãƒ¼ã‚¿é‡ã®å¢—å¤§ã¨ã®ç›¸é–¢ãŒãªã„ InnoDBãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®çŽ‹é“çš„ã‚¢ãƒ—ãƒãƒ¼ãƒ ã‚¯ã‚¨ãƒªã‚’æ”¹å–„ã—ã¦å…¨ä½“çš„ã«å‡¦ç†åŠ¹çŽ‡ã‚’ä¸Šã’ã‚‹ ãƒ‡ãƒ¼ã‚¿ã‚µã‚¤ã‚ºã‚’ã§ãã‚‹ã ã‘å°ã•ã ãƒ¡ãƒ¢ãƒªã‚’ã§ãã‚‹ã ã‘å¤šãç©ã‚€ ã‚³ãƒŸãƒƒãƒˆæ€§èƒ½ï¼ˆåŒæœŸæ›¸ãè¾¼ã¿ï¼‰ innodb_flush_log_at_trx_commit=1,0,2
u-ichi 2007/09/13
sql

performance

*server
ãƒªãƒ³ã‚¯
MySQL : å¤–éƒ¨ã‹ã‚‰ã®æŽ¥ç¶šè¨å®š
å…¨ã¦ã® ãƒ›ã‚¹ãƒˆã‹ã‚‰æŽ¥ç¶šã§ãã‚‹ã‚ˆã†ã«ã™ã‚‹ã«ã¯ã€ä»¥ä¸‹ã® SQL ã‚’å®Ÿè¡Œã—ã¾ã™ grant all privileges on *.* to root@'%' â€» MySQL5.1 ã§ã¯ã€åˆæœŸã«ä½œæˆã•ã‚Œã¦ã„ã‚‹ USER è¡¨ã¯ localhost,root ã®ã¿ã®ã‚ˆã†ã§ã™ã€‚ â€» ã¾ãŸã€ä¸Šè¨˜ grant æ–‡ã« ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰æŒ‡å®šã—ãªã„ã¨ã€å®Ÿè¡Œã‚¨ãƒ©ãƒ¼ã«ãªã‚Šã¾ã™ã€‚ ãã®éš›ã®æ§‹æ–‡è©³ç´°ã¯ ã“ã¡ã‚‰
u-ichi 2007/08/26
sql

*server
ãƒªãƒ³ã‚¯
livedoor Techãƒ–ãƒã‚° : MySQL Proxy ã‚’è©¦ã—ã¦ã¿ã¾ã—ãŸ
ã“ã‚“ã«ã¡ã¯ã€‚é‡‘åã§ã™ã€‚ å…ˆæ—¥ã€ç¤¾å†…å‹‰å¼·ä¼šã§ MySQL Proxy ã‚’å–ã‚Šä¸Šã’ã¾ã—ãŸã€‚ãã®éš›ã¾ã¨ã‚ãŸè³‡æ–™ã‚’ã€ä¸€éƒ¨åŠ ç†ä¿®æ£ã—ã¦å…¬é–‹ã—ã¾ã™ã€‚ æœ€åˆã«ãŠè©«ã³ å¤§å…ƒã®æ–‡ç« ã‚’æ›¸ã„ãŸã®ãŒ 2007 å¹´ã® 7 æœˆãªã®ã§ã€å†…å®¹ãŒå°‘ã—å¤ã„ã§ã™ã€‚ã“ã‚Œã‚’æ›¸ããªãŒã‚‰æœ€æ–°ç‰ˆã‚’ãƒã‚§ãƒƒã‚¯ã‚¢ã‚¦ãƒˆã—ã¦ãã¦å†æ¤œè¨¼ã—ãŸã‹ã£ãŸã®ã§ã™ãŒã€ãƒ¬ãƒã‚¸ãƒˆãƒªãŒãƒ€ã‚¦ãƒ³ã—ã¦ã„ã¦æœ€æ–°ã®ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã‚’å…¥æ‰‹ã§ãã¾ã›ã‚“ã§ã—ãŸã€‚ãªã®ã§ã€ä¸€ãƒ¶æœˆå‰ã®ãƒªãƒ“ã‚¸ãƒ§ãƒ³(rev.116) æ™‚ç‚¹ã§ã®ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ + äºŒé€±é–“ãã‚‰ã„å‰ã«ãƒ¬ãƒã‚¸ãƒˆãƒªã‚’è¦—ã„ãŸã¨ãã®è¨˜æ†¶ã®ã¿ã§æ›¸ã„ã¦ãŠã‚Šã€ã„ã‚ã„ã‚é–“é•ã£ã¦ã„ã‚‹ãŠãã‚ŒãŒã‚ã‚‹ã®ã§ã€ã¿ãªã•ã‚“æ˜¯éžè‡ªåˆ†ã§ã‚³ãƒ³ãƒ‘ã‚¤ãƒ«ã—ã¦è©¦ã—ã¦ã¿ã¦ãã ã•ã„(æ³¨æ„!ãŸã ã§ã•ãˆã¤ãªãŒã‚Šã«ãã„ã®ã§ã€ã“ã®ã‚¨ãƒ³ãƒˆãƒªã‚’å…¨éƒ¨èªã‚“ã§ä¸€é€±é–“å¾Œã«ã¾ã MySQL Proxy ã®ã“ã¨ã‚’è¦šãˆã¦ã„ãŸäººã ã‘ãƒ¬ãƒã‚¸ãƒˆãƒªã«ã‚¢ã‚¯ã‚»ã‚¹ã—ã¦ãã ã•ã„ã) æ°—ã®æ—©ã„äººå‘ã‘ã®çµè«– ã¾ã å®Ÿè·µæŠ•å…¥ã™ã‚‹ã«ã¯åŽ³ã—
u-ichi 2007/08/21
sql

#tips

*server
ãƒªãƒ³ã‚¯
MySQLã®ã‚·ã‚¹ãƒ†ãƒ ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ï¼šCodeZine
SQLã‚’ä½¿ã†æ¥å‹™ã§ã¯åˆ†æžé–¢æ•°ã‚’ä½¿ã„ã“ãªã™ã¨ã€ç”Ÿç”£æ€§ã¨SQLã®å¯èªæ€§ã¨ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’ã€å¤§ããå‘ä¸Šã•ã›ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚åˆ†æžé–¢æ•°ã‚’ä½¿ã†éš›ã®è€ƒãˆæ–¹ã¨ã€å‡¦ç†ã®ã‚¤ãƒ¡ãƒ¼ã‚¸ã‚’è§£èª¬ã—ã¾ã™ã€‚ä»Šå›žã¯ç·é›†ç·¨ã¨ã—ã¦ã€å‰ç·¨ã€ä¸ç·¨ã€å¾Œç·¨ã€å®Œçµç·¨ã«é–¢é€£ã—ãŸå†…å®¹ã‚’æ‰±ã„ã¾ã™ã€‚
u-ichi 2007/08/10
sql

#study

*program

*server
ãƒªãƒ³ã‚¯
MySQLã®çŠ¶æ…‹ãŒãƒªã‚¢ãƒ«ã‚¿ã‚¤ãƒ ã§ã‚ã‹ã‚‹MySQLç”¨topã‚³ãƒžãƒ³ãƒ‰ã€Œmytopã€ã¨ã€Œinnotopã€
ã‚µãƒ¼ãƒã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’ã™ã‚‹ä¸Šã§ã‹ãªã‚Šã‚„ã£ã‹ã„ãªã®ãŒãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç³»ã€‚ç‰¹ã«ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ã®é‡ãŒè†¨å¤§ã«ãªã‚‹ã¨å¾Œã‹ã‚‰ä¸èº«ã‚’è¦‹ã¦å•é¡Œã‚’åˆ†æžã™ã‚‹ã®ã‚‚ä¸€è‹¦åŠ´ã¨ã„ã†å ´åˆãŒã€‚ãã‚“ãªã¨ãã«ã“ã®MySQLç”¨topã‚³ãƒžãƒ³ãƒ‰ã€Œmytopã€ã‚’ä½¿ãˆã°ä¸€ä½“ä½•ãŒèµ·ãã¦ã„ã‚‹ã®ã‹ãŒã™ãã«ã‚ã‹ã‚‹ã®ã§å•é¡Œç‚¹ã®æŠŠæ¡ãŒå®¹æ˜“ã«ãªã‚Šã¾ã™ã€‚ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã™ã‚‹ã¨ãã«ä½µç”¨ã™ã‚Œã°ã‹ãªã‚ŠåŠ¹çŽ‡ãŒè‰¯ããªã‚‹ã®ã§ã¯ãªã„ã‹ã¨ã€‚ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã¨ä½¿ã„æ–¹ã¯ä»¥ä¸‹ã®é€šã‚Šã€‚ ã¾ãšã¯ã€Œmytopã€ã‹ã‚‰ã€‚ä»¥ä¸‹ãŒå…¬å¼ã‚µã‚¤ãƒˆã€‚ mytop - a top clone for MySQL http://jeremy.zawodny.com/mysql/mytop/ ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã¯ä»¥ä¸‹ã«ã‚ã‚Šã¾ã™ã€‚ mytop - display MySQL server performance info like `top' ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ã«ã¯SSHãªã©ã‚’ä½¿ã£ã¦rootã§ãƒã‚°ã‚¤ãƒ³å¾Œã€wgetã§ãƒ•ã‚¡ã‚¤ãƒ«
u-ichi 2007/07/30
performance

sql

*tool
ãƒªãƒ³ã‚¯
ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®çµ‚äº†æ—¥ã‚’2020å¹´1æœˆ31æ—¥(é‡‘)ã«æ±ºå®šã—ã¾ã—ãŸ - ã¯ã¦ãªã®å‘ŠçŸ¥
ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®çµ‚äº†æ—¥ã‚’2020å¹´1æœˆ31æ—¥(é‡‘)ã«æ±ºå®šã—ã¾ã—ãŸ ä»¥ä¸‹ã®ã‚¨ãƒ³ãƒˆãƒªã®é€šã‚Šã€ä»Šå¹´æœ«ã‚’ç›®å‡¦ã«ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã‚’çµ‚äº†äºˆå®šã§ã‚ã‚‹æ—¨ã‚’ãŠçŸ¥ã‚‰ã›ã—ã¦ãŠã‚Šã¾ã—ãŸã€‚ 2019å¹´æœ«ã‚’ç›®å‡¦ã«ã€ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®æä¾›ã‚’çµ‚äº†ã™ã‚‹äºˆå®šã§ã™ - ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ ã“ã®ãŸã³ã€æ£å¼ã«çµ‚äº†æ—¥ã‚’æ±ºå®šã„ãŸã—ã¾ã—ãŸã®ã§ã€ä»¥ä¸‹ã®é€šã‚Šã”ç¢ºèªãã ã•ã„ã€‚ çµ‚äº†æ—¥: 2020å¹´1æœˆ31æ—¥(é‡‘) ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆå¸Œæœ›ç”³è«‹æœŸé™:2020å¹´1æœˆ31æ—¥(é‡‘) çµ‚äº†æ—¥ä»¥é™ã¯ã€ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®é–²è¦§ãŠã‚ˆã³æŠ•ç¨¿ã¯è¡Œãˆã¾ã›ã‚“ã€‚æ—¥è¨˜ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãŒå¿…è¦ãªæ–¹ã¯ä»¥ä¸‹ã®è¨˜äº‹ã«ã—ãŸãŒã£ã¦æ‰‹ç¶šãã‚’ã—ã¦ãã ã•ã„ã€‚ ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã«æŠ•ç¨¿ã•ã‚ŒãŸæ—¥è¨˜ãƒ‡ãƒ¼ã‚¿ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã«ã¤ã„ã¦ - ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ ã”åˆ©ç”¨ã®ã¿ãªã•ã¾ã«ã¯ã”è¿·æƒ‘ã‚’ãŠã‹ã‘ã„ãŸã—ã¾ã™ãŒã€ã©ã†ãžã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚ 2020-06-25 è¿½è¨˜ ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãƒ‡ãƒ¼ã‚¿ã¯2020å¹´2æœˆ28
u-ichi 2007/07/20
*program

rails

sql
ãƒªãƒ³ã‚¯
MySQLã€€slow_query - h-wai's blog
MySQLã§ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªãƒ¼ã ã‘ã€ãƒã‚®ãƒ³ã‚°ã§ã‚‹ã‚‹ã‚‰ã—ã„ã€‚ safe_mysqld --log-slow-queries=/var/lib/mysql/slow_query.log ã£ã¦ã€ã‚„ã‚‹ã¨ã‚ˆã‚ã—ã€‚ my.cnfã§ã€ [mysqld] set-variable = long_query_time = 3 ã¨ã‹ã£ã¦ã€æ›¸ã„ã¦ã‚„ã‚‹ã¨ã‚ˆã‚ã—ã€‚
u-ichi 2007/07/20
sql

performance
ãƒªãƒ³ã‚¯
3 æ—¥åŠä¸»æ—¥è¨˜ - ActiveRecord: order by ã¯å¿…è¦æ‚ªã£ã¦ã“ã¨ã§ã™ã‹ -> allocate ãŒæ¶ˆã•ã‚Œã¦ã„ã¾ã—ãŸ -> ã„ã‚„é•ã† , ActiveRecord: order by ã¯å¿…è¦æ‚ªã£ã¦ã“ã¨ã§ã™ã‹(2)
_ [Rails] ActiveRecord: order by ã¯å¿…è¦æ‚ªã£ã¦ã“ã¨ã§ã™ã‹ -> allocate ãŒæ¶ˆã•ã‚Œã¦ã„ã¾ã—ãŸ -> ã„ã‚„é•ã† @customer.services.find_all(nil, "service_at desc").each { |service| } ã¨ã™ã‚‹ã¨ SELECT * FROM services WHERE customer_id = 3 SELECT * FROM services WHERE customer_id = 3 ORDER BY service_at desc ãŒç™ºè¡Œã•ã‚Œã‚‹ã€‚ã“ã‚Œã¯ç„¡é§„ã«è¦‹ãˆã¾ã™ã€‚ ã“ã‚Œã¯ Ruby å´ã§ sort ã—ã‚ã¨ã„ã†ã“ã¨ã‹? @customer.services.sort_by { |service| service.service_at }.reverse.each { |service| } s
u-ichi 2007/07/20
sql

rails

*program
ãƒªãƒ³ã‚¯
Re: MySQLæœ€é©åŒ–ã®ãƒŸãƒ‹tips - æ—¥å‘å¤ç‰¹æ®Šå¿œæ´éƒ¨éšŠ
å…ƒãƒã‚¿: http://labs.unoh.net/2007/07/mysqltips.html ã‚ã¾ã‚Šå…·ä½“çš„ã˜ã‚ƒãªã„ã®ã§ã€åƒ•ã®è€ƒãˆã¨ã‹ã€‚ æ£ã—ã„ã‹ã©ã†ã‹ã¯å„è‡ªã®çŠ¶æ³ã ã¨ã‹å®Ÿéš›è©¦ã™ã¹ããªã‚“ã ã‘ã©ã€å‚è€ƒã«ãªã‚Œã°ã€‚ MyISAMã€InnoDBãªã©ãƒ†ãƒ¼ãƒ–ãƒ«ã‚¿ã‚¤ãƒ— åƒ•ã¯æ–ç„¶InnoDBæ´¾ã§ã™ã€‚ ãŸã ä»°ã‚‹ã¨ãŠã‚Šã€ãƒã‚°ã‚‹ã ã‘ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã¨ã‹ãªã‚‰MyISAMã§ã‚‚ã„ã„ã¨ã¯æ€ã†ã‘ã©ã€‚ ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚„ãƒãƒƒã‚¯å‡¦ç†ãªã©ãŒå¿…è¦ãªã„å ´åˆãªã©ã€MyISAMå½¢å¼ã«ã‚‚è‰¯ã„ã¨ã“ã‚ã¯ã‚ã‚‹ã®ã§æ¤œè¨Žã—ã¦ã¿ã‚‹ä¾¡å€¤ã¯ã‚ã‚‹ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚ ã“ã‚Œã ã‘ã®æŒ‡æ‘˜ã ã¨ã¡ã‚‡ã£ã¨å¾®å¦™ãªæ°—ãŒã™ã‚‹ã§ã™ã€‚ MyISAMã®ä½¿ã„ã©ã“ã‚ã£ã¦ã®ã¯ã€ ãƒ”ãƒ³ã§ä»–ã¨ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ãŒç„¡ã„å˜ç´”è¿½è¨˜ç³»ã®ãƒ†ãƒ¼ãƒ–ãƒ« ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ãŒã‚ã‚Šã€åŒä¸€ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å†…ã§ã®æ›´æ–°ç³»ã‚¯ã‚¨ãƒªãŒå˜åœ¨ã™ã‚‹å ´åˆã¯ã€ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãŒæœŸå¾…é€šã‚Šã«å‹•ã‹ãªã„ã®ã§ã€åŸºæœ¬çš„ã«ã¯InnoDBã¨æ··åœ¨ã•ã›ã‚‹ã¹ãã§ã¯ãªã„
u-ichi 2007/07/20
sql

*program

performance
ãƒªãƒ³ã‚¯
Rubyã§mysqlã«æ»é—˜ã—ã¦æŽ¥ç¶šã—ã¦è¡¨ç¤ºã™ã‚‹ã‚„ã‚Šæ–¹ - ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ä½Žè„³ã£ã·ã‚Šã‚’æ™’ã™æˆ¦è¨˜
Rubyistã‹ã‚‰ã™ã‚Œã°ç°¡å˜ãªã‚“ã§ã—ã‚‡ã†ã‘ã©ãƒ»ãƒ»ãƒ»ãƒ»ãƒ»ãƒ»ãƒ»ãƒ»ãƒ»ãƒ»ã“ã‚ŒãŒã¾ãŸãˆã‚‰ãè‹¦åŠ´ã—ãŸã®ã§ï½— ã“ã‚“ãªã“ã¨ã«1æ—¥ä½¿ã£ã¦ã—ã¾ã£ãŸï¼ Ruby 1.8 Ruby/mysql 0.2.6 mysql4.1ä»¥é™å¯¾å¿œãƒ‘ãƒƒãƒå½“ã¦ è¿½è¨˜ï¼šã“ã®Ruby/mysqlã¯å¾®å¦™ã«å®‰å®šåº¦ãŒä½Žã„ã‚ˆã†ãªã®ã§ã€æ‰‹è»½ã•ã‚ˆã‚Šã‚‚å®‰å®šå‘½ã®æ–¹ã¯ãƒã‚¤ãƒ†ã‚£ãƒ–ã§æ›¸ã‹ã‚Œã¦ã„ã‚‹mysql/rubyã®ã»ã†ã‚’ä½¿ã£ãŸã»ã†ãŒã„ã„ã‚ˆã†ã§ã™ãª æŽ¥ç¶šè„±å‡ºç·¨ ã€ŒRuby/mysqlã€ã¨ã„ã†ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ãŒã‚ã‚‹ã‚ˆã†ãªã®ã§ã€ã“ã„ã¤ã§æŽ¥ç¶šã™ã‚‹ http://www.tmtm.org/ruby/mysql/ ã“ã“ã‹ã‚‰ã¨ã£ã¦ãã¦Rubyã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œã¦ã„ã‚‹libä¸‹ã‚ãŸã‚Šã«ã¶ã¡è¾¼ã‚€ ç§ã¯ã€ã€ŒOne-Click Installer - Windowsã€http://rubyforge.org/projects/rubyinstaller/ ã§å…¥ã‚ŒãŸã®ã§ã€C:\ruby\
u-ichi 2007/07/20
ruby

sql

*program
ãƒªãƒ³ã‚¯
[Rails] MySQLä½¿ã†ã¨ãã®Migrationã®Optionãƒ¡ãƒ¢ - inabatchã®æ—¥è¨˜
åƒ•ãŒã€Railsã®ä¸ã§é«˜ãè©•ä¾¡ã—ã¦ã„ã¦ã€ãŠæ°—ã«å…¥ã‚Šã®æ©Ÿèƒ½ãŒMigrationã§ã™ã€‚ãªãœãªã‚‰ã°ã€Migrationã«ã‚¹ã‚ãƒ¼ãƒžæƒ…å ±ã‚’ç®¡ç†ã•ã›ã‚‹ã“ã¨ã§ã€ã‚¹ã‚ãƒ¼ãƒžæƒ…å ±ã‚’é–‹ç™ºè€…é–“ã‚„ã€ãƒ†ã‚¹ãƒˆæ™‚ã«ãŠã„ã¦ã€çµ±ä¸€ã•ã›ã‚‹ã“ã¨ãŒã§ãã‚‹ã—ã€ã‚¹ã‚ãƒ¼ãƒžã®ãƒãƒ¼ãƒ«ãƒãƒƒã‚¯ã‚‚ã§ãã‚‹ã‚ˆã†ã«ãªã‚‹ã‹ã‚‰ã§ã™ã€‚ ã‚·ã‚¹ãƒ†ãƒ ã§è‰¯ã„ç‰©ãŒã§ããŸã¨ã—ã¦ã‚‚ã€ãƒªãƒªãƒ¼ã‚¹ã§ãƒŸã‚¹ã£ãŸã‚‰çµå±€ã®ã¨ã“ã‚ã€ãƒ€ãƒ¡ãªã‚·ã‚¹ãƒ†ãƒ ã¨ã¿ãªã•ã‚Œã‚‹å¯èƒ½æ€§ãŒã‚ã‚Šã¾ã™ã€‚ä»¥å¤–ã¨æ¨©é™è¨å®šé–¢é€£ã€ã‚·ã‚§ãƒ«å®Ÿè¡Œæ™‚ã®ãƒ‘ã‚¹ãªã©ã§ãƒŸã‚¹ãŒå¤šãè¦‹å—ã‘ã‚‰ã‚Œã¾ã™ã€‚ã¾ãŸã€SQLã®ã‚¹ã‚ãƒ¼ãƒžã«ã¤ã„ã¦ã‚‚åŒæ§˜ã§ãƒŸã‚¹ãŒå‡ºã‚„ã™ã„ã‚ˆã†ã«æ€ã„ã¾ã™ã€‚ãªã®ã§ã€MigrationãŒã‚ã‚Œã°ãƒªãƒªãƒ¼ã‚¹æ™‚ã§ã‚‚å®‰å¿ƒã§ã™ã€‚â€»Capistranoä½¿ã†ã¨Migrationã—ã¦ãã‚Œã‚‹ã®ã‹ãªï¼Ÿï¼Ÿ å®Ÿè¡Œã¯ã€ã“ã®ã‚ˆã†ã«ã™ã‚‹ã€‚rake db:migrate ç‰¹å®šã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ç•ªå·ã«ã—ãŸã„ã¨ãã¯ã€ã“ã®ã‚ˆã†ã«ã™ã‚‹ã€‚rake db:migrate VERSION=
u-ichi 2007/07/19
sql

ruby

*program
ãƒªãƒ³ã‚¯
railsmyadmin - Google Code
Code Archive Skip to content Google About Google Privacy Terms
u-ichi 2007/07/19
rails

ruby

sql

*tool

google
ãƒªãƒ³ã‚¯
GT Nitro: ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚·ãƒ³ã‚°ãƒ»ãƒ‰ãƒ©ãƒƒã‚°ãƒ¬ãƒ¼ã‚·ãƒ³ã‚°ã‚²ãƒ¼ãƒ - Google Play ã®ã‚¢ãƒ—ãƒª
GT Nitro: Car Game Drag Raceã¯ã€å…¸åž‹çš„ãªã‚«ãƒ¼ã‚²ãƒ¼ãƒ ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ã“ã‚Œã¯ã‚¹ãƒ”ãƒ¼ãƒ‰ã€ãƒ‘ãƒ¯ãƒ¼ã€ã‚¹ã‚ãƒ«å…¨é–‹ã®ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã‚²ãƒ¼ãƒ ã§ã™ã€‚ãƒ–ãƒ¬ãƒ¼ã‚ã¯å¿˜ã‚Œã¦ã€ã“ã‚Œã¯ãƒ‰ãƒ©ãƒƒã‚°ãƒ¬ãƒ¼ã‚¹ã€ãƒ™ã‚¤ãƒ“ãƒ¼ï¼å¤å…¸çš„ãªã‚¯ãƒ©ã‚·ãƒƒã‚¯ã‹ã‚‰æœªæ¥çš„ãªãƒ“ãƒ¼ã‚¹ãƒˆã¾ã§ã€æœ€ã‚‚ã‚¯ãƒ¼ãƒ«ã§é€Ÿã„è»Šã¨ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã§ãã¾ã™ã€‚ã‚¹ãƒ†ã‚£ãƒƒã‚¯ã‚·ãƒ•ãƒˆã‚’ãƒžã‚¹ã‚¿ãƒ¼ã—ã€ãƒ‹ãƒˆãƒã‚’è³¢ãä½¿ã£ã¦ç«¶äº‰ã‚’æ‰“ã¡ç ´ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ã“ã®ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã‚²ãƒ¼ãƒ ã¯ãã®ãƒªã‚¢ãƒ«ãªç‰©ç†å¦ã¨ç´ æ™´ã‚‰ã—ã„ã‚°ãƒ©ãƒ•ã‚£ãƒƒã‚¯ã‚¹ã§ã‚ãªãŸã®å¿ƒã‚’çˆ†ç™ºã•ã›ã¾ã™ã€‚ã“ã‚Œã¾ã§ãƒ—ãƒ¬ã‚¤ã—ãŸã“ã¨ã®ãªã„ã‚ˆã†ãªã‚‚ã®ã§ã™ã€‚ GT Nitroã¯ã€ãƒªãƒ•ãƒ¬ãƒƒã‚¯ã‚¹ã¨ã‚¿ã‚¤ãƒŸãƒ³ã‚°ã‚’è©¦ã™ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã‚²ãƒ¼ãƒ ã§ã™ã€‚æ£ã—ã„çž¬é–“ã«ã‚®ã‚¢ã‚’ã‚·ãƒ•ãƒˆã—ã€ã‚¬ã‚¹ã‚’æ€ã„åˆ‡ã‚Šè¸ã‚€å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ã¾ãŸã€å¤§ç‰©ãŸã¡ã¨ç«¶ã„ã¤ã¤ã€è»Šã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¨ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ã‚‚è¡Œã‚ãªã‘ã‚Œã°ãªã‚Šã¾ã›ã‚“ã€‚ä¸–ç•Œä¸ã§æœ€é«˜ã®ãƒ‰ãƒ©ã‚¤ãƒãƒ¼ã¨è»Šã¨ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã«æŒ‘ã‚€ã“ã¨ã«ãªã‚Šã€ãƒ‰ãƒ©ãƒƒã‚°ãƒ¬ãƒ¼ã‚¹ã®çŽ‹å†
u-ichi 2007/07/18
sql

#tips

performance
ãƒªãƒ³ã‚¯
MOONGIFT: Â» Railsã§DBç®¡ç†ã€ŒRailsMyAdminã€:ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚’æ¯Žæ—¥ç´¹ä»‹
Railsã§é–‹ç™ºã‚’è¡Œã†éš›ã«DBã¯å¿…é ˆã ã‚ã†ã€‚ç°¡æ˜“çš„ãªã‚‚ã®ã§ã‚ã‚Œã°SQLiteã§è‰¯ã„ãŒã€ã“ã‚Œã¾ã§ã®çµŒé¨“ã§ã¯å¤§æŠµMySQLãŒåˆ©ç”¨ã•ã‚Œã¦ã„ã‚‹ã€‚ DBç®¡ç†ã«ã¯phpMyAdminã‚„ã€GUIã®DBç®¡ç†ãƒ„ãƒ¼ãƒ«ã‚’åˆ©ç”¨ã—ã¦ããŸãŒã€Railsä¸Šã§ä¸€æ‹¬ç®¡ç†ã§ãã‚‹ã“ã¡ã‚‰ãŒä¾¿åˆ©ãã†ã ã€‚ ä»Šå›žç´¹ä»‹ã™ã‚‹ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ»ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã¯RailsMyAdminã€Railsä¸Šã®DBç®¡ç†ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã ã€‚ RailsMyAdminã§ã¯Railsã§ã®DBè¨å®šã‚’åˆ©ç”¨ã™ã‚‹ã®ã§è¨å®šã‚‚æ‰‹é–“ã‚‚ãªãç°¡å˜ã«åˆ©ç”¨ã§ãã‚‹ã€‚ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã¯ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã¨ã—ã¦ç°¡å˜ã«ã§ãã€environment.rbã«è¨å®šã‚’æ›¸ãåŠ ãˆã‚‹ã ã‘ã§ã„ã„ã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«ã®ä¸€è¦§ã‚„ãƒ‡ãƒ¼ã‚¿ã®ä¸€è¦§è¡¨ç¤ºã€è¿½åŠ ã€ç·¨é›†ã¯ã‚‚ã¡ã‚ã‚“å¯èƒ½ã ã€‚ã¾ãŸã€created_at/updated_atã¨ã„ã£ãŸRailsç‰¹æœ‰ã®ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã¯å€¤ã‚’å…¥ã‚Œã‚‰ã‚Œãªã„ã®ã‚‚ä¾¿åˆ©ã ã€‚ãƒ†ãƒ¼ãƒ–ãƒ«æ§‹é€ ã®å¤‰æ›´ã¯ã‚‚ã¡ã‚ã‚“ä¸å¯ã§ã€migration
u-ichi 2007/07/18
*tool

rails

sql
ãƒªãƒ³ã‚¯
æ ªå¼ä¼šç¤¾ã‚¹ã‚¿ã‚¤ãƒ«ã‚º
AWSã‚¢ãƒ‰ãƒãƒ³ã‚¹ãƒ‰ã‚³ãƒ³ã‚µãƒ«ãƒ†ã‚£ãƒ³ã‚°ãƒ‘ãƒ¼ãƒˆãƒŠãƒ¼ã®ä¸€å“¡ã¨ã—ã¦æ´»å‹•ã™ã‚‹æ ªå¼ä¼šç¤¾ã‚¹ã‚¿ã‚¤ãƒ«ã‚ºãŒã€AWSå°Žå…¥ã€ç§»è¡Œã€é–‹ç™ºã€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã€é‹ç”¨ä¿å®ˆãªã©ã€ã™ã¹ã¦ã®ã”ç›¸è«‡ã«ä¹—ã‚‰ã›ã¦ã„ãŸã ãã¾ã™ã€‚ AWSã‚’å°Žå…¥ã—ãŸã„ãŒä½•ã‹ã‚‰å§‹ã‚ãŸã‚‰ã„ã„ã‹ã‚ã‹ã‚‰ãªã„ æ—¢å˜ã®ãƒ™ãƒ³ãƒ€ãƒ¼ãŒæ–°æŠ€è¡“ã«å¼±ãã€è‰¯ã„ææ¡ˆãŒã‚‚ã‚‰ãˆãªã„ ã‚¯ãƒ©ã‚¦ãƒ‰ã®å°Žå…¥ã«ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã®ä¸å®‰ãŒã‚ã‚‹ AWSã‚’ã¨ã‚Šã‚ãˆãšå°Žå…¥ã—ãŸãŒã€ã•ã‚‰ã«æ´»ç”¨ã—ã¦ã„ããŸã„ ç¤¾å†…ã«AWSã®çŸ¥è¦‹ã‚’æŒã£ã¦ã„ã‚‹äººãŒã„ãªã„ AWSãªã‚‰ã§ã¯ã®ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºã‚’è©³ã—ãçŸ¥ã‚ŠãŸã„
u-ichi 2007/07/17
*program

sql

performance
ãƒªãƒ³ã‚¯
æ ªå¼ä¼šç¤¾ã‚¹ã‚¿ã‚¤ãƒ«ã‚º
AWSã‚¢ãƒ‰ãƒãƒ³ã‚¹ãƒ‰ã‚³ãƒ³ã‚µãƒ«ãƒ†ã‚£ãƒ³ã‚°ãƒ‘ãƒ¼ãƒˆãƒŠãƒ¼ã®ä¸€å“¡ã¨ã—ã¦æ´»å‹•ã™ã‚‹æ ªå¼ä¼šç¤¾ã‚¹ã‚¿ã‚¤ãƒ«ã‚ºãŒã€AWSå°Žå…¥ã€ç§»è¡Œã€é–‹ç™ºã€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã€é‹ç”¨ä¿å®ˆãªã©ã€ã™ã¹ã¦ã®ã”ç›¸è«‡ã«ä¹—ã‚‰ã›ã¦ã„ãŸã ãã¾ã™ã€‚ AWSã‚’å°Žå…¥ã—ãŸã„ãŒä½•ã‹ã‚‰å§‹ã‚ãŸã‚‰ã„ã„ã‹ã‚ã‹ã‚‰ãªã„ æ—¢å˜ã®ãƒ™ãƒ³ãƒ€ãƒ¼ãŒæ–°æŠ€è¡“ã«å¼±ãã€è‰¯ã„ææ¡ˆãŒã‚‚ã‚‰ãˆãªã„ ã‚¯ãƒ©ã‚¦ãƒ‰ã®å°Žå…¥ã«ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã®ä¸å®‰ãŒã‚ã‚‹ AWSã‚’ã¨ã‚Šã‚ãˆãšå°Žå…¥ã—ãŸãŒã€ã•ã‚‰ã«æ´»ç”¨ã—ã¦ã„ããŸã„ ç¤¾å†…ã«AWSã®çŸ¥è¦‹ã‚’æŒã£ã¦ã„ã‚‹äººãŒã„ãªã„ AWSãªã‚‰ã§ã¯ã®ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºã‚’è©³ã—ãçŸ¥ã‚ŠãŸã„
u-ichi 2007/07/17
*program

performance

sql
ãƒªãƒ³ã‚¯
MySQLãƒŽã‚¦ãƒã‚¦
ã„ã‚ã„ã‚ãªæœ¬ã‹ã‚‰ãƒ¡ãƒ¢ã£ã¦ããŸãƒ¡ãƒ¢ã®ãƒ¡ãƒ¢ã€‚å‡ºå…¸ã‚’æ›¸ã„ã¦ãŠãã®ã‚’å¿˜ã‚ŒãŸã€‚æ€ã„å‡ºã—æ¬¡ç¬¬è£œå®Œã™ã‚‹ã‹ã‚‚ã€‚ deleteã®ã‚³ã‚¹ãƒˆã¯é«˜ã„ã®ã§ã€ç„¡åŠ¹åŒ–ã‚’ç¤ºã™ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã‚’ä½œã£ã¦updateã™ã¹ã slow query logã«è¦æ³¨æ„ å¤šãã®ã‚¨ãƒ³ãƒˆãƒªã§ã»ã¨ã‚“ã©ã®ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ãŒåŒã˜å€¤ã‚’æŒã¤å ´åˆã¯ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åŠ¹æžœãŒå°ã•ã„ â†’è¤‡åˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åŠ¹æžœãŒå¤§ãã„ è¤‡åˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯æŒ‡å®šã®é †ç•ªãŒå¤§åˆ‡ã€‚Aã¨Bã¨ã„ã†æŒ‡å®šã®å ´åˆã€Aå˜ç‹¬ã§ã‚‚ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åŠ¹æžœãŒã‚ã‚‹ã€‚é€†ã¯çœŸã§ãªã„ã€‚ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒä½¿ã‚ã‚Œã‚‹å ´é¢ã¯ ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰å€¤ã‚’å®šæ•°ã¨æ¯”è¼ƒã™ã‚‹ã¨ã (where name = 'hogehoge') ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰å€¤ã§JOINã™ã‚‹ã¨ã (where a.name = b.name) ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰å€¤ã®ç¯„å›²ã‚’æ±‚ã‚ã‚‹ã¨ã (<,>,between) LIKEå¥ãŒæ–‡å—åˆ—ã‹ã‚‰å§‹ã¾ã‚‹ã¨ã (where name like 'hoge%') min(),
u-ichi 2007/07/12
#tips

*program

sql

performance
ãƒªãƒ³ã‚¯
MOONGIFT: Â» ãƒžã‚¹ã‚¿ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ã‚’ä¸€æ°—ã«ä½œæˆã€ŒphpCodeGeneratorã€:ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚’æ¯Žæ—¥ç´¹ä»‹
DBã‚’ä½¿ã£ãŸé–‹ç™ºã§ã‚ã‚Œã°å¿…ãšå‡ºã¦ãã‚‹ã®ãŒãƒžã‚¹ã‚¿ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ç”»é¢ã ã€‚åŒã˜ã‚ˆã†ãªä½œã‚Šã§ã€æ¯Žåº¦ä½œã‚‹ã®ãŒé¢å€’ã«æ„Ÿã˜ã¦ã„ã‚‹äººã‚‚å¤šã„ã ã‚ã†ã€‚ã ãŒã€ãƒ¦ãƒ¼ã‚¶ã®ãŸã‚ã‚’è€ƒãˆã‚Œã°å¿…ãšå¿…è¦ãªã®ã‚‚ã‚ã‹ã£ã¦ã„ã‚‹ã¯ãšã ã€‚ ã›ã‚ã¦æ‰‹è»½ã«çµ‚ã‚ã‚‰ã›ã‚‰ã‚Œã‚‹ã‚ˆã†ã«ã—ã‚ˆã†ã€‚æ±ºã¾ã‚Šãã£ãŸã‚³ãƒ¼ãƒ‰ã¯è‡ªå‹•ç”Ÿæˆã—ã¦ã—ã¾ãˆã°è‰¯ã„ã€‚ ä»Šå›žç´¹ä»‹ã™ã‚‹ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ»ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã¯phpCodeGeneratorã€DBå®šç¾©ã«æ²¿ã£ã¦ã‚³ãƒ¼ãƒ‰ã‚’è‡ªå‹•ç”Ÿæˆã™ã‚‹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã ã€‚ phpCodeGeneratorã®ç‰¹å¾´ã¯ãªã‚“ã¨è¨€ã£ã¦ã‚‚å¯¾å¿œã—ã¦ã„ã‚‹DBã®å¤šã•ã ã€‚MySQLã€PostgreSQLã€Oracleã¨ã„ã£ãŸåŸºæœ¬çš„ãªã‚‚ã®ã¯ã‚‚ã¡ã‚ã‚“ã€Access/ODBC/SQLite/DB2/MS SQL Server/MaxDB/Visual FoxPro/FrontBase/InterBase 6/Borland Interbase 6.5/Firebird/Inform
u-ichi 2007/07/04
*tool

*program

php

sql
ãƒªãƒ³ã‚¯
MySQLã§å…¨æ–‡æ¤œç´¢ - FULLTEXTã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åŸºç¤ŽçŸ¥è˜ï½œblogï½œãŸãŸã¿ãƒ©ãƒœ
tatamilab.jp
u-ichi 2007/07/01
*program

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