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

ustam id:ustam

MySQLã«é–¢ã™ã‚‹ustamã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (16)

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

æ¼¢(ã‚ªãƒˆã‚³)ã®ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿é“: MySQLã‚’é«˜é€ŸåŒ–ã™ã‚‹10ã®æ–¹æ³•
ã¡ã‚‡ã£ã¨ã‚ãƒ£ãƒƒãƒâˆ’ãªã‚¿ã‚¤ãƒˆãƒ«ã‚’ã¤ã‘ã¦ã—ã¾ã£ãŸãŒã€ä»Šæ—¥ã¯ç‹¬æ–ã¨åè¦‹ã§MySQLã‚’é«˜é€ŸåŒ–ã™ã‚‹æ–¹æ³•ã‚’10å€‹ç´¹ä»‹ã—ã‚ˆã†ã€‚MySQLã‚µãƒ¼ãƒã‚’ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã™ã‚‹ã¨ãã‚„åˆæœŸå°Žå…¥ã™ã‚‹å ´åˆãªã©ã«å‚è€ƒã«ã—ã¦ã‚‚ã‚‰ã„ãŸã„ã€‚ 1. ãƒãƒƒãƒ•ã‚¡ã‚’å¢—ã‚„ã™ã€ã¾ãŸã¯æ¸›ã‚‰ã™ ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®åŸºæœ¬ä¸ã®åŸºæœ¬ã§ã‚ã‚‹ãŒã€é©åˆ‡ãªãƒãƒƒãƒ•ã‚¡ã‚µã‚¤ã‚ºã‚’è¨å®šã™ã‚‹ã“ã¨ã¯ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®è¦ã§ã‚ã‚‹ã€‚ä¸»ãªãƒãƒƒãƒ•ã‚¡ã¯æ¬¡ã®é€šã‚Šã€‚ innodb_buffer_pool_sizeãƒ»ãƒ»ãƒ»InnoDBã ã‘ã‚’åˆ©ç”¨ã™ã‚‹å ´åˆã¯ç©ºããƒ¡ãƒ¢ãƒªã®7ã€œ8å‰²ç¨‹åº¦ã‚’å‰²ã‚Šå½“ã¦ã‚‹æœ€ã‚‚é‡è¦ãªãƒãƒƒãƒ•ã‚¡ã§ã‚ã‚‹ã€‚ä½™è«‡ã ãŒã€å®Ÿéš›ã«ã¯ã“ã“ã§å‰²ã‚Šå½“ã¦ãŸå€¤ã®5ã€œ10%ãã‚‰ã„ã‚’å¤šã‚ã«ãƒ¡ãƒ¢ãƒªã‚’ä½¿ã†ã®ã§æ³¨æ„ãŒå¿…è¦ã ã€‚ key_buffer_sizeãƒ»ãƒ»ãƒ»MyISAMã ã‘ã‚’åˆ©ç”¨ã™ã‚‹å ´åˆã¯ã€ç©ºããƒ¡ãƒ¢ãƒªã®3å‰²ç¨‹åº¦ã‚’å‰²ã‚Šå½“ã¦ã‚‹ã¨ã„ã„ã€‚æ®‹ã‚Šã¯ãƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†ãƒ ã®ã‚ãƒ£ãƒƒã‚·ãƒ¥ç”¨ã«æ®‹ã—ã¦ãŠã“ã†ã€‚ sort_buffer_
ustam 2009/02/19
mySQL

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

é«˜é€ŸåŒ–

ã‚·ã‚¹ãƒ†ãƒ é–‹ç™º

ã‚ã¨ã§ã‚„ã‚‹
ãƒªãƒ³ã‚¯
MySQL :: MySQL 8.0 ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢ãƒ« :: 12.8 æ–‡å—åˆ—é–¢æ•°ãŠã‚ˆã³æ¼”ç®—å
ASCII(str) æ–‡å—åˆ— str ã®å·¦ç«¯ã®æ–‡å—ã®æ•°å€¤ã‚’è¿”ã—ã¾ã™ã€‚ str ãŒç©ºã®æ–‡å—åˆ—ã§ã‚ã‚‹å ´åˆã¯ã€0 ã‚’è¿”ã—ã¾ã™ã€‚ str ãŒ NULL ã§ã‚ã‚‹å ´åˆã¯ NULL ã‚’è¿”ã—ã¾ã™ã€‚ ASCII() ã¯ã€8 ãƒ“ãƒƒãƒˆæ–‡å—ã®å ´åˆã«å‹•ä½œã—ã¾ã™ã€‚ mysql> SELECT ASCII('2'); -> 50 mysql> SELECT ASCII(2); -> 50 mysql> SELECT ASCII('dx'); -> 100 ORD() é–¢æ•°ã‚‚å‚ç…§ã—ã¦ãã ã•ã„ã€‚ BIN(N) N ã®ãƒã‚¤ãƒŠãƒªå€¤ã®æ–‡å—åˆ—è¡¨ç¾ã‚’è¿”ã—ã¾ã™ã€‚N ã¯ longlong (BIGINT) æ•°å—ã§ã™ã€‚ ã“ã‚Œã¯ã€CONV(N,10,2) ã¨åŒç‰ã§ã™ã€‚ N ãŒ NULL ã§ã‚ã‚‹å ´åˆã¯ NULL ã‚’è¿”ã—ã¾ã™ã€‚ mysql> SELECT BIN(12); -> '1100' BIT_LENGTH(str) æ–‡å—åˆ— str ã®é•·
ustam 2009/01/20
mySQL

