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

ytesaki id:ytesaki

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

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

Tag2Find MOONGIFT
ãƒ•ã‚¡ã‚¤ãƒ«ã‚‚ã‚¿ã‚°ç®¡ç† ã™ã£ã‹ã‚Šå®šç€ã—ãŸã‚¿ã‚°ç®¡ç†ã€‚ãƒ•ã‚¡ã‚¤ãƒ«ã®ç®¡ç†ã«ã‚‚å°Žå…¥ã—ã‚ˆã†ã€‚ ãƒ•ã‚¡ã‚¤ãƒ«ã‚‚ã‚¿ã‚°ç®¡ç† æƒ…å ±ã‚’ã‚¿ã‚°ã§ç®¡ç†ã™ã‚‹ã¨è¨€ã†ã®ã¯ã€Web2.0ç³»ï¼ˆã¨è¨€ã†ã®ã‚‚æ›–æ˜§ã ãŒï¼‰ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§æ•°å¤šãå–ã‚Šå…¥ã‚Œã‚‰ã‚Œã‚‹ã‚ˆã†ã«ãªã£ã¦ããŸã€‚æ—¢ã«é•å’Œæ„Ÿãªãæ‰±ã£ã¦ã„ã‚‹äººã‚‚å¤šã„ã®ã§ã¯ãªã„ã ã‚ã†ã‹ã€‚ ãã‚Œã™ã‚‰é€šã‚Šè¶Šã—ã€ä½•ã§ã‚‚ã‚¿ã‚°ãŒãªã‘ã‚Œã°ã¨æ€ã£ã¦ã„ã‚‹æ–¹ã¯ã“ã‚Œã‚’ä½¿ã£ã¦ã¿ã‚‹ã¨ã„ã„ã€‚ ä»Šå›žç´¹ä»‹ã™ã‚‹ãƒ•ãƒªãƒ¼ã‚¦ã‚§ã‚¢ã¯Tag2Findã€Windowsã«ã‚¿ã‚°æ©Ÿèƒ½ã‚’ã¤ã‘ã‚‹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã ã€‚ Tag2Findã‚’ä½¿ãˆã°ã€Windowsä¸Šã®ãƒ•ã‚¡ã‚¤ãƒ«ã«ã¤ã„ã¦ã‚¿ã‚°ç®¡ç†ã§ãã‚‹ã‚ˆã†ã«ãªã‚‹ã€‚å‹¿è«–ã€å…¨ã¦ã®ãƒ•ã‚¡ã‚¤ãƒ«ã«è¡Œã†å¿…è¦ã¯ãªã„ã€‚å¿…è¦ã ã¨æ€ã£ãŸãƒ•ã‚¡ã‚¤ãƒ«ã«ã ã‘ã‚¿ã‚°ã‚’ã¤ã‘ã‚ˆã†ã€‚ å¾Œã¯ã‚¿ã‚¹ã‚¯ãƒãƒ¼ã«ãªã‚‹æ¤œç´¢ã‚¦ã‚£ãƒ³ãƒ‰ã‚¦ã§ã€ã‚¿ã‚°æ–‡å—åˆ—ã‚’å…¥åŠ›ã™ã‚Œã°å³åº§ã«çµæžœãŒå¾—ã‚‰ã‚Œã‚‹ã€‚ã¾ãŸã€ãƒ—ãƒ¬ãƒ“ãƒ¥ãƒ¼ã‚„ãƒ•ã‚¡ã‚¤ãƒ«æƒ…å ±ã‚’è¦‹ã‚‰ã‚Œã‚‹å°‚ç”¨ã®ãƒ•ã‚¡ã‚¤ãƒ«ç®¡ç†ã‚¤ãƒ³ã‚¿ãƒ•ã‚§ãƒ¼ã‚¹ã‚‚ã‚ã‚‹ã€‚ Tag2Find
ytesaki 2007/01/15
php

MySQL
ãƒªãƒ³ã‚¯
DSASé–‹ç™ºè€…ã®éƒ¨å±‹:5åˆ†ã§ã§ãã‚‹ã€MySQLã®ãƒ¡ãƒ¢ãƒªé–¢ä¿‚ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ï¼
MySQLã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«ãŠã„ã¦éžå¸¸ã«é‡è¦ã¨ãªã‚‹ãƒ¡ãƒ¢ãƒª(ãƒãƒƒãƒ•ã‚¡)é–¢é€£ã®ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã«ã¤ã„ã¦ã€ ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ãƒã‚¤ãƒ³ãƒˆ DSASã®ã¨ã‚ã‚‹DBã‚µãƒ¼ãƒ(å®Ÿãƒ¡ãƒ¢ãƒª4GB)ã®å®Ÿéš›ã®è¨å®šå€¤ ã‚’ã¾ã¨ã‚ã¦ã¿ã¾ã™ã€‚ ã¾ãŸã€å¿…è¦ãƒ¡ãƒ¢ãƒªã®ç·é‡ã®è¨ˆç®—ã‚„é™ç•Œå€¤ã‚’è¶Šãˆã¦ãªã„ã‹ãƒã‚§ãƒƒã‚¯ã—ã¦ãã‚Œã‚‹ã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚‚ç´¹ä»‹ã—ã¾ã™ã€‚ æ˜¯éžã€å‚è€ƒã«ã—ã¦ã¿ã¦ãã ã•ã„ï¼ ã¾ãšæœ€åˆã«æ³¨æ„ç‚¹ã‚’ã€‚ ãƒãƒƒãƒ•ã‚¡ã«ã¯2ã¤ã®ã‚¿ã‚¤ãƒ—ãŒã‚ã‚Šã¾ã™ã€‚ ã‚°ãƒãƒ¼ãƒãƒ«ãƒãƒƒãƒ•ã‚¡ ã‚¹ãƒ¬ãƒƒãƒ‰ãƒãƒƒãƒ•ã‚¡ ã‚°ãƒãƒ¼ãƒãƒ«ãƒãƒƒãƒ•ã‚¡ã¯mysqldå…¨ä½“ã§ãã®ãƒãƒƒãƒ•ã‚¡ãŒ1ã¤ã ã‘ç¢ºä¿ã•ã‚Œã‚‹ã‚‚ã®ã§ã€ ã“ã‚Œã«å¯¾ã—ã€ ã‚¹ãƒ¬ãƒƒãƒ‰ãƒãƒƒãƒ•ã‚¡ã¯ã‚¹ãƒ¬ãƒƒãƒ‰(ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³)ã”ã¨ã«ç¢ºä¿ã•ã‚Œã‚‹ã‚‚ã®ã§ã™ã€‚ ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®éš›ã«ã¯ã‚°ãƒãƒ¼ãƒãƒ«/ã‚¹ãƒ¬ãƒƒãƒ‰ã®é•ã„ã‚’æ„è˜ã™ã‚‹ã‚ˆã†ã«ã—ã¾ã—ã‚‡ã†ã€‚ ãªãœãªã‚‰ã€ã‚¹ãƒ¬ãƒƒãƒ‰ãƒãƒƒãƒ•ã‚¡ã«å¤šãã®ãƒ¡ãƒ¢ãƒªã‚’å‰²ã‚Šå½“ã¦ã‚‹ã¨ã€ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãŒå¢—ãˆãŸã¨ãŸã‚“ã«ã‚¢ãƒƒã¨ã„ã†é–“ã«ãƒ¡ãƒ¢ãƒªä¸è¶³ã«ãªã£ã¦ã—ã¾ã†ã‹ã‚‰ã§ã™ã€‚ in
ytesaki 2006/12/27
MySQL

