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

sometk id:sometk

MySQLã¨mysqlã«é–¢ã™ã‚‹sometkã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (32)

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

100ç§’ã§MySQLã®ãƒãƒ¼ã‚«ãƒ«ç’°å¢ƒã‚’Dockerã§ä½œã£ã¦ã€ãƒ‡ãƒ¼ã‚¿ã‚‚è‡ªå‹•ã§å…¥ã‚Œã‚‹ã€‚æœ€å¼·ã®SQLç·´ç¿’ç’°å¢ƒæ§‹ç¯‰æ³•
ã€2022/2/26 è¿½è¨˜ã€‘ ä¸»ã«ã¯ã¦ãƒ–ã‚³ãƒ¡ãƒ³ãƒˆã§æ§˜ã€…ãªã”æŒ‡æ‘˜ã‚’é ‚ã„ãŸã®ã§ã€ã‚¿ã‚¤ãƒˆãƒ«ã®ä¿®æ£ï¼†å†…å®¹ã‚’ä¸€éƒ¨è¿½è¨˜ã—ã¾ã—ãŸã€‚åˆ†ã‹ã‚Šã«ãã„ã‚¿ã‚¤ãƒˆãƒ«ã‚’ä»˜ã‘ã¦ã—ã¾ã„ç”³ã—è¨³ã”ã–ã„ã¾ã›ã‚“ã€‚ã”æŒ‡æ‘˜ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ã‚‚ã¨ã‚‚ã¨æœ¬è¨˜äº‹ã¯è‡ªåˆ†ç”¨ã®ãƒ¡ãƒ¢ã‚’å…¼ãã¦é§†ã‘å‡ºã—ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®äººãŒæ•°äººå‚è€ƒã«ã—ã¦ãã‚ŒãŸã‚‰ã„ã„ã‹ãªã€ç¨‹åº¦ã®æ°—æŒã¡ã§æ›¸ã„ãŸã‚‚ã®ã§ã—ãŸã€‚ ç¾åœ¨ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ã®ãƒ†ã‚¯ãƒŽãƒã‚¸ãƒ¼ã‚«ãƒ†ã‚´ãƒªãƒ¼ã§ 1 ä½ã«ãªã£ã¦ãŠã‚Šã€äºˆæƒ³ã® 1000 å€ä»¥ä¸Šã®äººã«è¦‹ã¦ã„ãŸã ã‘ã‚‹è¨˜äº‹ã«ãªã£ã¦ã—ã¾ã„ã¾ã—ãŸã€‚ ä»Šå¾Œã‚‚ç²¾é€²ã—ã¾ã™ã€ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ï¼ ç‰¹ã«ç†ç”±ã‚‚ãªããƒãƒ¼ã‚«ãƒ«ã« MySQL ã‚’å…¥ã‚Œã¦éŠã³ãŸããªã‚‹æ°—æŒã¡ã£ã¦å®šæœŸçš„ã«æ¹§ãã¾ã™ã‚ˆãã€‚ ç§ã¯æ¹§ãã¾ã™ã€åŠå¹´ã« 1 å›žãã‚‰ã„ã€‚ æ¥å‹™ã§ã¯ãƒ•ãƒãƒ³ãƒˆã‚’è§¦ã‚‹ã“ã¨ãŒå¤šãã€DB ã¯ãã‚Œã»ã©è§¦ã‚Šã¾ã›ã‚“ã€‚ ãã®ãŸã‚ä¹…ã€…ã« MySQL ã‚’ãƒãƒ¼ã‚«ãƒ«ã§ç«‹ã¡ä¸Šã’ã‚ˆã†ã¨ã™ã‚‹ã¨ã„ã¤ã‚‚æ‰‹é †ã‚’å¿˜ã‚Œã¦ã—ã¾ã£ã¦ã„ã¦ã€ãªã‚“
sometk 2022/02/26
æœ€è¿‘ã¡ã‚‡ã†ã©ä¼¼ãŸã‚ˆã†ãªã“ã¨ã‚’ã—ã¦ã„ãŸã€‚Mac OSã¯ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆã™ã‚‹ã¨gitãŒãŠã‹ã—ããªã£ã¦ã‚‹ã“ã¨ãŒã‚ã‚‹ã‚‚ã‚ˆã†ã€‚

2202

MySQL