æ–‡å—åˆ—é–¢æ•°
ãƒªãƒ³ã‚¯
MySQL :: MySQL 4.1 ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢ãƒ« :: 5.2.9 MySQL ã«ã‚ˆã‚‹ LIMIT ã®æœ€é©åŒ–
HAVING ã‚’ä½¿ç”¨ã™ã‚‹ã®ã§ã¯ãªã LIMIT row_count ã‚’ä½¿ç”¨ã—ã¦ã„ã‚‹å ´åˆã€MySQL ã«ã‚ˆã‚‹ã‚¯ã‚¨ãƒªã®å‡¦ç†æ–¹æ³•ãŒç•°ãªã‚‹å ´åˆãŒã‚ã‚Šã¾ã™ã€‚ LIMIT ã‚’ä½¿ç”¨ã—ã¦æ•°ãƒ¬ã‚³ãƒ¼ãƒ‰ã—ã‹é¸æŠžã—ã¦ã„ãªã„ã¨ã€ãƒ•ãƒ«ãƒ†ãƒ¼ãƒ–ãƒ«ã‚¹ã‚ãƒ£ãƒ³ãŒè¡Œã‚ã‚Œãã†ãªå ´åˆã«ã€MySQL ã¯ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ã†ã“ã¨ãŒã‚ã‚‹ã€‚ ORDER BY ã¨ã¨ã‚‚ã« LIMIT row_count ã‚’ä½¿ç”¨ã—ã¦ã„ã‚‹å ´åˆã€MySQL ã§ã¯ã™ã¹ã¦ã®ãƒ†ãƒ¼ãƒ–ãƒ«ãŒã‚½ãƒ¼ãƒˆã•ã‚Œã‚‹ã®ã§ã¯ãªãã€æœ€åˆã® row_count ãƒ¬ã‚³ãƒ¼ãƒ‰ã®æ¤œç´¢ãŒè¡Œã‚ã‚ŒãŸæ™‚ç‚¹ã§ãŸã ã¡ã«ã‚½ãƒ¼ãƒˆã‚’çµ‚äº†ã™ã‚‹ã€‚ LIMIT row_count ã‚’ DISTINCT ã¨ã‚ã‚ã›ã¦ä½¿ç”¨ã—ãŸå ´åˆã€MySQL ã¯ä¸€æ„ã® row_count è¡Œã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’æ¤œç´¢ã™ã‚‹ã¨ãŸã ã¡ã«åœæ¢ã™ã‚‹ã€‚ GROUP BY ãŒã‚ãƒ¼ã‚’é †ç•ªã«èªã‚€ï¼ˆã¾ãŸã¯ã‚ãƒ¼ã®ã‚½ãƒ¼ãƒˆã‚’å®Ÿè¡Œã—ã¦èªã‚€ï¼‰ã“ã¨ã§è§£æ±ºã§ãã€ã‚ãƒ¼ã®å€¤ãŒå¤‰ã‚ã‚‹ã¾ã§ ã‚µãƒžãƒªãŒè¨ˆç®—
ustam 2008/12/10
ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

MySQL