tuning
ãƒªãƒ³ã‚¯
mysql ã‚’é«˜é€ŸåŒ–ã—ãŸã„ã¨ãã«èªã‚€ãƒ¡ãƒ¢ (TechKnowledge)
çµ¦æ–™ã®æŒ¯è¾¼å£åº§ã¨ã—ã¦ä¸‰äº•ä½å‹éŠ€è¡Œã«å£åº§ã‚’æŒã£ã¦ã„ã¾ã™ã€‚è‡ªå‹•æ”¯æ‰•ã„ã‚µãƒ¼ãƒ“ã‚¹ã‚’ä½¿ç”¨ã—ã¦å…‰ç†±è²»ç‰ã®å…¬å…±æ–™é‡‘ã®æ”¯æ‰•ã„ã‚’ã—ã¦ã„ã¾ã™ãŒã€å…ˆæ—¥ãã‚Œã‚‰ã®å†…ã®ä¸€ã¤ã‚’å¤±å¿µã—ã¦ãŸã“ã¨ã«æ°—ã¥ãã¾ã—ãŸã€‚å£åº§ã‚’ç¢ºèªã—ãŸæ™‚ã«ã¯ã™ã§ã«å¼•ãè½ã¨ã—ãŒå®Œäº†ã—ã¦ã„ãŸãŸã‚ã€æ‰‹å…ƒã®è³‡é‡‘ãŒå¿ƒç´°ããªã£ãŸçŠ¶æ…‹ã§æ•°æ—¥ã‚’éŽã”ã•ãªã‘ã‚Œã°ãªã‚Šã¾ã›ã‚“ã€‚ä¸‰äº•ä½å‹éŠ€è¡Œã§å³æ—¥ã‚ãƒ£ãƒƒã‚·ãƒ³ã‚°ãŒå¯èƒ½ã§ã‚ã‚Œã°ã€æ˜¯éžåˆ©ç”¨ã—ãŸã„ã®ã§ã™ãŒã€‚ é‹ãŒè‰¯ã‘ã‚Œã°ã€ä¸‰äº•ä½å‹éŠ€è¡Œã®å³æ—¥ã‚ãƒ£ãƒƒã‚·ãƒ³ã‚°ã¯å¯èƒ½ ä¸‰äº•ä½å‹éŠ€è¡Œã®ç‰¹å¾´ã¯ã¾ãšã‚¯ãƒ¬ã‚¸ãƒƒãƒˆã‚«ãƒ¼ãƒ‰ä¼šç¤¾ã¨ã®é€£æºã—ãŸã‚µãƒ¼ãƒ“ã‚¹ãŒé…åŠ›çš„ãªã“ã¨ãŒã‚ã’ã‚‰ã‚Œã¾ã™ã€‚ã‚ãƒ£ãƒƒã‚·ãƒ³ã‚°ã§ã¯éŠ€è¡Œã‚«ãƒ¼ãƒ‰ãƒãƒ¼ãƒ³ã§ã™ã‹ã‚‰ã€ä½•ã‚ˆã‚Šå®‰ã„é‡‘åˆ©ãŒå¤§ãã„åˆ©ç‚¹ã«ãªã‚Šã¾ã™ã€‚æ¦‚ãéŠ€è¡Œç³»ã®å¯©æŸ»ã«å¿…è¦ãªæ™‚é–“ã¯é•·ããªã‚‹ã‚ˆã†ã§ã™ãŒã€ä¸‰äº•ä½å‹éŠ€è¡Œã§ã¯ã‚«ãƒ¼ãƒ‰ç™ºè¡ŒãŒå½“æ—¥ã«è¡Œãªã£ã¦ãã‚Œã¾ã™ã€‚ ä¸‰äº•ä½å‹éŠ€è¡Œã¯å³æ—¥ã‚ãƒ£ãƒƒã‚·ãƒ³ã‚°ãŒã§ãã‚‹ã‹ã¨è¨€ã†ã¨å¾®å¦™ãªã“ã¨ã«ãªã‚Šã¾ã™ã€‚ç”³è¾¼ã‹ã‚‰å¯©æŸ»çµæžœã®é€£çµ¡ã¾ã§ã¯ã€åœŸæ—¥
ytesaki 2006/11/28
MySQL