docker
ãƒªãƒ³ã‚¯
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
ãƒªãƒ³ã‚¯
åˆå¿ƒè€…å‘ã‘MySQLã®å§‹ã‚æ–¹
1. åˆå¿ƒè€…å‘ã‘ MySQLã®å§‹ã‚æ–¹ MySQL Beginners Talk ã¨ã¿ãŸã¾ã•ã²ã‚ 2012-05-29 åˆå¿ƒè€…å‘ã‘MySQLã®å§‹ã‚æ–¹ - MySQL Beginners Talk Powered by Rabbit 1.0.6 2. è‡ªå·±ç´¹ä»‹ âœ“ ã¨ã¿ãŸã¾ã•ã²ã‚ âœ“ MySQLãƒ¦ãƒ¼ã‚¶ä¼š(ä»£è¡¨) âœ“ id:tmtms âœ“ @tmtms âœ“ Rubyã‹ã‚‰MySQLã‚’ä½¿ã†ãƒ©ã‚¤ãƒ–ãƒ©ãƒªæ›¸ã„ãŸã‚Š 1/80 åˆå¿ƒè€…å‘ã‘MySQLã®å§‹ã‚æ–¹ - MySQL Beginners Talk Powered by Rabbit 1.0.6
sometk 2012/05/30
æœ€è¿‘ã„ã˜ã£ã¦ãªã‹ã£ãŸã®ã§ã€ãŸã¾ã«ã¯èªã‚“ã§ã¿ã‚ˆã†ã€‚

MySQL

database
ãƒªãƒ³ã‚¯
Windowsï¼‹Apacheï¼‹MySQLï¼‹PHP/Perl/Pythonç’°å¢ƒã‚’ç°¡å˜ã«æ§‹ç¯‰ã§ãã‚‹ã€ŒAMPPSã€NOT SUPPORTED
sometk 2012/01/18
1201

Apache

php

MySQL

Windows

Python

Perl

web
ãƒªãƒ³ã‚¯
Webãƒ‡ã‚¶ã‚¤ãƒŠãƒ¼ã‚„ãƒŽãƒ³ãƒ—ãƒã‚°ãƒ©ãƒžãƒ¼ã«ãŠã™ã™ã‚ã—ãŸã„PHPã®å‹‰å¼·æ³•
ã¾ã£ãŸããƒ—ãƒã‚°ãƒ©ãƒ ã®ä¸‹åœ°ãŒãªã„äººãŒPHPã®å…¥é–€æ›¸ã‚’èªã‚€ã¨æŒ«æŠ˜ã™ã‚‹ã€‚ç†è€…ã¯ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã®ä¸‹åœ°ãŒã¾ã£ãŸããªã„ãƒŽãƒ³ãƒ—ãƒã‚°ãƒ©ãƒžãƒ¼ã§ã‚ã‚‹ã€‚æ•°å¹´å‰ã‹ã‚‰ã€PHPã®å‹‰å¼·ã‚’ã‚„ç‹¬å¦ã§ã¯ã˜ã‚ãŸã€‚PHPã®æœ¬ã¯ä½•å†Šè²·ã£ãŸã‹ã‚ã‹ã‚‰ãªã„ï¼ˆæ´‹æ›¸ã‚‚å«ã‚ã¦40å†Šä»¥ä¸Šã¯è²·ã£ã¦ããŸï¼‰ã€‚è²·ã£ã¦ã¯æŒ«æŠ˜ã®ç¹°ã‚Šè¿”ã—ã ã£ãŸã€‚ç¾åœ¨ã€ã¦ã‚‚ã¨ã«æ®‹ã£ãŸã®ã¯æ•°å†Šã§ã‚ã‚‹ã€‚ ä»¥ä¸‹ã¯ã€ä»Šå¾ŒPHPã‚’å®Œå…¨ãªç‹¬å¦ã§å‹‰å¼·ã—ãŸã„äººã®ãŸã‚ã®ãƒ¡ãƒ¢ã§ã‚ã‚‹ã€‚ è‰¯æœ¬ã§ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã®ä¸‹åœ°ã‚’ã¤ãã‚‹ æœ€åˆã®ã‚³ãƒ„ã¯ã„ããªã‚ŠPHPã®æœ¬ã«æ‰‹ã‚’å‡ºã•ãªã„ã“ã¨ã§ã‚ã‚‹ã€‚ã¨ãã«åˆå¿ƒè€…ã®æ–¹ãŒãƒãƒƒã‚¯ã«ãªã‚‹ã®ã¯æ¡ä»¶åˆ†å²ã€ãƒ«ãƒ¼ãƒ—ã€é…åˆ—ã‚ãŸã‚Šã§ã‚ã‚‹ã€‚ã“ã®ã‚ãŸã‚Šã¯PHPä»¥å¤–ã®æœ¬ã§å®šè©•ã®ã‚ã‚‹æœ¬ã‚’èªã‚“ã§åŸºç¤Žã‚’å›ºã‚ã¦ãŠããŸã„ã€‚ ã€Žæ–°ç‰ˆPerlè¨€èªžãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ãƒ¬ãƒƒã‚¹ãƒ³å…¥é–€ç·¨ã€ã‹ã€Žåˆã‚ã¦ã®ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚° ç¬¬2ç‰ˆã€ã®ã©ã¡ã‚‰ã‹ã‚’èªã‚“ã§ãŠã“ã†ã€‚å‰è€…ã¯Perlã€å¾Œè€…ã¯Rubyã®æœ¬ã§ã‚ã‚‹ãŒPHPã§ã‚‚åŸºç¤Žã¯åŒã˜ã§å½¹ã«ç«‹ã¤ã€‚
sometk 2011/10/15
1110