æœ€é©åŒ–
ãƒªãƒ³ã‚¯
MySQL 4.1 ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢ãƒ« sequence é–¢é€£
ANY_VALUE(arg) ã“ã®é–¢æ•°ã¯ã€MySQL ãŒç‰¹å®šã§ããªã„ç†ç”±ã§æœ‰åŠ¹ã§ã‚ã‚‹ã¨ã‚ã‹ã£ã¦ã„ã‚‹ã‚¯ã‚¨ãƒªãƒ¼ã‚’ MySQL ãŒæ‹’å¦ã™ã‚‹å ´åˆã«ã€ONLY_FULL_GROUP_BY SQL ãƒ¢ãƒ¼ãƒ‰ãŒæœ‰åŠ¹ãª GROUP BY ã‚¯ã‚¨ãƒªãƒ¼ã«å½¹ç«‹ã¡ã¾ã™ã€‚ é–¢æ•°ã®æˆ»ã‚Šå€¤ãŠã‚ˆã³åž‹ã¯ã€ãã®å¼•æ•°ã®æˆ»ã‚Šå€¤ãŠã‚ˆã³åž‹ã¨åŒã˜ã§ã™ãŒã€é–¢æ•°ã®çµæžœã¯ ONLY_FULL_GROUP_BY SQL ãƒ¢ãƒ¼ãƒ‰ã§ã¯ãƒã‚§ãƒƒã‚¯ã•ã‚Œã¾ã›ã‚“ã€‚ ãŸã¨ãˆã°ã€name ãŒã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ä»˜ã‘ã•ã‚Œã¦ã„ãªã„ã‚«ãƒ©ãƒ ã®å ´åˆã€æ¬¡ã®ã‚¯ã‚¨ãƒªãƒ¼ã¯ ONLY_FULL_GROUP_BY ãŒæœ‰åŠ¹ã«ãªã£ã¦ã„ã‚‹ã¨å¤±æ•—ã—ã¾ã™: mysql> SELECT name, address, MAX(age) FROM t GROUP BY name; ERROR 1055 (42000): Expression #2 of SELECT list is not in GROUP
ustam 2008/12/04
mySQL

ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£
ãƒªãƒ³ã‚¯
ã€Œã¯ã¦ãªæµå¤§è¦æ¨¡ãƒ‡ãƒ¼ã‚¿å‡¦ç†ã€ã‚’è¦‹ã¦ããŸ - ã‚‚ãŽã‚ƒã‚ã
KOF2008ï¼šé–¢è¥¿ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹2008ã¨ã„ã†ã‚¤ãƒ™ãƒ³ãƒˆã«æ¥ã¦ã„ã¾ã™ã€‚ ã¯ã¦ãªã®ä¼Šè—¤ã•ã‚“ã®è¬›æ¼”ãŒã‚ã£ãŸã®ã§ã€è¬›æ¼”ãƒ¡ãƒ¢ã‚’å…¬é–‹ã€‚ ï¼ƒãƒœã‚¯ãŒãƒ¡ãƒ¢ã—ãŸå†…å®¹ã§ã‚ã£ã¦ã€100%è¨€ã£ãŸã¨ãŠã‚Šã«æ›¸ã„ã¦ã‚ã‚‹ã‚ã‘ã˜ã‚ƒãªã„ã®ã§ã€å‚è€ƒã¨ã—ã¦ã”è¦§ãã ã•ã„ã€‚ (ç¶šã) ã‚¢ã‚¸ã‚§ãƒ³ãƒ€ å¤§è¦æ¨¡ãªãƒ‡ãƒ¼ã‚¿ OSã®ã‚ãƒ£ãƒƒã‚·ãƒ¥ MySQLã®é‹ç”¨ å¤§è¦æ¨¡ãƒ‡ãƒ¼ã‚¿ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®é–‹ç™º ãƒ‡ãƒ¼ã‚¿ã®ä¾‹ ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ã®ãƒ‡ãƒ¼ã‚¿é‡ï¼šäº”åƒä¸‡ä»¶ãã‚‰ã„ã®ãƒ‡ãƒ¼ã‚¿é‡ ã“ã®ãƒ‡ãƒ¼ã‚¿ã«å¯¾ã—ã¦ä½•ç™¾ä¸‡äººãŒã‚¢ã‚¯ã‚»ã‚¹ã—ã¦ãã‚‹çŠ¶æ³ã§ã©ã†ã„ã†ä½œã‚Šã«ã™ã‚‹ã‹ ãƒ¬ã‚³ãƒ¼ãƒ‰æ•° 1073ä¸‡ã‚¨ãƒ³ãƒˆãƒªãƒ¼ 3134ä¸‡ã‚¨ãƒ³ãƒˆãƒªãƒ¼ 4143ä¸‡ã‚¿ã‚° ãƒ‡ãƒ¼ã‚¿ã‚µã‚¤ã‚º ã‚¨ãƒ³ãƒˆãƒªãƒ¼2.5GB ä½•ã®å·¥å¤«ã‚‚ãªãæ™®é€šã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã¨...200ç§’å¾…ã£ã¦ã‚‚çµæžœãŒå¸°ã£ã¦ã“ãªã„ å¤§è¦æ¨¡ãƒ‡ãƒ¼ã‚¿ã®é›£ã—ã„ã¨ã“ã‚ é–‹ç™ºã‚µãƒ¼ãƒã§é–‹ç™ºè€…ãŒä½œã£ã¦ã„ã‚‹æ™‚ã¯å¿«é©ã«å‹•ã„ã¦ã„ã¦ã‚‚ã€å¤šæ•°ã®äººé–“ãŒã‚¢ã‚¯
ustam 2008/11/11
ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£

ã‚¹ã‚±ãƒ¼ãƒ«

MySQL

ã‚·ã‚¹ãƒ†ãƒ é–‹ç™º
ãƒªãƒ³ã‚¯
JustAnotherGeekBlog.com |
The first website, shown in a simulation of the first browser. (Credit: CERN) 30 years ago today, March 12, an engineer at The European Organization for Nuclear Research (CERN) had an idea that would change the world.Â In a document entitled â€œInformation Management: A Proposalâ€, CERN engineer Sir Tim Barnes-Lee laid out his vision for a system of managing and linking information. The system he env
ustam 2008/11/06
Apache

MySQL