tuneup
ãƒªãƒ³ã‚¯
MySQL æ–‡å—åŒ–ã‘å•é¡Œã‚’æœ¬æ°—ã§ç›´ã™
mysql> status; -------------- mysql Ver 14.7 Distrib 4.1.20, for redhat-linux-gnu (i386) using readline 4.3 Connection id: 36 Current database: staff2006 Current user: maiha@localhost SSL: Not in use Current pager: lv Using outfile: '' Using delimiter: ; Server version: 4.1.20 Protocol version: 10 Connection: Localhost via UNIX socket Server characterset: latin1 Db characterset: latin1 Client char
ytesaki 2006/10/20
MySQL

tips
ãƒªãƒ³ã‚¯
ã€ãƒã‚¦ãƒ„ãƒ¼ã€‘ã“ã‚Œã¯ä¾¿åˆ©! MySQL/PostgreSQLã«ã‚‚å¯¾å¿œ - RDBMSæ“ä½œãƒ„ãƒ¼ãƒ«\"Execute Query\" (1) ã„ã‚ã„ã‚RDBMSç®¡ç†ãƒ„ãƒ¼ãƒ« (MYCOMã‚¸ãƒ£ãƒ¼ãƒŠãƒ«)
ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®Rerational Database Management Ssystem(RDBMS)ã®é›„ã¨ã„ãˆã°MySQLã¨PostgreSQLã€‚ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«çµ„ã¿è¾¼ã‚“ã§ä½¿ã†ã‚¿ã‚¤ãƒ—ã®RDBMSã¾ã§åºƒã’ã‚Œã°Apache Derbyã€H2ã€HSQL DBãªã©ã‚‚äººæ°—ãŒã‚ã‚‹ãŒã€æ±Žç”¨çš„ã«å¹…åºƒãä½¿ã‚ã‚Œã¦ã„ã‚‹FLOSS RDBMSã¨ãªã‚‹ã¨ã€ã‚„ã¯ã‚ŠMySQLã¨PostgreSQLã®2ã¤ã¨ãªã‚‹ã ã‚ã†ã€‚ ã“ã®2ã¤ã®RDBMSã«å…±é€šã—ãŸç‰¹å¾´ã«ã€å‘¨è¾ºãƒ„ãƒ¼ãƒ«ãŒå……å®Ÿã—ã¦ã„ã‚‹ã¨ã„ã†ã“ã¨ãŒã‚ã‚‹ã€‚10å¹´ã¾ãˆã§ã‚ã‚Œã°ç®¡ç†ã«CUIãƒ„ãƒ¼ãƒ«ã‚’ä½¿ã†ã“ã¨ã«é•å’Œæ„Ÿã¯ãªã‹ã£ãŸãŒã€ç¾åœ¨ã§ã¯å„ªã‚ŒãŸGUIãƒ„ãƒ¼ãƒ«ãŒã‚ã‚Šã€åºƒãåˆ©ç”¨ã•ã‚Œã¦ã„ã‚‹ã€‚ãŸã¨ãˆã°MySQLã«ã¯MySQL AdministratorãŒã€PostgreSQLã«ã¯pgAdmin IIIãŒç”¨æ„ã•ã‚Œã¦ã„ã‚‹ã€‚ å›³1.1 MySQLç®¡ç†ãƒ„ãƒ¼ãƒ« â€“ MySQL Administrato
ytesaki 2006/09/22
DataBase

MySQL

PostgreSQL

*
ãƒªãƒ³ã‚¯
ã‚¦ãƒŽã‚¦ãƒ©ãƒœ Unoh Labs: LVM + XFSã§é«˜é€Ÿç°¡å˜ MySQLãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—
GT Nitro: Car Game Drag Raceã¯ã€å…¸åž‹çš„ãªã‚«ãƒ¼ã‚²ãƒ¼ãƒ ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ã“ã‚Œã¯ã‚¹ãƒ”ãƒ¼ãƒ‰ã€ãƒ‘ãƒ¯ãƒ¼ã€ã‚¹ã‚ãƒ«å…¨é–‹ã®ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã‚²ãƒ¼ãƒ ã§ã™ã€‚ãƒ–ãƒ¬ãƒ¼ã‚ã¯å¿˜ã‚Œã¦ã€ã“ã‚Œã¯ãƒ‰ãƒ©ãƒƒã‚°ãƒ¬ãƒ¼ã‚¹ã€ãƒ™ã‚¤ãƒ“ãƒ¼ï¼å¤å…¸çš„ãªã‚¯ãƒ©ã‚·ãƒƒã‚¯ã‹ã‚‰æœªæ¥çš„ãªãƒ“ãƒ¼ã‚¹ãƒˆã¾ã§ã€æœ€ã‚‚ã‚¯ãƒ¼ãƒ«ã§é€Ÿã„è»Šã¨ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã§ãã¾ã™ã€‚ã‚¹ãƒ†ã‚£ãƒƒã‚¯ã‚·ãƒ•ãƒˆã‚’ãƒžã‚¹ã‚¿ãƒ¼ã—ã€ãƒ‹ãƒˆãƒã‚’è³¢ãä½¿ã£ã¦ç«¶äº‰ã‚’æ‰“ã¡ç ´ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ã“ã®ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã‚²ãƒ¼ãƒ ã¯ãã®ãƒªã‚¢ãƒ«ãªç‰©ç†å¦ã¨ç´ æ™´ã‚‰ã—ã„ã‚°ãƒ©ãƒ•ã‚£ãƒƒã‚¯ã‚¹ã§ã‚ãªãŸã®å¿ƒã‚’çˆ†ç™ºã•ã›ã¾ã™ã€‚ã“ã‚Œã¾ã§ãƒ—ãƒ¬ã‚¤ã—ãŸã“ã¨ã®ãªã„ã‚ˆã†ãªã‚‚ã®ã§ã™ã€‚ GT Nitroã¯ã€ãƒªãƒ•ãƒ¬ãƒƒã‚¯ã‚¹ã¨ã‚¿ã‚¤ãƒŸãƒ³ã‚°ã‚’è©¦ã™ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã‚²ãƒ¼ãƒ ã§ã™ã€‚æ£ã—ã„çž¬é–“ã«ã‚®ã‚¢ã‚’ã‚·ãƒ•ãƒˆã—ã€ã‚¬ã‚¹ã‚’æ€ã„åˆ‡ã‚Šè¸ã‚€å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ã¾ãŸã€å¤§ç‰©ãŸã¡ã¨ç«¶ã„ã¤ã¤ã€è»Šã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¨ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ã‚‚è¡Œã‚ãªã‘ã‚Œã°ãªã‚Šã¾ã›ã‚“ã€‚ä¸–ç•Œä¸ã§æœ€é«˜ã®ãƒ‰ãƒ©ã‚¤ãƒãƒ¼ã¨è»Šã¨ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã«æŒ‘ã‚€ã“ã¨ã«ãªã‚Šã€ãƒ‰ãƒ©ãƒƒã‚°ãƒ¬ãƒ¼ã‚¹ã®çŽ‹å†
ytesaki 2006/09/06
mysql