HTTP

amazon

MySQL

php

programming
ãƒªãƒ³ã‚¯
å‰Šé™¤ãƒ•ãƒ©ã‚°ã®ã¯ãªã—
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
ãƒªãƒ³ã‚¯
ã¯ã¦ãªãƒ–ãƒã‚° | ç„¡æ–™ãƒ–ãƒã‚°ã‚’ä½œæˆã—ã‚ˆã†
å¹å¥æ¥½ã‚³ãƒ³ã‚¯ãƒ¼ãƒ« ãƒªã‚¦ãƒžãƒã®èª¿åãŒæ‚ªã„ï¼è–¬ã®å‰¯ä½œç”¨ã‚‚ã‚„ã°ã„ï¼ å‰¯ä½œç”¨ã®ã›ã„ã§ã”é£¯ãŒå…¨ç„¶é£Ÿã¹ã‚‰ã‚Œãªããªã£ã¦é¡”ã‹ã‚‰ç—©ã›ã¦ã„ãã‚“ã ã‘ã©ã€ãŠè…¹ã¨ã‹ãŠå°»ã‹ã‚‰ç—©ã›ãŸã‚‰ã„ã„ã®ã«ã€‚è“„ãˆãŒã‚ã‚‹ã‹ã‚‰å¤šå°‘ç—©ã›ãŸã£ã¦ã¡ã‚‡ã†ã©ã„ã„ãã‚‹ã„ã‚„ã‘ã©ã€å¹¸è–„ãã†ã«è¦‹ãˆã‚‹ã‹ã‚‰é¡”ã¯å¤ªã£ãŸã¾ã¾ãŒã„ã„ãªãã€‚ ãŠâ€¦
sometk 2011/08/04
1108

MySQL

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

MySQL

database

reference
ãƒªãƒ³ã‚¯
DeNAãŒç¤¾å†…åˆ©ç”¨ã—ã¦ã„ã‚‹MySQLã®è‡ªå‹•ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒãƒ¼ãƒ„ãƒ¼ãƒ«ã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã§å…¬é–‹é–‹å§‹
MySQLãŒãƒ€ã‚¦ãƒ³ã—ãŸã¨ãã«è‡ªå‹•çš„ã«åˆ¥ã®MySQLã¸å‡¦ç†ã‚’å¼•ãç¶™ãã“ã¨ã§ã€é«˜å¯ç”¨æ€§ã‚’å®Ÿç¾ã™ã‚‹ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒãƒ¼ãƒ„ãƒ¼ãƒ«ã€ŒMySQL-MHA: MySQL Master High Availability manager and toolsã€ãŒã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã¨ã—ã¦å…¬é–‹ã•ã‚ŒãŸã“ã¨ã‚’ã€ä½œè€…ã®æ¾ä¿¡å˜‰ç¯„ï¼ˆã¾ã¤ã®ã¶ã‚ˆã—ã®ã‚Šï¼‰æ°ãŒãƒ–ãƒã‚°ã§ä¼ãˆã¦ã„ã¾ã™ã€‚ Yoshinori Matsunobu's blog: Announcing MySQL-MHA: "MySQL Master High Availability manager and tools" æ¾ä¿¡æ°ã¯ãƒ¢ãƒã‚²ãƒ¼ãªã©ã§çŸ¥ã‚‰ã‚Œã‚‹DeNAã«å‹¤å‹™ã—ã¦ãŠã‚Šã€MySQL-MHAã«ã‚ˆã‚‹è‡ªå‹•ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒãƒ¼æ©Ÿèƒ½ã¯DeNAã®ã‚¤ãƒ³ãƒ•ãƒ©é‹ç”¨ã‚’æ”¯ãˆã¦ã„ã‚‹ã¨ã®ã“ã¨ã€‚åŒæ°ã®ãƒ–ãƒã‚°ã‹ã‚‰å¼•ç”¨ã—ã¾ã™ã€‚ Difficulties of master failover is one of
sometk 2011/08/03
1108