PHP
ãƒªãƒ³ã‚¯
MySQL5 ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³è¨å®š
ãšã¶æ¿¡ã‚Œå°å ¤ã§ã™ã€‚ ã•ã¦ã€MySQL5ã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³è¨å®šã‚’è¡Œã£ãŸã®ã§ãƒ¡ãƒ¢ã€‚ MySQLã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯CentOS5ã‚’å…¥ã‚ŒãŸã¨ãã«ã€ã„ã‚Œã‚‹ã“ã¨ãŒã§ãã‚‹RPMç‰ˆã®5.0.22ã§ã™ã€‚ ä»Šå›žã¯ã€ãƒžã‚¹ã‚¿ã€ã‚¹ãƒ¬ãƒ¼ãƒ–ã®2å°æ§‹æˆã§ã€ãƒžã‚¹ã‚¿ãƒ¼ã‚’æ›´æ–°ã™ã‚‹ã¨ã‚¹ãƒ¬ãƒ¼ãƒ–ã‚‚è‡ªå‹•çš„ã«æ›´æ–°ã•ã‚Œã‚‹ã¨ã„ã†ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’è¡Œã„ã¾ã™ã€‚ ãƒžã‚¹ã‚¿ãƒ¼ã‚’2ã¤ä½œã£ã¦ã€ãŠäº’ã„ã‚’æ›´æ–°ã—ã‚ã†ãƒ‡ãƒ¥ã‚¢ãƒ«ãƒžã‚¹ã‚¿ã‚„ã€ãƒžã‚¹ã‚¿ãƒ¼ã‚’è¤‡æ•°ã§æ§‹æˆã™ã‚‹ãƒžãƒ«ãƒãƒžã‚¹ã‚¿ã®è¨å®šãªã©ã¯ã€ãã®ã†ã¡ã‚„ã‚Œã‚Œã°ã‚„ã‚ã†ã‹ãªã€‚ MySQLã¯ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œã¦ã„ã‚‹ã‚‚ã®ã¨ã—ã¦ã€è¨å®šã‚’ã¯ã˜ã‚ã¾ã™ã€‚ æ‰‹é †ã¯ä¸‹è¨˜ã®é€šã‚Šã§ã™ã€‚ ãƒ¦ãƒ¼ã‚¶ã®è¿½åŠ ãƒžã‚¹ã‚¿è¨å®š ã‚¹ãƒ¬ãƒ¼ãƒ–è¨å®š ãƒ‡ãƒ¼ã‚¿ã®ç§»è¡Œ ãƒžã‚¹ã‚¿ãƒ¼ã®MySQLã‚’å†èµ·å‹•ã—ã¦ã€ã‚¹ãƒ¬ãƒ¼ãƒ–ã‚’å†èµ·å‹• ç¢ºèª ï¼‘ï¼Žãƒ¦ãƒ¼ã‚¶ã®è¿½åŠ ãƒžã‚¹ã‚¿ã«å¯¾ã—ã¦ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ç”¨ãƒ¦ãƒ¼ã‚¶ã‚’ä½œã‚Šã¾ã™ã€‚ã‚¹ãƒ¬ãƒ¼ãƒ–ãŒã“ã®ãƒ¦ãƒ¼ã‚¶ã‚’ä½¿ã£ã¦é€šä¿¡ã‚’è¡Œã„ã¾ã™ã€‚ GRANT REPLICATION SLA
ustam 2008/08/18
MySQL

ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³
ãƒªãƒ³ã‚¯
[ThinkIT] ç¬¬4å›žï¼šãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®æ¯”è¼ƒ (4/4)
MySQLã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ©Ÿèƒ½ã§ã¯ã€å½¹å‰²ã®ç•°ãªã‚‹ã„ãã¤ã‹ã®ãƒ•ã‚¡ã‚¤ãƒ«ãŒä½¿ç”¨ã•ã‚Œã¾ã™ã€‚ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«ã¦ä½¿ç”¨ã™ã‚‹ãƒ•ã‚¡ã‚¤ãƒ«ã®ã†ã¡ã€ãƒžã‚¹ã‚¿ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å†…ã§ä½¿ç”¨ã™ã‚‹ã‚‚ã®ã¯ã€ãƒã‚¤ãƒŠãƒªãƒ»ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ã§ã™ã€‚ ãƒã‚¤ãƒŠãƒªãƒ»ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ã¯ã€ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã«å˜åœ¨ã—ã€ãƒžã‚¹ã‚¿ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¸ã®æ›´æ–°å‡¦ç†å†…å®¹ã®ã™ã¹ã¦ãŒæ›¸ãè¾¼ã¾ã‚Œã¾ã™ã€‚ãƒã‚¤ãƒŠãƒªãƒ»ãƒã‚°ãƒ•ã‚¡ã‚¤ã¯ã€ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ãŸã‚ã ã‘ã«ä½¿ç”¨ã•ã‚Œã‚‹ã®ã§ã¯ãªãã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹éšœå®³æ™‚ã®ãƒªã‚«ãƒãƒªã«ã‚‚ä½¿ç”¨ã•ã‚Œã¾ã™ã€‚ ã¾ãŸã€ã‚¹ãƒ¬ãƒ¼ãƒ–ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å†…ã§ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ç”¨ã«ä½¿ç”¨ã™ã‚‹ãƒ•ã‚¡ã‚¤ãƒ«ã¯ã€ã€Œãƒžã‚¹ã‚¿ãƒ»æƒ…å ±ãƒ•ã‚¡ã‚¤ãƒ«ã€ã€Œãƒªãƒ¬ãƒ¼ãƒ»ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ã€ã€Œãƒªãƒ¬ãƒ¼ãƒã‚°ãƒ»æƒ…å ±ãƒ•ã‚¡ã‚¤ãƒ«ã€ã®3ã¤ã§ã™ã€‚ã“ã®3ã¤ã®ãƒ•ã‚¡ã‚¤ãƒ«ã¯ã€ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã«å˜åœ¨ã—ã¾ã™ã€‚ ãƒªãƒ¬ãƒ¼ãƒ»ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ã¯ã€ãƒžã‚¹ã‚¿ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã®æ›´æ–°å‡¦ç†å†…å®¹ã‚’è“„ç©ã™ã‚‹å½¹å‰²ã‚’æŒã¡ã¾ã™ã€‚ã‚¹ãƒ¬ãƒ¼ãƒ–ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã€ã“ã®ãƒªãƒ¬ãƒ¼
ustam 2008/08/17
MySQL

ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³