backup
ãƒªãƒ³ã‚¯
naoyaã®ã¯ã¦ãªãƒ€ã‚¤ã‚¢ãƒªãƒ¼ - MySQL ã®è² è·åˆ†æ•£ã« LVS + keepalived ã‚’ä½¿ã†
ã‚ã¨ã§æ›¸ãã€ã¨è¨€ã£ãŸæ‰‹å‰ãªã®ã§æ›¸ãã¨ã—ã¾ã™ã€‚ DSASã®ä¸ã®äººãŒã™ã”ã„å‹¢ã„ã§ LVS ã®è©±ã‚’æ›¸ã„ã¦ãã‚Œã¦ã¾ã™ã€‚ã“ã®è¾ºã€‚LVS ã‚’ä½¿ã†ã¨ Linux ã¨ç®±ã§ãƒãƒ¼ãƒ‰ãƒãƒ©ãƒ³ã‚µãŒä½œã‚Œã¡ã‚ƒã„ã¾ã™ã€‚æ™®é€šã«è²·ã£ãŸã‚‰æ•°ç™¾ä¸‡ã¨ã‹ã—ã¡ã‚ƒã†ã‚„ã¤ã€‚ DSAS ã®ä¸ã®ã²ã¨ã«æ„Ÿè¬ã—ã¤ã¤ã€ã„ã„æ©Ÿä¼šãªã®ã§ã‚„ã£ã¦ã¿ã‚ˆã†! ã¨æ€ã£ã¦ã„ã‚ã„ã‚è©¦ã—ã¦æ˜¨æ—¥ã‚ãŸã‚Šã‹ã‚‰ã¯ã¦ãªã®ä¸ã§ã‚‚ LVS + keepalived ã§å‹•ã‹ã—ã¯ã˜ã‚ã¦ã¾ã™ã€‚ã„ã¾ã®ã¨ã“ã‚å•é¡Œãªã—ã€‚ ãã®ãƒãƒ¼ãƒ‰ãƒãƒ©ãƒ³ã‚µã‚’ã©ã“ã«ä½¿ã£ã¦ã‚‹ã‹ã§ã™ãŒã€æ™®é€šãƒãƒ¼ãƒ‰ãƒãƒ©ãƒ³ã‚µã¨ã„ã†ã¨ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆã‹ã‚‰ã®å…¥ã‚Šå£ã®ã¨ã“ã‚ã«ç½®ã„ã¦ã‚¦ã‚§ãƒ–ã‚µãƒ¼ãƒãƒ¼ã®è² è·åˆ†æ•£ã«ä½¿ã†ã‚¤ãƒ¡ãƒ¼ã‚¸ãŒã‚ã‚Šã¾ã™ã€‚ãŒã€ä»Šå›žã¯ã¯ã¦ãªã§ã¯ MySQL ã®ã‚¹ãƒ¬ãƒ¼ãƒ–ã®æ‰‹å‰ã«ç½®ãã¨ã„ã†å½¹å‰²ã§ã¨ã‚Šã‚ãˆãšä½¿ã„ã¯ã˜ã‚ã¾ã—ãŸã€‚ +-----------+ +-----------+ | mod_perl | | mod_perl | +----
ytesaki 2006/09/02
linux

MySQL

load
ãƒªãƒ³ã‚¯
ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ–¹æ³•
å½±èˆžã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ–¹æ³• ã“ã“ã§ã¯ã€å½±èˆžã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ–¹æ³•ã«ã¤ã„ã¦è¨˜è¿°ã—ã¾ã™ã€‚ å½±èˆžãŒå‹•ä½œã™ã‚‹ãŸã‚ã«ã¯ã€Webã‚µãƒ¼ãƒ ã¨ Ruby ãŒå¿…è¦ã§ã™ãŒã€ ãã‚Œã‚‰ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ–¹æ³•ãªã©ã«ã¤ã„ã¦ã¯ã€ã“ã“ã§ã¯åŸºæœ¬çš„ã«è§£èª¬ã—ã¾ã›ã‚“ã€‚ ã¾ãŸã€Webã‚µãƒ¼ãƒã®è¨å®šã«ã¤ã„ã¦ã®è¨˜è¿°ã«ã¤ã„ã¦ã¯ã€ Apache ã‚’ãƒ™ãƒ¼ã‚¹ã«ã—ã¦ã„ã¾ã™ã®ã§ã€ åˆ©ç”¨ã™ã‚‹ç’°å¢ƒã«å¿œã˜ã¦é©æ™‚èªã¿æ›¿ãˆã¦ãã ã•ã„ã€‚ ç›®æ¬¡ Quick Start install_ja.rb ã‚’ç”¨ã„ãŸã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« mod_ruby ã®åˆ©ç”¨ FastCGI ã®åˆ©ç”¨ FastCGI ã®åˆ©ç”¨ (Windows/Apache2.2ã®å ´åˆ) PostgreSQL ã®åˆ©ç”¨ MySQL ã®ä½¿ç”¨ SQL Server ã®ä½¿ç”¨ RMagickã‚’ç”¨ã„ãŸç”»åƒèªè¨¼ GD, GDChart ã‚’ç”¨ã„ãŸã‚°ãƒ©ãƒ•ã®ä½œæˆ ãƒ¡ãƒ¼ãƒ«ã‚¤ãƒ³ã‚¿ãƒ•ã‚§ãƒ¼ã‚¹ã®è¨å®š æ‰‹å‹•ã§ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ä¾‹ Quic
ytesaki 2006/08/08
kagemai