MySQL

DeNA
ãƒªãƒ³ã‚¯
http://www.jqueryhelp.net/retrieving/json/
sometk 2011/08/01
1108

json

php

MySQL
ãƒªãƒ³ã‚¯
MSN Japan - ãƒ‹ãƒ¥ãƒ¼ã‚¹, å¤©æ°—, ãƒ¡ãƒ¼ãƒ« (Outlook, Hotmail), Bingæ¤œç´¢, Skype
sometk 2011/08/01
1108

php

MySQL

json
ãƒªãƒ³ã‚¯
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
ãƒªãƒ³ã‚¯
PHPã‹ã‚‰MySQLã¸ã®æ¤œç´¢
ï¼°ï¼¨ï¼°ã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ¤œç´¢ã«ã¤ã„ã¦å‹‰å¼·ã‚’ã¯ã˜ã‚ãŸã°ã‹ã‚Šã§åˆæ©çš„ãªè³ªå•ã‹ã¨æ€ã„ã¾ã™ãŒéŽåŽ»ãƒã‚°ã‚’èªã‚“ã§ã‚‚è§£æ±ºã—ãªã‹ã£ãŸãŸã‚è³ªå•ã„ãŸã—ã¾ã™ã€‚ ãŸã¨ãˆã°ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æ•™æŽˆåã‚„æŽˆæ¥åãªã©ã‚’åŽç´ã—ã¦ãŠã„ã¦PHPã§æ•™æŽˆåã‚’å…¥åŠ›ã™ã‚‹ã¨æŽˆæ¥åç‰ãŒè¡¨ç¤ºã•ã‚Œã‚‹ã‚ˆã†ã«ã™ã‚‹ã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’ä½œã‚ã†ã¨æ€ã£ã¦ã„ã‚‹ã®ã§ã™ãŒã†ã¾ãã„ãã¾ã›ã‚“ã€‚ å°‘ãªãã¨ã‚‚MySQLã§ã€Žç”°ä¸ã€ã¨ã„ã†æ•™æŽˆåã¯å…¥ã£ã¦ã„ã‚‹ã®ã§æ¤œç´¢ã™ã‚Œã°å‡ºã¦ãã‚‹ã¯ãšãªã®ã§ã™ãŒæ¤œç´¢ä»¶æ•°ãŒ0ä»¶ã«ãªã£ã¦ã—ã¾ã„ã¾ã™ã€‚ ãƒ†ã‚ã‚¹ãƒˆãƒœãƒƒã‚¯ã‚¹ã«å…¥åŠ›ã•ã‚ŒãŸæƒ…å ±ã‚’å—ã‘æ¸¡ã™ã¨ã“ã‚ã«åŽŸå› ãŒã‚ã‚‹æ°—ãŒã™ã‚‹ã®ã§ã™ãŒåŽŸå› ã¯ã‚ã‹ã‚Šã¾ã›ã‚“ã§ã—ãŸã€‚ ãŠã‚ã‹ã‚Šã«ãªã‚Šã¾ã—ãŸã‚‰ã”æ•™æŽˆãã ã•ã„ http://iskiso3.hustle.ne.jp/test.php <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html lang=
sometk 2011/07/28
å¤‰æ•°ã‚’æ‰±ã†ã«ã¯ä¸æ‹¬å¼§ä½¿ãˆã°è‰¯ã„ã¨ã„ã†ã®ã‚’çŸ¥ã‚‰ãªãã¦ãƒ»å¿˜ã‚Œã¦ã„ãŸã‚Šã—ã¦ã€ã“ã®ãƒšãƒ¼ã‚¸ã«ã¯ä½•åº¦ã‹åŠ©ã‘ã‚‰ã‚Œã¾ã—ãŸã€‚ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚

MySQL