ãƒžã‚¹ã‚¿ãƒ¼ã‚¹ãƒ¬ã‚¤ãƒ–
ãƒªãƒ³ã‚¯
MySQLã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«
ustam 2008/04/13
leopard

MacOSX

macport

MAMP

MySql

Apache

PHP
ãƒªãƒ³ã‚¯
mixiã®ç”Ÿã¿ã®è¦ªâ€œãƒã‚¿ãƒ©æ°â€ãŒèªžã‚‹MySQLã®æ„å¤–ãªåˆ©ç”¨æ³• ï¼ TechTargetã‚¸ãƒ£ãƒ‘ãƒ³
æ—¥è¨˜ã ã‘ã§4å„„ä»¶ã®ãƒ‡ãƒ¼ã‚¿ ãƒŸã‚¯ã‚·ã‚£ãŒé‹å–¶ã™ã‚‹SNSã€Œmixiã€ã¯ã€2007å¹´7æœˆæœ«æ®µéšŽã§ãƒ¦ãƒ¼ã‚¶ãƒ¼æ•°ãŒ1110ä¸‡äººã€‚äººãŒ12äººé›†ã¾ã‚Œã°ã€1äººã¯mixiãƒ¦ãƒ¼ã‚¶ãƒ¼ã¨ã„ã†ã‚ã‘ã ã€‚ãƒ¦ãƒ¼ã‚¶ãƒ¼ã®ã‚¢ã‚¯ãƒ†ã‚£ãƒ–çŽ‡ï¼ˆãƒã‚°ã‚¤ãƒ³é–“éš”ãŒ3æ—¥ä»¥å†…ï¼‰ã¯ç´„62ï¼…ã¨é«˜ãã€2007å¹´4æœˆã‹ã‚‰6æœˆã®æœˆé–“å¹³å‡ãƒšãƒ¼ã‚¸ãƒ“ãƒ¥ãƒ¼ã¯117.5å„„ã«é”ã—ãŸã€‚æ—¥è¨˜ã ã‘ã§ã‚‚4å„„ä»¶ä»¥ä¸Šã«ä¸Šã‚‹ãªã©ã€è“„ç©ã™ã‚‹ãƒ‡ãƒ¼ã‚¿é‡ã‚‚èŽ«å¤§ã€‚2004å¹´3æœˆã®ã‚µãƒ¼ãƒ“ã‚¹é–‹å§‹ã‹ã‚‰ã€ã‚ãšã‹3å¹´åŠã§ç¾åœ¨ã®å·¨å¤§ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãƒ¼ã¸ã¨ç™ºå±•ã—ãŸã®ã ã€‚ ãƒŸã‚¯ã‚·ã‚£ã¯ã€ã€ŒLAMPï¼ˆOSã®Linuxã€Webã‚µãƒ¼ãƒã®Apacheã€DBMSã®MySQLã€é–‹ç™ºè¨€èªžã®Perlã€PHPã€Pythonï¼‰ã€ã¨å‘¼ã°ã‚Œã‚‹Webã‚·ã‚¹ãƒ†ãƒ å‘ã‘ã®æ¨™æº–çš„ãªã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ï¼ˆä»¥ä¸‹ã€OSSï¼‰ã§ã‚·ã‚¹ãƒ†ãƒ ã‚’è‡ªç¤¾é–‹ç™ºã—ã€å®‰ä¾¡ãªPCã‚µãƒ¼ãƒã‚’1000å°ä»¥ä¸Šé€£ãã‚‹è¶…åˆ†æ•£æ§‹æˆã§mixiã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’æ”¯ãˆã¦ã„ã‚‹ï¼ˆåºƒå‘Šé…ä¿¡ãªã©å‘¨è¾ºæ©Ÿèƒ½ã§ã¯
ustam 2007/09/12
mixi