install

mysql
ãƒªãƒ³ã‚¯
goo
ãƒãƒƒãƒ†ãƒªã‚¢ãƒ•ã‚©ãƒãƒ¼ ãƒ‰ãƒ³ãƒ»ã‚ãƒ›ãƒ¼ãƒ†ãƒ•ã‚©ãƒãƒ¼ å²é˜œçœŒãƒ•ã‚©ãƒãƒ¼ å²é˜œçœŒç¾Žæ¿ƒåŠ èŒ‚å¸‚ãƒ•ã‚©ãƒãƒ¼ å¤–é£Ÿãƒ»é£²é£Ÿã‚µãƒ¼ãƒ“ã‚¹ãƒ•ã‚©ãƒãƒ¼
ytesaki 2006/08/07
MySQL

server

tips
ãƒªãƒ³ã‚¯
PHPã¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«é–¢ã™ã‚‹5ã¤ã®å•é¡Œã€ã¨ãã®è§£æ±ºæ³• - GIGAZINE
IBMã®ã‚µã‚¤ãƒˆã«ã€PHPã‹ã‚‰æ“ä½œã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«é–¢ã—ã¦ã‚ˆãè¦‹ã‚‰ã‚Œã‚‹5ã¤ã®å•é¡Œç‚¹ã¨ãã®è§£æ±ºæ–¹æ³•ãŒæŽ²è¼‰ã•ã‚Œã¦ã„ã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ‡ã‚¶ã‚¤ãƒ³ã‚’ã™ã‚‹éš›ã€ä¸€èˆ¬çš„ã«ç™ºç”Ÿã™ã‚‹å•é¡Œç‚¹ã«ã¤ã„ã¦ã®è§£èª¬ã§ã™ã€‚ ã§ã€è‚å¿ƒã®5ã¤ã®å•é¡ŒãŒä½•ã‹ã¨ã„ã†ã¨ã€ä»¥ä¸‹ã®é€šã‚Šã€‚ Five common PHP database probl ems 1ã¤ã‚ã¯å¤ã„PHPã®ã‚³ãƒ¼ãƒ‰ã§ã¯ç›´æŽ¥ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã‚¢ã‚¯ã‚»ã‚¹ã—ã¦ã„ã‚‹ã¨ã„ã†ã“ã¨ã€‚ã‚³ãƒ¬ã«ä»£ã‚ã‚‹æ‰‹æ®µã¨ã—ã¦ã¯ã€PEARã®DBãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚’ä½¿ã†ã‹ã€ã‚ã‚‹ã„ã¯PHPãƒ‡ãƒ¼ã‚¿ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã€PDOã®ã‚¯ãƒ©ã‚¹ã‚’ä½¿ãˆã€ã¨ã‚ã‚Šã¾ã™ã€‚ 2ã¤ã‚ã¯ã€ã‚ªãƒ¼ãƒˆã‚¤ãƒ³ã‚¯ãƒªãƒ¡ãƒ³ãƒˆã‚’ä½¿ã‚ãªã„ã¨ã„ã†ã“ã¨ã€‚MySQLã¯åŸºæœ¬çš„ã«ãƒ¬ã‚³ãƒ¼ãƒ‰1ã¤ã«ã¤ã„ã¦ãƒ¦ãƒ‹ãƒ¼ã‚¯ãªIDã‚’ã‚ªãƒ¼ãƒˆã‚¤ãƒ³ã‚¯ãƒªãƒ¡ãƒ³ãƒˆã—ã¦ã„ã‚‹ã‚ã‘ã§ã™ãŒã€ã“ã‚Œã‚’æ´»ç”¨ã—ã¦ã„ãªã„ã¨ã„ã†ãƒ‘ã‚¿ãƒ¼ãƒ³ã€‚ã‚ªãƒ¼ãƒˆã‚¤ãƒ³ã‚¯ãƒªãƒ¡ãƒ³ãƒˆã‚’æœ‰åŠ¹ã«ä½¿ã£ã¦ã„ãªã„å ´åˆã€éžåŠ¹çŽ‡çš„ã§ã‚ã‚‹ã ã‘ã§ãªãã€è² è·ã‚‚é«˜ããªã‚‹ãã†ã§ã™ã€‚è§£
ytesaki 2006/08/04
php

MySQL

tips