php
ãƒªãƒ³ã‚¯
PHP+MySQLã§ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³
ã¨ã„ã†ã“ã¨ã§ä»Šå›žã¯PHP+MySQLã§ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã§ã™ã€‚ ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã¨ã¯é‡‘èžã®ã‚·ã‚¹ãƒ†ãƒ ã«å¿…è¦ä¸å¯æ¬ ãªå‡¦ç†ã§ã™ã€‚ ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã£ã¦ä½•ï¼Ÿã£ã¦æ–¹ã¯ã“ã“ã‚’ã”è¦§ã«ãªã£ã¦ ãã®é‡è¦æ€§ã‚’çŸ¥ã£ã¦ã„ãŸã ããŸã„ ã§ã¯ã‚½ãƒ¼ã‚¹ã§ã™ã€‚ <? if ( !extension_loaded( "mysql" ) ) { dl( "php_mysql.dll" ); } //æŽ¥ç¶šç”¨æ–‡å—åˆ— $Server = "ã‚µãƒ¼ãƒå"; $DbName = "ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å"; $User = "ãƒ¦ãƒ¼ã‚¶å"; $Password = "ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰"; //æŽ¥ç¶š $Connect = @mysql_connect( $Server, $User, $Password ); if( !$Connect ){ print "æŽ¥ç¶šã§ãã¾ã›ã‚“ã§ã—ãŸ"; exit(); } //DBã®é¸æŠž mysql_select_db( $DbN
sometk 2011/07/27
ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã®ã‚µãƒ³ãƒ—ãƒ«ã€‚34è¡Œã‚ã§ã‚ã–ã¨å¤±æ•—ã—ã¦ãƒãƒ¼ãƒ«ãƒãƒƒã‚¯ã‚’è¦‹ã›ã‚‹ã€ã¨ã€‚

MySQL

php

transaction
ãƒªãƒ³ã‚¯
ãƒãƒªãƒã®MySQLã‚µãƒ¼ãƒç§»å‹• â†’ å‹•ä½œåŠ‡çš„æ”¹å–„ (Unbridled blog)
ã“ã“ã‚“ã¨ã“ã€ãšãƒ¼ã£ã¨Movable typeã®CGIã‚¨ãƒ©ãƒ¼ã€å†æ§‹ç¯‰ã§ããšã€æœ€æ‚ªãªã®ã¯ã‚³ãƒ¡ãƒ³ãƒˆã‚’æ›¸ã„ã¦ã‚‚ã‚‰ã£ã¦ã‚‚ã‚¨ãƒ©ãƒ¼ãŒå‡ºã‚‹ã€ã¨ã„ã†çŠ¶æ…‹ãŒç¶šã„ã¦ã„ã¾ã—ãŸãŒã€è§£æ±ºã—ã¾ã—ãŸã€‚ ã‚„ã£ãŸã“ã¨ã¯ã€MySQLã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ã€è¿½åŠ ã•ã‚ŒãŸã°ã‹ã‚Šã®ã‚µãƒ¼ãƒã«ç§»è¡Œã™ã‚‹ã“ã¨ã§ã™ã€‚ ãƒãƒªãƒãƒƒãƒ—ã«å‹•ä½œãŒé‡ã„ã“ã¨ã‚’ãŸãšãã‚‹ã¨ã€Webã‚µãƒ¼ãƒã¯å•é¡Œãªã„ãŒã€MySQLã‚µãƒ¼ãƒãŒéŽè² è·çŠ¶æ…‹ã§è§£æ±ºã®è¦‹è¾¼ã¿ãŒãªãã€DBã®ç§»å‹•ã‚’å‹§ã‚ã‚‰ã‚ŒãŸã®ãŒçµŒç·¯ã€‚ ãŸã ãã®æ‰‹é †ã¯ã‚µãƒãƒ¼ãƒˆå¤–ãªã®ã§ã€ãƒ—ãƒã‚»ã‚¹ã‚’ä»¥ä¸‹ã«è¨˜ã—ã¾ã™ã€‚ (0. å¿µã®ãŸã‚Movable Typeè‡ªä½“ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’ã—ã¦ãŠãã€‚ å·¦ãƒãƒŠãƒ¼ã®ã€Œãƒ¦ãƒ¼ãƒ†ã‚£ãƒªãƒ†ã‚£ã€ï¼žã€Œèªã¿å‡ºã—/æ›¸ãå‡ºã—ã€ã‚’ã‚¯ãƒªãƒƒã‚¯ã€ã€Œã‚¨ãƒ³ãƒˆãƒªãƒ¼ã®æ›¸ãå‡ºã—ã€ã‚¿ãƒ–ã‚’ã‚¯ãƒªãƒƒã‚¯ã€ã€Œãƒ»ãƒ»ãƒ»ã‹ã‚‰ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã‚’æ›¸ãå‡ºã™ã€ãƒœã‚¿ãƒ³ã‚’æŠ¼ã™) 1. ãƒãƒªãƒãƒƒãƒ—ã®phpMyAdminã¸ãƒã‚°ã‚¤ãƒ³ http://user.lolipop.jp/pma/ã§
sometk 2011/07/27
ç§»å‹•ï¼ˆå‰Šé™¤ï¼‰ã™ã‚‹ã“ã¨ã§é«˜é€ŸåŒ–