MySQL

ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£

Webãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

Webåˆ¶ä½œ
ãƒªãƒ³ã‚¯
ã€ŒPostgreSQLã¯é…ã„ã€ã¯æœ¬å½“ã‹ï¼Ÿï¼šOSSãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æ¯”è¼ƒ - CNET Japan
å°åˆ·ã™ã‚‹ ãƒ¡ãƒ¼ãƒ«ã§é€ã‚‹ ãƒ†ã‚ã‚¹ãƒˆ HTML é›»åæ›¸ç± PDF ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ ãƒ†ã‚ã‚¹ãƒˆ é›»åæ›¸ç± PDF ã‚¯ãƒªãƒƒãƒ—ã—ãŸè¨˜äº‹ã‚’Myãƒšãƒ¼ã‚¸ã‹ã‚‰èªã‚€ã“ã¨ãŒã§ãã¾ã™ LAMPã‚„LAPPã¨ã„ã£ãŸè¨€è‘‰ãŒç¤ºã—ã¦ã„ã‚‹ã‚ˆã†ã«ã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ï¼ˆOSSï¼‰ã§ã®ä»£è¡¨çš„ãªãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ï¼ˆRDBMSï¼‰ã¨ã„ãˆã°ã€ã€ŒMySQLã€ã¨ã€ŒPostgreSQLã€ã ã€‚ã“ã®2ã¤ã®RDBMSã¯åŒç‰ã§ã‚ã‚‹ã‹ã®ã‚ˆã†ã«æ€ã‚ã‚Œã¦ã„ã‚‹ãŒã€ã—ã‹ã—PostgreSQLã®ãƒ¦ãƒ¼ã‚¶ãƒ¼å›£ä½“ã€Œæ—¥æœ¬PostgreSQLãƒ¦ãƒ¼ã‚¶ä¼šã€ã§ç†äº‹é•·ã‚’å‹™ã‚ã‚‹ç‰‡å²¡è£•ç”Ÿæ°ã«ã‚ˆã‚Œã°ã€ã€ŒPostgreSQLã¯ã‚ã¾ã‚Šä¿¡ç”¨ã•ã‚Œã¦ã„ãªã„ã€ã¨ã„ã†ã“ã¨ãŒã‚ã‚‹ãã†ã ã€‚ ã€Œååˆ†ã«ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã•ã‚ŒãŸMySQLã¨ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã—ã¦ã„ãªã„PostgreSQLã‚’æ¯”è¼ƒã—ãŸã‚Šã€åå¯¾ã«ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã•ã‚ŒãŸPostgreSQLã¨ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã—ã¦ã„ãªã„MySQLã‚’æ¯”è¼ƒã—ãŸã‚Šã€ã‚ã‚‹ã„ã¯æ¯”
ustam 2007/04/12
SQL

MySQL

PostgreSQL

ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯
ãƒªãƒ³ã‚¯
MySQL FULLTEXT Ngram : LIKEæ¤œç´¢ã‚ˆã‚Šæ•°åå€é«˜é€Ÿãªã€ãŠæ‰‹è»½ æ—¥æœ¬èªžå…¨æ–‡æ¤œç´¢ ã«ã¤ã„ã¦ï½œblogï½œãŸãŸã¿ãƒ©ãƒœ
tatamilab.jp
ustam 2007/03/16
php

mySQL

å…¨æ–‡æ¤œç´¢