Eg
ãƒªãƒ³ã‚¯
MySQLã‚’è‡ªå‹•ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã™ã‚‹ã€ŒAutoMySQLBackupã€
ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã™ã‚‹ã®ãŒé¢å€’ãªMySQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’è‡ªå‹•çš„ã«ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã§ãã‚‹ã‚ˆã†ã«ãªã‚‹ã‚¹ã‚¯ãƒªãƒ—ãƒˆã§ã™ã€‚ ã„ãã¤ã‚‚ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä¸€æ‹¬ã§ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã§ãã¾ã™ã€‚1ã¤ã®ãƒ•ã‚¡ã‚¤ãƒ«ã¨ã—ã¦ã¾ã¨ã‚ã¦ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã™ã‚‹ã“ã¨ã‚‚ã§ãã‚‹ã—ã€å„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã”ã¨ã«åˆ†ã‘ã¦ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã™ã‚‹ã“ã¨ã‚‚ã§ãã¾ã™ã€‚ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãƒ•ã‚¡ã‚¤ãƒ«ã¯gzipã‹bzip2ã§åœ§ç¸®ã•ã‚Œã¦ã„ã‚‹ã®ã§ãƒ‡ã‚£ã‚¹ã‚¯å®¹é‡ã‚‚é£Ÿã„ã¾ã›ã‚“ã€‚ãƒªãƒ¢ãƒ¼ãƒˆã®MySQLã‚’ä¸å¤®ã®MySQLã«ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã—ãŸã‚Šã€ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã®ãƒã‚°ã‚’ãƒ¡ãƒ¼ãƒ«ã§é€ã‚‹ã“ã¨ã‚‚å¯èƒ½ã€‚ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã—ãŸãƒ•ã‚¡ã‚¤ãƒ«è‡ªä½“ã‚’ãƒ¡ãƒ¼ãƒ«ã§é€ã‚‹ã“ã¨ã‚‚ã§ãã¾ã™ã€‚ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¯cronã‚’ä½¿ã†ä»¥å¤–ã«æ‰‹å‹•ã§è¡Œã†ã“ã¨ã‚‚å¯èƒ½ãªã®ã§ã€cronãŒãªãã¦ã‚‚ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¯ã§ãã¾ã™ã€‚ ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã¨è©³ç´°ã¯ä»¥ä¸‹ã®é€šã‚Šã€‚ Automatic MySQL Backup SourceForge.net: AutoMySQLBackup æœ€å°é™ã®è¨å®šã§ã™ãã«ä½¿ã†
ytesaki 2006/07/30
MySQL

backup

Eg
ãƒªãƒ³ã‚¯
naoyaã®ã¯ã¦ãªãƒ€ã‚¤ã‚¢ãƒªãƒ¼ - MyISAM vs InnoDB
ã‚ãã¾ã§æ†¶æ¸¬ã§ä»®èª¬ã§ã—ã‹ãªã„ã‚“ã§ã™ãŒã€‚ MySQL ã®ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã®ã†ã¡ä»£è¡¨çš„ãªäºŒã¤ã€MyISAM ã¨ InnoDB ã¯ã‚ˆã MyISAM: Read ã¯é€Ÿã„ã‘ã©ãƒ†ãƒ¼ãƒ–ãƒ«ãƒãƒƒã‚¯ã®ãŸã‚ä¸¦è¡Œæ€§ãŒä½Žã„ã€‚é‹ç”¨ãŒç°¡å˜ã€‚ InnoDB: MyISAM ã‚ˆã‚Š Read ã¯é…ã„ã‘ã©ä¸¦è¡Œæ€§ãŒé«˜ã„ ã€‚è¡Œãƒ¬ãƒ™ãƒ«ãƒãƒƒã‚¯ãªã®ã§ã€‚ã‚ã¨ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚„å¤–éƒ¨ã‚ãƒ¼åˆ¶ç´„ã€‚é‹ç”¨ãŒ MyISAM ã‚ˆã‚Šã¡ã‚‡ã£ã¨ã‚ã‚“ã©ãã•ã„ã€‚ ã¨ã„ã†åŒºåˆ¥ãŒã•ã‚Œã¾ã™ã€‚ã“ã“ã‹ã‚‰è»¢ã˜ã¦ã€ MyISAM ã¯å‚ç…§ç³»ã‚¯ã‚¨ãƒªãŒå¤§éƒ¨åˆ†ã‚’å ã‚ã‚‹å ´åˆã«é©ç”¨ã™ã‚‹ã¨è‰¯ã„ã€‚ä¾‹ãˆã° blog ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨ã‹ã€‚ InnoDB ã¯æ›´æ–°ç³»ã‚¯ã‚¨ãƒªãŒå¤šã„å ´åˆã«é©ç”¨ã™ã‚‹ã¨è‰¯ã„ã€‚ ã¨è¨€ã‚ãŸã‚Šã—ã¾ã™ã€‚å®Ÿè·µãƒã‚¤ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹MySQL ã§ã‚‚ç¬¬2ç« ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³(ãƒ†ãƒ¼ãƒ–ãƒ«åž‹) P.30 ã« ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’ä½¿ç”¨ã™ã‚‹å¿…è¦ãŒãªãã€ä¸»ã« SELECT ã¾ãŸã¯ I
ytesaki 2006/07/29
MySQL

tips

Eg
ãƒªãƒ³ã‚¯
MySQLã‚’æ“ä½œã™ã‚‹ã€ŒMySQL Quick Adminã€ãŒã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹åŒ–
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã‚ã‚‹MySQLã‚’æ“ä½œã™ã‚‹ã€ŒMySQL Quick Adminã€ãŒã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹åŒ–ã•ã‚Œã€èª°ã§ã‚‚è‡ªç”±ã«ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¦ä½¿ã†ã“ã¨ãŒã§ãã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸã€‚åå‰ã®é€šã‚Šã€é«˜é€Ÿã«å‹•ä½œã™ã‚‹ã®ãŒã‚¦ãƒªã ãã†ã§ã€‚ ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã¯ä¸‹è¨˜ã‚µã‚¤ãƒˆã‹ã‚‰ã€‚ MySQL Quick Admin http://mysqlquickadmin.com/index.php æ©Ÿèƒ½ã‚„å¿…è¦ãªãƒ¢ãƒŽã¯ä»¥ä¸‹ã®é€šã‚Šã€‚ Feature Listãƒ»Requirements http://mysqlquickadmin.com/features.php ãƒ‡ãƒ¢ã«ã¯ä»¥ä¸‹ã‹ã‚‰ãƒã‚°ã‚¤ãƒ³ã§ãã¾ã™ã€‚ MySQL Quick Admin Demo http://demo.mysqlquickadmin.com/login.php åŒæ§˜ã®ã“ã¨ãŒã§ãã‚‹æœ‰åã©ã“ã‚ã¯ä»¥ä¸‹ã®é€šã‚Šã€‚ phpMyAdmin | MySQL Database Administra
ytesaki 2006/07/25
MySQL

php