MySQL

phpMyAdmin

lolipop
ãƒªãƒ³ã‚¯
array_push-é…åˆ—é–¢æ•°:é…åˆ—ã«è¦ç´ ã‚’è¿½åŠ -åˆå¿ƒè€…ã®PHPå…¥é–€
array_pushé–¢æ•°ã¯é…åˆ—ã«ä¸€ã¤ä»¥ä¸Šã®è¦ç´ ã‚’è¿½åŠ ã™ã‚‹é–¢æ•°ã§ã™ã€‚ ä»¥ä¸‹ã«array_pushé–¢æ•°ã®ä½¿ç”¨ä¾‹ã‚’ç¤ºã—ã¾ã™ã€‚ //array_push (é…åˆ—, è¿½åŠ è¦ç´ 1, è¿½åŠ è¦ç´ 2,...); $ar = array("PHP", "CGI"); array_push($ar, "Perl", "JAVA"); print_r($ar); ä¸€ç•ªç›®ã®å¼•æ•°ã«ã¯è¿½åŠ å…ˆã¨ãªã‚‹é…åˆ—ã‚’æŒ‡å®šã—ã€2ç•ªç›®ã®å¼•æ•°ä»¥é™ã«ã¯è¿½åŠ ã—ãŸã„è¦ç´ ã‚’ã‚«ãƒ³ãƒžã§åŒºåˆ‡ã£ã¦æŒ‡å®šã—ã¾ã™ã€‚ ä¸Šã®ä½¿ç”¨ä¾‹ã§ã¯é…åˆ—$arã«è¿½åŠ ã™ã‚‹è¦ç´ ã‚’äºŒã¤("Perl"ã¨"JAVA"ã‚’)æŒ‡å®šã—ã¦ã„ã¾ã™ã€‚ è¿½åŠ è¦ç´ ã¯æŒ‡å®šã—ãŸé…åˆ—ã®æœ€å¾Œã«é †ã«è¿½åŠ ã•ã‚Œã¦ã„ãã¾ã™ã€‚ ã“ã®å ´åˆã€array_pushé–¢æ•°ã«ã‚ˆã£ã¦äºŒã¤ã®è¦ç´ ãŒè¿½åŠ ã•ã‚Œã€ é…åˆ—$arã¯ Array ( [0] => PHP [1] => CGI [2] => Perl [3] => JAVA ) Â ã¨ã„ã†
sometk 2011/07/26
array

push

array_push

php