ãƒ—ãƒã‚°ãƒ©ãƒ
ãƒªãƒ³ã‚¯
ã€ŒPostgreSQLã¯16CPUã¾ã§ã‚¹ã‚±ãƒ¼ãƒ«ï¼Œã‚‚ã†æ€§èƒ½ã¯OSSãƒŸãƒ‰ãƒ«ã®èª²é¡Œã§ã¯ãªã„ã€---IPA OSSã‚»ãƒ³ã‚¿ãƒ¼ãŒæ¤œè¨¼ãƒ‡ãƒ¼ã‚¿å…¬é–‹
ã€Œæœ€æ–°ç‰ˆã®PostgreSQLã¯16CPUã¾ã§ã‚¹ã‚±ãƒ¼ãƒ«ï¼ˆCPUæ•°ã«æ¯”ä¾‹ã—ã¦æ€§èƒ½ãŒå‘ä¸Šï¼‰ã™ã‚‹ã€‚æ€§èƒ½ã¯ã‚‚ã¯ã‚„ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ»ãƒŸãƒ‰ãƒ«ã‚¦ã‚¨ã‚¢ã®èª²é¡Œã§ã¯ãªã„ã€---ç‹¬ç«‹è¡Œæ”¿æ³•äºº æƒ…å ±å‡¦ç†æŽ¨é€²æ©Ÿæ§‹ï¼ˆIPAï¼‰ã¯2æœˆ7æ—¥ï¼Œã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ»ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ãƒ»ã‚»ãƒ³ã‚¿ãƒ¼ï¼ˆOSSã‚»ãƒ³ã‚¿ãƒ¼ï¼‰ãŒå®Ÿæ–½ã—ãŸã€ŒOSSæ€§èƒ½ãƒ»ä¿¡é ¼æ€§è©•ä¾¡ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã€ã®çµæžœã‚’å…¬é–‹ã—ãŸã€‚ ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£è©•ä¾¡ã¯ï¼ŒThe Linux Foundation(æ—§OSDL)ãŒé–‹ç™ºã—ãŸãƒ„ãƒ¼ãƒ«DBT-1ã‚’åˆ©ç”¨ã—ãŸã€‚ã‚ªãƒ³ãƒ©ã‚¤ãƒ³æ›¸åº—ã‚’ã‚·ãƒŸãƒ¥ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã—ãŸãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ãƒ»ãƒ„ãƒ¼ãƒ«ã§ã‚ã‚‹ã€‚ä½¿ç”¨ã—ãŸã®ã¯ï¼Œè©•ä¾¡æ™‚ã®æœ€æ–°ç‰ˆã ã£ãŸPostgreSQL 8.1ã«ãƒ‘ãƒƒãƒã‚’é©ç”¨ã—ãŸã‚‚ã®ã€‚ã€Œç¾åœ¨ã®æœ€æ–°ç‰ˆã§ã‚ã‚‹8.2ç›¸å½“ã€ï¼ˆIPA OSSã‚»ãƒ³ã‚¿ãƒ¼ç ”ç©¶å“¡ã§æ—¥ç«‹è£½ä½œæ‰€ã®éˆ´æœ¨å‹å³°æ°ï¼‰ã€‚2005å¹´ã«8.1ã‚’å¯¾è±¡ã«å®Ÿæ–½ã—ãŸè©•ä¾¡ã§ã¯8CPUã¾ã§ã—ã‹ã‚¹ã‚±ãƒ¼ãƒ«ã—ãªã‹ã£ãŸãŒï¼Œä»Šå›žã®è©•ä¾¡ã§ã¯16CPUã¾ã§ã‚¹ã‚±ãƒ¼
ustam 2007/02/09
ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹

PostgreSQL

ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£

MySQL
ãƒªãƒ³ã‚¯
UNIXç’°å¢ƒã¸ã®PHPã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« - phpspot
UNIXç’°å¢ƒã«PHPã‚’ã‚½ãƒ¼ã‚¹ã‹ã‚‰ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹æ‰‹é †ã‚’èª¬æ˜Žã—ã¾ã™ã€‚ ä¸€èˆ¬ã«ã‚ˆãçµ„ã¿åˆã‚ã•ã‚Œã‚‹ã€MySQLã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã«ã¤ã„ã¦ã‚‚è§£èª¬ã—ã¾ã™ã€‚ MySQLã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« MySQLã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« Apache2ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« Apache2ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« PHPã§åˆ©ç”¨ã™ã‚‹ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« zlibãƒ©ã‚¤ãƒ–ãƒ©ãƒªã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« libpngãƒ©ã‚¤ãƒ–ãƒ©ãƒªã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« - GDã§PNGãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆã‚’æ‰±ãˆã‚‹ã‚ˆã†ã«ã™ã‚‹ libjpegãƒ©ã‚¤ãƒ–ãƒ©ãƒªã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« - GDã§JPEGãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆã‚’æ‰±ãˆã‚‹ã‚ˆã†ã«ã™ã‚‹ Freetypeãƒ©ã‚¤ãƒ–ãƒ©ãƒªã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« - GDã§TrueTypeFontã‚’ä½¿ãˆã‚‹ã‚ˆã†ã«ã™ã‚‹ GDãƒ©ã‚¤ãƒ–ãƒ©ãƒªã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« - PHPã®ã‚°ãƒ©ãƒ•ã‚£ãƒƒã‚¯ã‚¹æ©Ÿèƒ½ã‚’ä½¿ãˆã‚‹ã‚ˆã†ã«ã™ã‚‹ PHPã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« PHP4ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« PHP5ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« PHPã®å‹•ä½œç¢ºèª ã‚¹ãƒãƒ³ã‚µãƒ¼ãƒ‰ãƒªãƒ³ã‚¯
ustam 2007/01/15
Apache

Apache2

mySQL

PHP