Eg
ãƒªãƒ³ã‚¯
PHP MySQLãªè¶…é«˜æ©Ÿèƒ½CMS:MODx:phpspoté–‹ç™ºæ—¥èªŒ
MODx Content Management System | Home MODx is an open source PHP Application Framework that helps you take control of your online content. It empowers developers and advanced users to give as much control as desired to whomever they desire for day-to-day website content maintenance chores. PHP+MySQLãªè¶…é«˜æ©Ÿèƒ½CMS:MODxã€‚ ç®¡ç†ç”»é¢ãŒAjaxã«ãªã£ã¦ã„ãŸã‚Šã€æ¤œç´¢ã‚¨ãƒ³ã‚¸ãƒ³ãƒ•ãƒ¬ãƒ³ãƒ‰ãƒªURLã‚„ã‚ãƒ£ãƒƒã‚·ãƒ¥æ©Ÿèƒ½ã€ç°¡æ˜“ã‚¢ã‚¯ã‚»ã‚¹è§£æžæ©Ÿèƒ½ç‰ã€ã‹ãªã‚Šé«˜æ©Ÿèƒ½ãªCMSã®ã‚ˆã†ã§ã™ã€‚ MODxã‚’ä½¿ã£ãŸã‚µã‚¤ãƒˆã®ä¾‹ MO
ytesaki 2006/07/14
php

MySQL

CMS
ãƒªãƒ³ã‚¯
MySQLã‹ã‚‰ç›´æŽ¥JSONå½¢å¼ã«ã™ã‚‹ãŸã‚ã®ã‚¯ãƒ©ã‚¹:phpspoté–‹ç™ºæ—¥èªŒ
PHP Classes - Class: MySQL to JSON Convert data from MySQL query results into JSONMySQLã®æ¤œç´¢çµæžœã‚’å³åº§ã«JSONã«ã™ã‚‹ãŸã‚ã®ã‚¯ãƒ©ã‚¹ã€MySQL to JSONã€‚ SQLâ†’é€£æƒ³é…åˆ—â†’JSON ãŒ SQLâ†’JSONã«å‡ºæ¥ã‚‹ã£ã½ã„ã§ã™ã€‚ Ajaxã‹ã‚‰ãã®ã¾ã¾ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’ç‰½ããŸã„ã‚ˆã†ãªå ´åˆã«ä½¿ãˆãã†ã§ã™ãã€‚ å˜ç´”ã«ãƒ©ãƒƒãƒ‘ãƒ¼ã‚¯ãƒ©ã‚¹ã‚’ä½œã‚‹ã¨ã„ã†æ‰‹ã‚‚ã‚ã‚Šã¾ã™ãŒã€‚ é–¢é€£ã‚µã‚¤ãƒˆ PEAR::Services_JSON é–¢é€£ã‚¨ãƒ³ãƒˆãƒª XMLâ†’JSONå½¢å¼ã«ä¸€ç™ºã§å¤‰æ›:BadgerFish jsonç”¨PHPæ©Ÿèƒ½æ‹¡å¼µ php-json
ytesaki 2006/07/10
php

MySQL

JSON
ãƒªãƒ³ã‚¯
PHPã‹ã‚‰MySQLã‚’RESTã§æ“ä½œã™ã‚‹PHP REST SQL:phpspoté–‹ç™ºæ—¥èªŒ
PHP REST SQL: A HTTP REST interface to MySQL written in PHP PHP REST SQL was built and tested using Apache 2.0.45, PHP 4.3.4, and MySQL 3.23, although it should work with any version of PHP4 and MySQL and any HTTP server that will pass requests of all HTTP method types to PHP. PHPã‚’ä½¿ã£ã¦RESTã«ã‚ˆã‚‹MySQLæ“ä½œã‚’å¯èƒ½ã«ã™ã‚‹PHP REST SQLã€‚ ã‚µã‚¤ãƒˆä¸Šã®ä¾‹ã‚’è¦‹ã‚‹ã¨ã“ã‚ã«ã‚ˆã‚‹ã¨å…·ä½“çš„ã«ã€æ¬¡ã®ã‚ˆã†ãªRESTã‚¤ãƒ³ã‚¿ãƒ•ã‚§ãƒ¼ã‚¹ã«ã¦MySQLæ“ä½œãŒå¯èƒ½ã«ãªã‚‹æ¨¡æ§˜ã€‚ â—ãƒ‡ãƒ¼ã‚¿ã®å–å¾— SELECT * FROM tab
ytesaki 2006/07/10
MySQL

php

REST
ãƒªãƒ³ã‚¯
ã€ç‰¹é›†ã€‘MySQL Clusterã‚’è©¦ã™ - ã‚¯ãƒ©ã‚¹ã‚¿åŒ–ã—ãŸåˆ†æ•£ã‚¢ãƒ‰ãƒ¬ã‚¹å¸³ã‚’ã¤ãã‚‹ (MYCOMã‚¸ãƒ£ãƒ¼ãƒŠãƒ«)
Copyright (C) Mainichi Communications Inc. All rights reserved. æŽ²è¼‰è¨˜äº‹ã®ç„¡æ–è»¢è¼‰ã‚’ç¦ã˜ã¾ã™
ytesaki 2006/07/10
MySQL

scalability