MySQL
ãƒªãƒ³ã‚¯
é…åˆ—ã¨ã—ã¦Mysqlã‹ã‚‰å€¤ã‚’å–å¾—ã™ã‚‹æ–¹æ³•ã‚’æ•™ãˆã¦ä¸‹ã•ã„ã€‚
ã„ã¤ã‚‚åŠ©ã‘ã¦ã„ãŸã ãã¾ã—ã¦ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãƒã‚§ãƒƒã‚¯ãƒœãƒƒã‚¯ã‚¹ã®å€¤ã‚’Mysqlã«ç™»éŒ²ã™ã‚‹ã¨ã“ã‚ã¾ã§ã¯ã§ãã¾ã—ãŸãŒã€ ä»Šåº¦ãã‚Œã‚’ã€ç¢ºèªãƒ»æ›´æ–°ç”»é¢ã«èªã¿è¾¼ã‚€æ–¹æ³•ã§ã¤ã¾ãšã„ã¦ã„ã¾ã™ã€‚ ã©ã†ãžã”æŒ‡å°Žã‚’ãŠé¡˜ã„è‡´ã—ã¾ã™ã€‚ Mysqlã‹ã‚‰ã€Œdays_idã€ã®å€¤ãŒã€Œ0,2,5ã€ã¨å–å¾—ã•ã‚Œã¦ã‚‚ å®Ÿéš›ã®ãƒã‚§ãƒƒã‚¯ãŒä»˜ãã®ãŒã€ã€Œ5ã€ã®ã¿ãªã£ã¦ã—ã¾ã„ã¾ã™ã€‚ é…åˆ—ã¨ã—ã¦Mysqlã‹ã‚‰å€¤ã‚’å–å¾—ã™ã‚‹æ–¹æ³•ã‚’æ•™ãˆã¦ä¸‹ã•ã„ã€‚ $res = mysql_query($sql); $i=0; foreach($labels as $label){ while ($row = mysql_fetch_array($res)) { $days_id = $row["days_id"]; } if($i==$days_id){ $checked = " checked"; echo "<label>\n<input type=\"c
sometk 2011/07/26
MySQL

php
ãƒªãƒ³ã‚¯
ãƒªãƒ³ã‚¯ãƒ‘ã‚¹ã€ã‚¤ãƒ¡ãƒ¼ã‚¸ãƒ‘ã‚¹ã®å‡ºåŠ›ã«ã¤ã„ã¦
ã“ã‚“ã«ã¡ã¯ã€ ç¾åœ¨ã€ãƒ–ãƒ©ã‚¦ã‚¶ã«è¡¨ç¤ºã•ã‚Œã‚‹ã‚½ãƒ¼ã‚¹ã®ãƒªãƒ³ã‚¯ã€ã‚¤ãƒ¡ãƒ¼ã‚¸ã®ãƒ‘ã‚¹ã‚’çµ¶å¯¾ãƒ‘ã‚¹ã§ã¯ãªããƒ«ãƒ¼ãƒˆãƒ‘ã‚¹ï¼ˆâ€™/â€™ã‹ã‚‰ãƒ•ã‚¡ã‚¤ãƒ«æŒ‡å®šï¼‰ã‹ã‚‰æŒ‡å®šå‡ºæ¥ãªã„ã‹ã¨æ€ã„è‰²ã€…ã¨èª¿ã¹ã¦ãŠã‚Šã¾ã™ãŒæœ‰åŠ¹ãªè§£æ±ºç–ãŒè¦‹ã¤ã‹ã‚Šã¾ã›ã‚“ã€‚ ãªãœã€ã“ã®ã‚ˆã†ãªã“ã¨ã‚’ã—ãŸã„ã®ã‹ã€å·®ã—æ”¯ãˆãªã‘ã‚Œã°ã€æ•™ãˆã¦ã‚‚ã‚‰ãˆã¾ã™ã‹ï¼Ÿ ã”é€£çµ¡ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ç†ç”±ã¨ã—ã¾ã—ã¦ã¯ãŒWPã‚’ä½¿ã„æ§˜ã€…ãªç·¨é›†ã‚’ã™ã‚‹éš›ã¯ã‚¨ãƒ‡ã‚£ã‚¿ç‰ã¯ä»•æ§˜ã›ãšç›´æŽ¥htmlã€SSSã‚³ãƒ¼ãƒ‰ã‚’è§¦ã‚Œã‚‹ã®ã§çµ¶å¯¾ãƒ‘ã‚¹ã§ã™ã¨ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ãŒè†¨å¤§ã«ãªã‚Šç·¨é›†ãŒã—ã¥ã‚‰ãï¼ˆã‚³ãƒ¼ãƒ‰ãŒè¦‹ã¥ã‚‰ããªã‚‹ï¼‰ä»¥å‰ã‹ã‚‰ç§ã¯ãƒ‘ã‚¹ã¯ãƒ«ãƒ¼ãƒˆãƒ‘ã‚¹ã‚’ä½¿ç”¨ã—ã¦ã„ãŸã¨è¨€ã†ã®ãŒç†ç”±ã§ã™ã€‚ ï¼ˆå€‹äººçš„ã«ã¯ãƒ‡ãƒƒãƒˆãƒªãƒ³ã‚¯ãŒèµ·ã“ã‚‰ãªã„ä¸€ç•ªã‚ˆã„è¨˜è¿°ã®ä»•æ–¹ã¨æ€ã£ã¦ãŠã‚Šã¾ã™ï¼‰ çµ¶å¯¾ãƒ‘ã‚¹å‡ºåŠ›ã¯ç†ç”±ãŒã‚ã‚ŠWPæ¨™æº–ã®ä»•æ§˜ã¨ãªã£ã¦ã„ã‚‹ã®ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ãŒWPã‚’å°Žå…¥ã—åˆ¶ä½œã—ãŸã¨è¨€ã‚ã‚Œã¦ã„ã‚‹ã‚µã‚¤ãƒˆã§ã„ãã¤ã‹ãƒ«ãƒ¼ãƒˆãƒ‘ã‚¹ã§è¨˜è¿°ã•ã‚ŒãŸã‚‚ã®ãŒã‚ã£ãŸã®ã§å‡ºæ¥ã‚Œã°è‡ªåˆ†ã®ç·¨é›†
sometk 2011/07/25
MySQL

wp

wordpress
ãƒªãƒ³ã‚¯
MySQLã®INSERTæ–‡ã§å¤‰æ•°å±•é–‹ãŒã§ãã¾ã›ã‚“ - OKWAVE
ã¯ã˜ã‚ã¾ã—ã¦ã€‚ MySQL+PHPåˆå¿ƒè€…ãªã®ã§ã™ãŒã€INSERTæ–‡ä¸ã§ã®å¤‰æ•°å±•é–‹ãŒã†ã¾ãã„ãã¾ã›ã‚“ã€‚ ãƒ•ã‚©ãƒ¼ãƒ ã‹ã‚‰å—ã‘å–ã£ãŸãƒ‡ãƒ¼ã‚¿ã‚’å˜ç´”ã«ãƒ¬ã‚³ãƒ¼ãƒ‰ã«è¿½åŠ ã™ã‚‹ã ã‘ãªã®ã§ã™ãŒã€ mysql_query('insert into area_tbl (area)values($area)'); areaã®ãƒ‡ãƒ¼ã‚¿åž‹ã¯ãƒ†ã‚ã‚¹ãƒˆã§ã€$areaã‚’ã‚¯ã‚©ãƒ¼ãƒ†ãƒ¼ã‚·ãƒ§ãƒ³ã§å›²ã‚ã°å½“ç„¶ã®ã”ã¨ããã®ã¾ã¾è¡¨ç¤ºã•ã‚Œã¦ã—ã¾ã„ã¾ã™ã—ã€äº‹å‰ã« $area = $_POST['area'] ã®å‡¦ç†ã‚’ã—ã¦ã‚‚ãƒ€ãƒ¡ã§ã™ã€‚ç›´å¾Œã« echo "$area" ã‚’ã™ã‚‹ã¨ãƒ•ã‚©ãƒ¼ãƒ ã«å…¥åŠ›ã—ãŸæ–‡å—åˆ—ãŒè¡¨ç¤ºã•ã‚Œã‚‹ã®ã§ã€ãƒ‡ãƒ¼ã‚¿ã®å—ã‘æ¸¡ã—ã¯ã†ã¾ãã„ã£ã¦ã„ã‚‹ã¨æ€ã„ã¾ã™ã€‚ã¾ãŸ ($area) ã®ä»£ã‚ã‚Šã«'ã‚ã„ã†ãˆãŠ'ã¨ã„ã‚Œã‚‹ã¨ã€ã‚ã„ã†ãˆãŠã€‘ã¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«åæ˜ ã•ã‚Œã‚‹ã®ã§ã€MySQLã¨PHPã®æ—¥æœ¬èªžå¯¾å¿œã®å•é¡Œã‚‚ãªã„ã¨æ€ã„ã¾ã™ã€‚ãªãœã§ã—ã‚‡ã†ã‹ï¼Ÿ ã”æŒ‡å°Žã®ã»ã©ã‚ˆã‚ã—
sometk 2011/07/24
MySQL

PHP

insert
ãƒªãƒ³ã‚¯
Macã®MAMPã§MySQLã®my.cnf(my.ini)ã‚’è¨å®šã™ã‚‹ã€‚ - [k]id[k]id
æ™®æ®µãƒãƒ¼ã‚«ãƒ«ç’°å¢ƒã§MAMPã‚’ã—ã‚ˆã†ã—ã¦ã„ã‚‹ã®ã§ã™ãŒã€ buffer_sizeã‚’å¤‰æ›´ã—ãŸãã€ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚’èªã‚“ã ã¨ã“ã‚ MAMPã«ã¯ä»¥ä¸‹ã®å ´æ‰€ã«my.cnfã®ã‚µãƒ³ãƒ—ãƒ«ãŒç”¨æ„ã•ã‚Œã¦ã„ã‚‹ã‚ˆã†ã§ã™ã€‚ /MAMP/Library/share/mysql/ ã« my-large.cnf my-midium.cnf my-small.cnf ãŒç”¨æ„ã•ã‚Œã¦ãŠã‚Š ã“ã‚Œã‚’ /MAMP/db/mysql/ ã« my.cnf ã¨åå‰ã‚’å¤‰æ›´ã™ã‚‹ã€‚ ã¨è¨å®šã•ã‚Œã‚‹ã¿ãŸã„ã§ã™ãã€‚
sometk 2011/07/20
MAMP

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