UNIX

ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«
ãƒªãƒ³ã‚¯
ï¼»MySQLã‚¦ã‚©ãƒƒãƒï¼½ç¬¬27å›žã€€MySQL 5.0 ãŠã‚ˆã³ 4.1 ã«SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã®ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ãƒ»ãƒ›ãƒ¼ãƒ«
å…ˆæ—¥ï¼ŒMySQL 5.0 ãŠã‚ˆã³ 4.1 ã«é–¢ã—ã¦SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã®å±é™ºæ€§ã«å¯¾å¿œã™ã‚‹ãŸã‚ã«ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ãŒè¡Œã‚ã‚ŒãŸã€‚ SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã¨ã¯ï¼Œå…¥åŠ›ã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ã«ã‚ˆã‚Šæ„å›³ã›ã–ã‚‹SQLæ–‡ãŒå®Ÿè¡Œã•ã‚Œã¦ã—ã¾ã†ã¨ã„ã†æ”»æ’ƒã§ã‚ã‚‹ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ã‚’æ›¸ãæ›ãˆã‚‰ã‚ŒãŸã‚Šï¼Œãƒ‡ãƒ¼ã‚¿ãŒèªã¿å‡ºã•ã‚Œã‚‹ã“ã¨ã«ã‚ˆã‚Šæƒ…å ±ãŒæ¼æ´©ã—ãŸã‚Šã™ã‚‹æã‚ŒãŒã‚ã‚‹ã€‚ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ãƒ»ãƒ›ãƒ¼ãƒ«ã¨ã„ã†ã¨Webã‚µãƒ¼ãƒãƒ¼ã‚„Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³è¨€èªžã®å°‚å£²ç‰¹è¨±ã ã¨ã„ã†å°è±¡ãŒã‚ã‚‹ãŒï¼Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã‚‚å˜åœ¨ã™ã‚‹ã€‚ååˆ†ãªæ³¨æ„ãŒå¿…è¦ã§ã‚ã‚‹ã€‚ ä»¥ä¸‹ï¼ŒSQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã®åŽŸç†ã¨ï¼ŒMySQLã«å˜åœ¨ã—ãŸå•é¡Œã®è©³ç´°ã¨ãã®å¯¾å¿œã«ã¤ã„ã¦è§£èª¬ã™ã‚‹ã€‚å•é¡Œã®ç™ºè¦‹ã‹ã‚‰ä¿®æ£ã«ã„ãŸã‚‹ã‚„ã‚Šã¨ã‚Šã¯Webä¸Šã§å…¬é–‹ã•ã‚Œã¦ãŠã‚Šï¼Œèª°ãŒã„ã¤å•é¡Œã‚’æŒ‡æ‘˜ã—ä¿®æ£ã—ãŸã®ã‹ã‚‚ãŸã©ã‚‹ã“ã¨ãŒã§ãã‚‹ã€‚ mysqli_real_escape_string()é–¢æ•°ã«ã‚ˆã‚‹SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã®é˜²æ¢ ãƒ—ãƒã‚°
ustam 2007/01/09
mysql

security

sqlã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³

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

PHP
ãƒªãƒ³ã‚¯
PHPã§addslashes()ã§ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ã—ã¦ã‚‚SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ãªç©´
â– data uriå¤‰æ›æ©Ÿ ã“ã‚Œã¯ããã‚Šã¾ã™ã€‚ãªã‚‹ã»ã©ã‰ã€‚ data:text/html;charset=utf-8;base64,aHR0cDovL2xhLm1hLmxhL21pc2MvanMvZGF0YS5odG1s â– Firefoxã§Windowsã®ã‚¯ãƒªãƒƒãƒ—ãƒœãƒ¼ãƒ‰ã«å€¤ã‚’è¨å®šã™ã‚‹æ–¹æ³• ä¸Šã‚’è¸ã¾ãˆã¦ã€‚ http://la.ma.la/misc/js/setclipboard_for_firefox.html http://la.ma.la/misc/js/setclipboard.txt Opera8.5ã§ã‚‚ã„ã‘ã¦ã‚‹æ°—ãŒã—ã¾ã™ã€‚ å¤–éƒ¨ã®ã‚µãƒ¼ãƒã‚’åˆ©ç”¨ã›ãšã«HTMLå˜ä½“ã§ã„ã‘ã¦ã„ã‚‹ã®ã¯ã€dataã‚¹ã‚ãƒ¼ãƒ ãŒæœ‰åŠ¹ã ã‹ã‚‰ã§ã™ãã€‚IE7ã§ã¯ã¾ã dataã‚¹ã‚ãƒ¼ãƒ ã£ã¦æœ‰åŠ¹ã˜ã‚ƒãªã„ã®ã§ã—ãŸã£ã‘ï¼Ÿ ãˆï¼Ÿã‚ªãƒ¼ãƒãƒ¼ãƒ•ãƒãƒ¼ã™ã‚‹ã‹ã£ã¦ï¼Ÿã—ãªã„ã§ã—ã‚‡ï¼ˆç¬‘ï¼‰ Firefoxã§ãƒ†ã‚ã‚¹ãƒˆã‚’ã‚¯ãƒªãƒƒãƒ—ãƒœãƒ¼ãƒ‰ã«ã‚³ãƒ”ãƒ¼ã™ã‚‹æ–¹æ³•::æœ€
ustam 2007/01/09
PHP

mySQL

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

SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³
ãƒªãƒ³ã‚¯
1