cluster
ãƒªãƒ³ã‚¯
Apache+MySQL+PHPã‚’ä¸€æ‹¬ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹AppServ:phpspoté–‹ç™ºæ—¥èªŒ
AppServ Open Project - AppServNetwork.com Apache 1.3.34 PHP 4.4.1 MySQL 5.0.16 phpMyAdmin-2.5.7-pl1 Apache+MySQL+PHPã‚’ä¸€æ‹¬ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹AppServã€‚ MySQLã‚’ä½¿ã„ã‚„ã™ã„ã‚ˆã†ã€phpMyAdminã‚‚ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã§ãã‚‹ã‚ˆã†ã§ã™ã€‚ XAMPPÂ ã¨ä¼¼ãŸã‚ˆã†ãªã‚‚ã®ã§ã™ãŒã€Apache1.3ç³»ã‚‚ä½¿ãˆã‚‹ã®ãŒç‰¹å¾´ã§ã—ã‚‡ã†ã‹ã€‚ AddOnsã¨ã„ã†ã“ã¨ã§ã€drupalã‚„phpBBã€wordpressç‰ã‚‚ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«å½¢å¼ã§ç°¡å˜ã«ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«å‡ºæ¥ã‚‹ã£ã½ã„ã§ã™ãã€‚ é–¢é€£ã‚µã‚¤ãƒˆ XAMPP - é–‹ç™ºç’°å¢ƒä¸€æ‹¬ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« é–¢é€£ã‚¨ãƒ³ãƒˆãƒª Mac OSXã®phpé–‹ç™ºç’°å¢ƒ MAMP
ytesaki 2006/07/08
Apache

MySQL

php

install
ãƒªãƒ³ã‚¯
ã‚·ãƒ³ãƒ—ãƒ«ãªPHPã¨MySQLã®æœ€é©åŒ–æ–¹æ³•ã€Œå½“ãŸã‚Šå‰ã‚’ç©ã¿é‡ãã‚‹ã¨ç‰¹åˆ¥ã«ãªã‚‹ã€
å‰å›žã®è² è·MAXã€ã‚µãƒ¼ãƒé™¥è½å¯¸å‰ã§ã™ã‚ˆé¨’å‹•ã®ã¨ãã€æœ€çµ‚çš„ã«ã¯è‡ªåˆ†ã§æœ€é©åŒ–ã™ã‚‹å¿…è¦ãŒã‚ã‚‹ã®ã‹ã‚‚çŸ¥ã‚Œãªã„â€¦ã¨æ€ã£ã¦ã„ãŸã¨ãã«è¦‹ã¤ã‘ãŸãƒšãƒ¼ã‚¸ã§ã™ã€‚ MySQLã‚„PHPã§åŒã˜å‡¦ç†ã‚’ã™ã‚‹éš›ã«ã©ã†ã„ã†ãµã†ã«ã™ã‚Œã°ã‚ˆã‚Šè»½ã„ã®ã‹ã€ã¨ã„ã†åŸºæœ¬çš„ãªå¯¾ç–ã°ã‹ã‚Šã‚’é›†ã‚ã¦ã‚ã‚Šã¾ã™ã€‚ã©ã‚Œã‚‚ã“ã‚Œã‚‚ã‚ã¡ã“ã¡ã§æ—¢å‡ºã®ã‚‚ã®ã°ã‹ã‚Šã§ã™ãŒã€1ã‚«æ‰€ã«ã¾ã¨ã¾ã£ã¦ã„ã‚‹ã®ã§èªã¿ã‚„ã™ã„ã§ã™ã€‚ä¸ã«ã¯çŸ¥ã‚‰ãªã„ã®ã‚‚ã‚ã£ãŸã‚Šã™ã‚‹ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚ dublish.com - Simple Optimization for PHP and MySQL http://www.dublish.com/articles/10.html MySQLã§æ›¸ã‹ã‚Œã¦ã„ã‚‹æ–¹ã¯å‰²ã¨èªã‚“ã ã“ã¨ãŒã‚ã‚‹ã‚ˆã†ãªã®ãŒå¤šã‹ã£ãŸã§ã™ãŒã€PHPã®æ–¹ã¯è¨€ã‚ã‚Œã¦ã¿ã‚Œã°ãã†ã‹ã‚‚ã€ã¨ã„ã†ã‚ˆã†ãªã®ãŒå¤šã„ã€‚ä¸Šè¨˜ãƒšãƒ¼ã‚¸ã®ã‚³ãƒ¡ãƒ³ãƒˆæ¬„ã«ã‚‚ã„ã‚ã„ã‚ã¨æœ‰ç”¨ãªæ„è¦‹ãŒã‚ã‚‹ã®ã§ã€èªã¿é€²ã‚ã‚‹ã¨æ¥½ã—ã„ã€‚ ãã†ã„ãˆã°ä»¥
ytesaki 2006/07/08
thought

MySQL

php
ãƒªãƒ³ã‚¯
Excelã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚’MySQLã®ãƒ‡ãƒ¼ã‚¿å½¢å¼ã«å¤‰æ›:phpspoté–‹ç™ºæ—¥èªŒ
xls2mysql To ensure maximum compatibility please use Excel 97 filesPlease browse your Excel file and press send (Max file size for PHP upload : 2M)Excelã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚’MySQLã®ãƒ‡ãƒ¼ã‚¿å½¢å¼ã«å¤‰æ›ã™ã‚‹ã‚µãƒ¼ãƒ“ã‚¹ã€‚ xlsãƒ•ã‚¡ã‚¤ãƒ«ã‚’ã‚¢ãƒƒãƒ—ãƒãƒ¼ãƒ‰ã™ã‚‹ã“ã¨ã§ç°¡å˜ã«å¤‰æ›ã§ãã‚‹ã‚ˆã†ã§ã™ã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«ã®ãƒ‡ãƒ¼ã‚¿ã‚’Excelã§ç·¨é›†ã™ã‚‹ã£ã¦ãƒ—ãƒã‚°ãƒ©ãƒžä»¥å¤–ã®æ–¹ã«ã¯çµæ§‹ä¾¿åˆ©ã ã£ãŸã‚Šã—ã¾ã™ãŒã€ã“ã†ã„ã£ãŸã‚‚ã®ã§å¤‰æ›ã§ãã‚‹ã‚ˆã†ã«ã—ã¦ãŠãã¨ä¾¿åˆ©ã§ã™ãã€‚ PHPã‹ã‚‰Excelã‚’æ‰±ã†å ´åˆã€æ¬¡ã®PEARãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ãŒä¾¿åˆ©ã€‚ Spreadsheet_Excel_Writer Spreadsheet_Excel_Reader (proposal) Structures_DataGrid_R
ytesaki 2006/06/28
excel

xls

mysql

data

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