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

akaiho id:akaiho

mysqlã«é–¢ã™ã‚‹akaihoã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (30)

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

å¤§è¦æ¨¡ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ é–‹ç™ºã‹ã‚‰å¦ã‚“ã PHPï¼†MySQLå®Ÿè·µãƒ†ã‚¯ãƒ‹ãƒƒã‚¯
OSC 2011 Hokkaidoã®ç™ºè¡¨ã§ä½¿ç”¨ã—ãŸã‚¹ãƒ©ã‚¤ãƒ‰è³‡æ–™ã§ã™ã€‚ å¼Šç¤¾ãŒã€Œãƒ–ãƒ©ã‚¦ã‚¶ä¸‰å›½å¿—ã€ã‚„ã€Œè‹±é›„ã‚¯ã‚¨ã‚¹ãƒˆã€ã¨ã„ã£ãŸã‚²ãƒ¼ãƒ ã‚’ã€PHPï¼‹MySQLã§æ§‹ç¯‰ã—ã¦ããŸä¸Šã§ã€èº«ã«ã¤ã‘ãŸãƒŽã‚¦ãƒã‚¦ã‚„ã€æ³¨æ„ã™ã¹ãç®‡æ‰€ã€æŒ‡é‡ãªã©ã‚’ã¾ã¨ã‚ãŸè³‡æ–™ã¨ãªã£ã¦ã„ã¾ã™ã€‚Read less
akaiho 2011/06/17
mysql

php
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ–ã‚µãƒŸ2011ãƒ¬ãƒãƒ¼ãƒˆã€€åˆ©ç”¨è€…æ•°600ä¸‡äººã€äººæ°—ãƒãƒƒãƒˆã‚µãƒ¼ãƒ“ã‚¹ã€Œã‚¢ãƒ¡ãƒ¼ãƒãƒ”ã‚°ã€ã‚’æ”¯ãˆã‚‹ã‚¤ãƒ³ãƒ•ãƒ©æ§‹ç¯‰ã§å¦ã‚“ã ã“ã¨
CodeZineç·¨é›†éƒ¨ã§ã¯ã€ç¾å ´ã§æ´»èºã™ã‚‹ãƒ‡ãƒ™ãƒãƒƒãƒ‘ãƒ¼ã‚’ã‚¹ã‚¿ãƒ¼ã«ã™ã‚‹ãŸã‚ã®ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã€ŒDevelopers Summitã€ã‚„ã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ç”Ÿãã–ã¾ã‚’ãƒ–ãƒ¼ã‚¹ãƒˆã™ã‚‹ãŸã‚ã®ã‚¤ãƒ™ãƒ³ãƒˆã€ŒDevelopers Boostã€ãªã©ã€ã•ã¾ã–ã¾ãªã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã‚’ä¼ç”»ãƒ»é‹å–¶ã—ã¦ã„ã¾ã™ã€‚
akaiho 2011/03/31
mysql

kvs
ãƒªãƒ³ã‚¯
MySQLã®ç”Ÿã¿ã®è¦ªã€æ¥ç•Œå›£ä½“Open Database Allianceã‚’è¨ç«‹
åˆæœŸã®MySQLã‚’ä½œæˆã—ãŸMichael 'Monty' Wideniusæ°ãŒã€æ¥ç•Œå†…ã«ãŠã‘ã‚‹ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒãƒ–ã¨ã—ã¦æ©Ÿèƒ½ã™ã‚‹ã“ã¨ã‚’ç›®çš„ã¨ã—ãŸæ¥ç•Œå›£ä½“Open Database Allianceï¼ˆODAï¼‰ã‚’è¨ç«‹ã—ãŸã€‚ ãƒ™ãƒ³ãƒ€ãƒ¼ã«ä¾å˜ã—ãªã„åŒæ¥ç•Œå›£ä½“ã®è¨ç«‹ã¯ç±³å›½æ™‚é–“5æœˆ13æ—¥ã«ç™ºè¡¨ã•ã‚ŒãŸã€‚è³‡é‡‘ã‚’æä¾›ã™ã‚‹ã®ã¯Wideniusæ°ã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒªãƒ³ã‚°ä¼æ¥Monty Programã¨ã€MySQLã«é–¢é€£ã—ãŸã‚µãƒ¼ãƒ“ã‚¹ã¨ã‚µãƒãƒ¼ãƒˆã‚’æä¾›ã™ã‚‹Perconaã€‚ ODAã®å£°æ˜Žã«ã‚ˆã‚‹ã¨ã€åŒå›£ä½“ã¯MySQLã¨ãã®æ´¾ç”Ÿã‚³ãƒ¼ãƒ‰ã€ãƒã‚¤ãƒŠãƒªã€ãƒˆãƒ¬ãƒ¼ãƒ‹ãƒ³ã‚°ã€ã‚µãƒãƒ¼ãƒˆã®ãƒãƒ–ã¨ã—ã¦æ©Ÿèƒ½ã™ã‚‹ã¨ã„ã†ã€‚ç‰¹ã«Wideniusæ°ãŒé–‹ç™ºã—ãŸMySQLã®ãƒ–ãƒ©ãƒ³ãƒã€ŒMariaDBã€ã®é–‹ç™ºã‚’æ‰‹æŽ›ã‘ã‚‹ã€‚ MariaDBã¯ã€ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãƒ¼ãƒ™ãƒ¼ã‚¹ã§é–‹ç™ºã•ã‚ŒãŸã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚ºå‘ã‘ã®MySQLãƒ–ãƒ©ãƒ³ãƒã€‚MariaDBã¨ã„ã†åå‰ã¯ã€Sun Micr
akaiho 2009/05/19
mysql
ãƒªãƒ³ã‚¯
Google Code Archive - Long-term storage for Google Code Project Hosting.
Code Archive Skip to content Google About Google Privacy Terms
akaiho 2009/03/16
mac

mysql
ãƒªãƒ³ã‚¯
mixi Engineersâ€™ Blog Â» Introducing the Drizzle Project
ã“ã“ã—ã°ã‚‰ãã€æ°´é¢ä¸‹ã§Brian Akerã‚’ä»£è¡¨ã¨ã™ã‚‹MySQL/SUNã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãŸã¡ã‚„ã€æ¥ç•Œã®ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒãƒƒã‚«ãƒ¼ãŸã¡ã¨MySQLã‚’ã‚¹ãƒªãƒ ãƒ€ã‚¦ãƒ³ã•ã›ãŸãƒžã‚¤ã‚¯ãƒã‚«ãƒ¼ãƒãƒ«RDBMSã‚’é–‹ç™ºã—ã¦ã„ãŸã®ã§ã™ãŒã€æœ¬æ—¥ã‚¢ãƒŠã‚¦ãƒ³ã‚¹ã•ã‚ŒãŸã®ã§ã€æ—¥æœ¬èªžã§ã”ç´¹ä»‹ã•ã›ã¦ã„ãŸã ããŸã„ã¨æ€ã„ã¾ã™ã€‚ Drizzleã¨ã¯ï¼Ÿ Drizzleã¨ã¯å¿…è¦ã®ãªã„ã‚‚ã®ã¯ä¸€åˆ‡å˜åœ¨ã—ãªã„ã€æœ€ä½Žé™ã§ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹é‡è¦–ãªã€ŒMySQLã‚ˆã‚Šã‚·ãƒ³ãƒ—ãƒ«ã§ã€è»½ãã€å®‰å®šã—ã¦ã€é«˜é€Ÿãªã€ MySQLã®forkã§ã™ã€‚ãƒžã‚¤ã‚¯ãƒã‚«ãƒ¼ãƒãƒ«ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã‚’æŽ¡ç”¨ã—ãŸã®ã§ã€å¿…è¦ã®ãªã„ã‚‚ã®ã¯å¾Œä»˜ã‘ã§ãã‚‹æ§‹æˆã§ã™ã€‚ã“ã†ã„ã£ãŸç›®æ¨™ã‚‚ã‚ã‚Šã€ç¾åœ¨ã€Drizzleã®é–‹ç™ºãƒãƒ¼ãƒ ã¯MySQLã‚’ãƒ‰ãƒ©ã‚¹ãƒ†ã‚£ãƒƒã‚¯ã«ãƒªãƒ•ã‚¡ã‚¯ã‚¿ãƒªãƒ³ã‚°ã—ã¦ã„ã¾ã™ã€‚ ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãƒ™ãƒ¼ã‚¹ã®ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆ Drizzleã§å¤§äº‹ãªäº‹ã¯ã€Drizzleã¯ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãƒ™ãƒ¼ã‚¹ã®ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã§ã‚ã‚‹ã¨ã„ã†äº‹ã§ã™ã€‚Montyã®ãƒ–
akaiho 2008/07/25
database

mixi

mysql
ãƒªãƒ³ã‚¯
MyDNS: Home
MyDNS is a free DNS server for UNIX. It was implemented from scratch and is designed to serve records directly from an SQL database (currently either MySQL or PostgreSQL). Its primary objectives are stability, security, interoperability, and speed, though not necessarily in that order. MyDNS does not include recursive name service, nor a resolver library. It is primarily designed for organizations
akaiho 2008/06/30
mysql

server
ãƒªãƒ³ã‚¯
mixi Engineersâ€™ Blog Â» Tokyo Tyrantã«ã‚ˆã‚‹è€é«˜è² è·DBã®æ§‹ç¯‰
é€£ä¼‘ä¸ã¯Wiiã®ãƒžãƒªã‚ªã‚«ãƒ¼ãƒˆã‚’ã‚„ã‚Šã¾ãã£ã¦ã‚„ã£ã¨VR7000è¶ŠãˆãŸmikioã§ã™ã€‚æ„›è»Šã¯ãƒžãƒƒãƒãƒ»ãƒã‚¤ã‚¯ã¨ã‚¤ãƒ³ã‚¿ãƒ¼ã‚»ãƒ—ã‚¿ãƒ¼ã§ã™ã€‚ã•ã¦ä»Šå›žã¯ã€åˆ†æ•£ãƒãƒƒã‚·ãƒ¥ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒTokyo Tyrantã§mixiã®æœ€çµ‚ãƒã‚°ã‚¤ãƒ³æ™‚åˆ»ã‚’ç®¡ç†ã™ã‚‹ã‚ˆã†ã«ã—ãŸæ™‚ã®è‹¦åŠ´è©±ã‚’æ›¸ãã¾ã™ã€‚ ãƒã‚°ã‚¤ãƒ³å‡¦ç†ã¯è² è·åœ°ç„ mixiã§ã¯ã€å…¨ã¦ã®ãƒ¦ãƒ¼ã‚¶ã«ã¤ã„ã¦ã€å„ã€…ã®æœ€çµ‚ãƒã‚°ã‚¤ãƒ³æ™‚åˆ»ã‚’ç®¡ç†ã—ã¦ã„ã¾ã™ã€‚ã€Œãƒžã‚¤ãƒŸã‚¯ã‚·ã‚£ä¸€è¦§ã€ã‚„ã€ŒãŠæ°—ã«å…¥ã‚Šã€ãªã©ã®ç”»é¢ã§ã€å‹äººãŒè¿‘ã„æ™‚é–“ã«ãƒã‚°ã‚¤ãƒ³ã—ã¦ã„ã¦ã‚³ãƒŸãƒ¥ãƒ‹ã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒã¨ã‚Šã‚„ã™ã„çŠ¶æ…‹ã«ã‚ã‚‹ã‹ã©ã†ã‹ç¢ºèªã§ãã‚‹ã‚ˆã†ã«ã™ã‚‹ãŸã‚ã§ã™ã€‚ mixiã®ã»ã¼å…¨ã¦ã®ãƒšãƒ¼ã‚¸ã¯ãƒã‚°ã‚¤ãƒ³ã—ãªã„ã¨è¦‹ã‚‰ã‚Œãªã„ãƒšãƒ¼ã‚¸ãªã®ã§ã€ã»ã¼å…¨ã¦ã®ãƒšãƒ¼ã‚¸ã«ã‚¢ã‚¯ã‚»ã‚¹ã•ã‚Œã‚‹ãŸã³ã«ãƒã‚°ã‚¤ãƒ³ç¢ºèªãŒè¡Œã‚ã‚Œã¾ã™ã€‚ã—ãŸãŒã£ã¦ã€æœ€çµ‚ãƒã‚°ã‚¤ãƒ³æ™‚åˆ»ã¯ã»ã¼å…¨ã¦ã®ãƒšãƒ¼ã‚¸ã«ã‚¢ã‚¯ã‚»ã‚¹ã•ã‚Œã‚‹åº¦ã«æ›´æ–°ã•ã‚Œã‚‹ã“ã¨ã«ãªã‚Šã¾ã™ã€‚mixiã®ä¸ã§æœ€ã‚‚é‡ã„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã²ã¨ã¤ã¨ã—ã¦ã€Œ
akaiho 2008/05/11
database

mixi

mysql

perl

server
ãƒªãƒ³ã‚¯
GIGAZINEã€ã¤ã„ã«æ–°ã‚µãƒ¼ãƒã¸ç§»è»¢å®Œäº†
ã¨ã„ã†ã‚ã‘ã§ã€ã“ã“ãŒæ–°ã‚µãƒ¼ãƒç¾¤ã«ã‚ˆã‚‹æ–°ç”ŸGIGAZINE.NETã§ã™ã€‚ã“ã®è¨˜äº‹ãŒè¦‹ãˆã¦ã„ã‚‹ã¨ã„ã†ã“ã¨ã¯ã€æ–°ã—ã„ã‚µãƒ¼ãƒã¸ã®DNSæµ¸é€ãŒæ¸ˆã‚“ã ã¨ã„ã†ã“ã¨ã§ã™ã€‚è¦‹ãŸç›®ä¸Šã¯ç‰¹ã«ä½•ã‹ã®å¤‰åŒ–ãŒã‚ã‚‹ã‚ã‘ã§ã¯ãªã„ã®ã§ã™ãŒã€ã‚µãƒ¼ãƒãŒç‰©ç†çš„ã«ãƒˆãƒ©ãƒ–ãƒ«ã‚’èµ·ã“ã•ãªã„é™ã‚Šã¯é‡ããªã£ãŸã‚Šã¯ã—ãªã„â€¦â€¦ã¯ãšã€‚ ã¨ã„ã†ã‚ã‘ã§ã€å‰å›žã®è¨˜äº‹ã«å¼•ãç¶šãã€è£è©±ç¬¬2å¼¾ã§ã™ã€‚è©³ç´°ã¯ä»¥ä¸‹ã‹ã‚‰ã€‚ ãƒ»MySQLã®DNSãƒ«ãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’ç„¡åŠ¹åŒ– æ–°ã‚µãƒ¼ãƒæ§‹æˆã§ãƒ†ã‚¹ãƒˆä¸ã«æœ€å¤§ã®å•é¡Œã¨ãªã£ãŸã®ãŒã‚³ãƒ¬ã€‚ãƒ«ãƒ¼ã‚¿ãŒè½ã¡ã¾ãã‚‹ã®ã§ä¸€ä½“ä½•ãŒèµ·ãã¦ã„ã‚‹ã®ã‹ãŒã‚ã‹ã‚‰ãšã€å»¶ã€…ã¨1é€±é–“ã‚‚æ‚©ã¿ç¶šã‘ã€GIGAZINEç·¨é›†éƒ¨ã‚’ææ€–ã®ã©ã‚“åº•ã«ãŸãŸãè¾¼ã‚“ã ã‚‚ã®ã§ã™ã€‚çµè«–ã‹ã‚‰è¨€ã†ã¨ã€å¤–éƒ¨ã®DNSã‚µãƒ¼ãƒã‚’åˆ©ç”¨ã—ã¦ã„ãŸãŸã‚ã€ãƒãƒ¼ã‚«ãƒ«ã§ã®ãƒ†ã‚¹ãƒˆç’°å¢ƒã«ãŠã„ã¦ã‚‚MySQLã«æŽ¥ç¶šãŒç™ºç”Ÿã™ã‚‹ã”ã¨ã«ã€DNSã®å‚ç…§ãŒç™ºç”Ÿã—ã¦ã„ãŸã®ãŒåŽŸå› ã€‚ MySQL :: MySQL 4.1 ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢
akaiho 2008/04/19
mysql

linux

server
ãƒªãƒ³ã‚¯
MySQLã®InnoDBã§ã®ãƒ‡ãƒƒãƒ‰ãƒãƒƒã‚¯ - mixi engineer blog
ã“ã‚“ã«ã¡ã¯ã€mixié–‹ç™ºéƒ¨ã«ã¦ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³é–‹ç™ºã‚’ã—ã¦ã„ã¾ã™youheiã§ã™ã€‚ ä»Šå›žã¯ã€MySQL-5.0.45ã®InnoDBã§é€£ç•ªã‚’ç®¡ç†ã™ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹æ¸¬å®šã‚’ã—ã¦ã„ãŸã®ã§ã™ãŒã€ãã®éš›ã«å°‘ã—å¤‰ã‚ã£ãŸãƒ‡ãƒƒãƒ‰ãƒãƒƒã‚¯å•é¡Œã«éé‡ã—ã¾ã—ãŸã®ã§ã€ãã®ã‚ãŸã‚Šã‚’ãƒã‚¿ã¨ã—ã¦æ›¸ã„ã¦ã¿ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ã¾ãšã¯ã€ä»Šå›žä½¿ç”¨ã—ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚¹ã‚ãƒ¼ãƒžã¯ä¸‹è¨˜ã®ã‚ˆã†ãªã‚‚ã®ã§ã™ã€‚ CREATE TABLE num ( id bigint unsigned NOT NULL default '0' ) Engine=InnoDB; AUTO_INCREMENTã¯ä½¿ç”¨ã—ã¦ã„ã¾ã›ã‚“ã€‚ ãã“ã«1ãƒ¬ã‚³ãƒ¼ãƒ‰ã ã‘ç™»éŒ²ã—ã¾ã™ã€‚ INSERT INTO num (id) values (1); ãã—ã¦å®Ÿéš›é€£ç•ªã‚’å–å¾—ã™ã‚‹éš›ã«ã¯ã€ UPDATE num SET id = LAST_INSERT_ID(id+1); ã¨ã„ã£ãŸã‚¯ã‚¨ãƒªã‚’
akaiho 2007/12/03
mixi

mysql
ãƒªãƒ³ã‚¯
https://labs.cybozu.co.jp/blog/kazuho/archives/2007/09/mysql_param_binding.php
akaiho 2007/09/27
mysql

perl
ãƒªãƒ³ã‚¯
livedoor Techãƒ–ãƒã‚° : nowaã®ã‚µãƒ¼ãƒæ§‹æˆ
ã“ã‚“ã«ã¡ã¯ã‚¹ã‚¨ãƒ’ãƒã§ã™ã€‚ ä»Šå›žã¯å¼Šç¤¾ãŒæä¾›ã—ã¦ã„ã‚‹ãƒ–ãƒã‚°ã‚µãƒ¼ãƒ“ã‚¹ã€Œnowaã€(ãƒŽãƒ¯ http://nowa.jp)ã®ä»•çµ„ã¿ã‚’ã‚µãƒ¼ãƒæ§‹æˆã‚’ä¸å¿ƒã«ç´¹ä»‹ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ nowaã§ã¯ä¸€èˆ¬çš„ãªãƒ–ãƒã‚°ã‚µãƒ¼ãƒ“ã‚¹è¦ç´ ã¨SNSè¦ç´ ã®æ©Ÿèƒ½ã‚’å®Ÿè£…ã—ã¦ã„ã¾ã™ã€‚å¼Šç¤¾ã«ã¯å…ˆè¡Œã—ã¦æä¾›ã—ã¦ã„ã‚‹ã€Œlivedoor Blogã€ã€ã€Œãƒ•ãƒ¬ãƒ‘ã€ã¨ã„ã£ãŸå¤§è¦æ¨¡ãªã‚µãƒ¼ãƒ“ã‚¹ãŒã‚ã‚Šã¾ã™ã®ã§ã€ãã¡ã‚‰ã®é–‹ç™ºãƒ»é‹ç”¨ã§å•é¡Œã«ãªã£ãŸç‚¹ãªã©ã‚’å‚è€ƒã«ã—ã¤ã¤é–‹ç™ºã‚’é€²ã‚ã¦ã„ã¾ã™ã€‚å…·ä½“çš„ã«ã¯ã‚¢ã‚¯ã‚»ã‚¹ã«ã‚ˆã‚‹è² è·ã¸ã®å¯¾ç–ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®åˆ†æ•£åŒ–ã€ç”»åƒã®ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ãƒ³ã‚°ã€å†—é•·æ€§ã€ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã¨ã„ã£ãŸç‚¹ã«ãªã‚Šã¾ã™ã€‚ - ãƒãƒ¼ã‚¿ãƒ«(nowa.jp)ã€CMS(cms.nowa.jp) ã®ã‚µãƒ¼ãƒæ§‹æˆ ãƒãƒ¼ã‚¿ãƒ«ãƒšãƒ¼ã‚¸(nowa.jp)ã¨CMSãƒšãƒ¼ã‚¸(cms.nowa.jp)ã¯ã€é™çš„ãªãƒ•ã‚¡ã‚¤ãƒ«ã®ãƒªã‚¯ã‚¨ã‚¹ãƒˆã‚’æŒã+å‹•çš„ãªã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã¸ã®ãƒªã‚¯ã‚¨ã‚¹ãƒˆã‚’ãƒ—ãƒã‚ã‚·ã™ã‚‹ãƒ•ãƒãƒ³ãƒˆã‚µãƒ¼ãƒ
akaiho 2007/09/23
apache

livedoor

mysql

scalability

server
ãƒªãƒ³ã‚¯
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ã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’æ”¯ãˆã¦ã„ã‚‹ï¼ˆåºƒå‘Šé…ä¿¡ãªã©å‘¨è¾ºæ©Ÿèƒ½ã§ã¯
akaiho 2007/09/15
interview

mixi

mysql
ãƒªãƒ³ã‚¯
ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ç³»(Apacheãƒ»PHPãƒ»MySQL)ã®ãƒãƒ¼ãƒˆã‚·ãƒ¼ãƒˆ
Apacheã€PHPã€MySQLã€CVSã€Subversionãªã©ã®ã‚µã‚¤ãƒˆåˆ¶ä½œã®ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ç³»ã®ãƒãƒ¼ãƒˆã‚·ãƒ¼ãƒˆã®ã¾ã¨ã‚ã§ã™ã€‚ å„ãƒãƒ¼ãƒˆã‚·ãƒ¼ãƒˆã®ãƒªãƒ³ã‚¯ã¯ã€ä¸‹è¨˜ã®ã€Œãƒãƒ¼ãƒˆã‚·ãƒ¼ãƒˆã®ãƒãƒ¼ã‚¿ãƒ«ã‚µã‚¤ãƒˆã€ã‚ˆã‚ŠåŽé›†ã—ã¾ã—ãŸã€‚ Apacheã®ãƒãƒ¼ãƒˆã‚·ãƒ¼ãƒˆ PHPã®ãƒãƒ¼ãƒˆã‚·ãƒ¼ãƒˆ MySQLã®ãƒãƒ¼ãƒˆã‚·ãƒ¼ãƒˆ CVSãƒ»Subversionã®ãƒãƒ¼ãƒˆã‚·ãƒ¼ãƒˆ ãƒãƒ¼ãƒˆã‚·ãƒ¼ãƒˆã®ãƒãƒ¼ã‚¿ãƒ«ã‚µã‚¤ãƒˆ Apacheã®ãƒãƒ¼ãƒˆã‚·ãƒ¼ãƒˆ Apache 1.3 Quick Reference Card mod_rewrite Cheat Sheet htaccess Cheatsheet PHPã®ãƒãƒ¼ãƒˆã‚·ãƒ¼ãƒˆ PHP Cheat Sheet PHP Cheat Sheet PHP 4 Quick Reference Card PHP Cheat Sheet Smarty cheat sheet PHP 4 Reference Card(PDF)
akaiho 2007/09/05
mysql

php

apache
ãƒªãƒ³ã‚¯
http://e0166nt.com/blog-entry-263.html
akaiho 2007/08/26
mysql

javascript

php
ãƒªãƒ³ã‚¯
livedoor Techãƒ–ãƒã‚° : MySQL Proxy ã‚’è©¦ã—ã¦ã¿ã¾ã—ãŸ
ã“ã‚“ã«ã¡ã¯ã€‚é‡‘åã§ã™ã€‚ å…ˆæ—¥ã€ç¤¾å†…å‹‰å¼·ä¼šã§ MySQL Proxy ã‚’å–ã‚Šä¸Šã’ã¾ã—ãŸã€‚ãã®éš›ã¾ã¨ã‚ãŸè³‡æ–™ã‚’ã€ä¸€éƒ¨åŠ ç†ä¿®æ£ã—ã¦å…¬é–‹ã—ã¾ã™ã€‚ æœ€åˆã«ãŠè©«ã³ å¤§å…ƒã®æ–‡ç« ã‚’æ›¸ã„ãŸã®ãŒ 2007 å¹´ã® 7 æœˆãªã®ã§ã€å†…å®¹ãŒå°‘ã—å¤ã„ã§ã™ã€‚ã“ã‚Œã‚’æ›¸ããªãŒã‚‰æœ€æ–°ç‰ˆã‚’ãƒã‚§ãƒƒã‚¯ã‚¢ã‚¦ãƒˆã—ã¦ãã¦å†æ¤œè¨¼ã—ãŸã‹ã£ãŸã®ã§ã™ãŒã€ãƒ¬ãƒã‚¸ãƒˆãƒªãŒãƒ€ã‚¦ãƒ³ã—ã¦ã„ã¦æœ€æ–°ã®ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã‚’å…¥æ‰‹ã§ãã¾ã›ã‚“ã§ã—ãŸã€‚ãªã®ã§ã€ä¸€ãƒ¶æœˆå‰ã®ãƒªãƒ“ã‚¸ãƒ§ãƒ³(rev.116) æ™‚ç‚¹ã§ã®ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ + äºŒé€±é–“ãã‚‰ã„å‰ã«ãƒ¬ãƒã‚¸ãƒˆãƒªã‚’è¦—ã„ãŸã¨ãã®è¨˜æ†¶ã®ã¿ã§æ›¸ã„ã¦ãŠã‚Šã€ã„ã‚ã„ã‚é–“é•ã£ã¦ã„ã‚‹ãŠãã‚ŒãŒã‚ã‚‹ã®ã§ã€ã¿ãªã•ã‚“æ˜¯éžè‡ªåˆ†ã§ã‚³ãƒ³ãƒ‘ã‚¤ãƒ«ã—ã¦è©¦ã—ã¦ã¿ã¦ãã ã•ã„(æ³¨æ„!ãŸã ã§ã•ãˆã¤ãªãŒã‚Šã«ãã„ã®ã§ã€ã“ã®ã‚¨ãƒ³ãƒˆãƒªã‚’å…¨éƒ¨èªã‚“ã§ä¸€é€±é–“å¾Œã«ã¾ã MySQL Proxy ã®ã“ã¨ã‚’è¦šãˆã¦ã„ãŸäººã ã‘ãƒ¬ãƒã‚¸ãƒˆãƒªã«ã‚¢ã‚¯ã‚»ã‚¹ã—ã¦ãã ã•ã„ã) æ°—ã®æ—©ã„äººå‘ã‘ã®çµè«– ã¾ã å®Ÿè·µæŠ•å…¥ã™ã‚‹ã«ã¯åŽ³ã—
akaiho 2007/08/22
mysql
ãƒªãƒ³ã‚¯
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ã§ãƒ•ã‚¡ã‚¤ãƒ«
akaiho 2007/07/31
mysql
ãƒªãƒ³ã‚¯
Re: MySQLæœ€é©åŒ–ã®ãƒŸãƒ‹tips - æ—¥å‘å¤ç‰¹æ®Šå¿œæ´éƒ¨éšŠ
å…ƒãƒã‚¿: http://labs.unoh.net/2007/07/mysqltips.html ã‚ã¾ã‚Šå…·ä½“çš„ã˜ã‚ƒãªã„ã®ã§ã€åƒ•ã®è€ƒãˆã¨ã‹ã€‚ æ£ã—ã„ã‹ã©ã†ã‹ã¯å„è‡ªã®çŠ¶æ³ã ã¨ã‹å®Ÿéš›è©¦ã™ã¹ããªã‚“ã ã‘ã©ã€å‚è€ƒã«ãªã‚Œã°ã€‚ MyISAMã€InnoDBãªã©ãƒ†ãƒ¼ãƒ–ãƒ«ã‚¿ã‚¤ãƒ— åƒ•ã¯æ–ç„¶InnoDBæ´¾ã§ã™ã€‚ ãŸã ä»°ã‚‹ã¨ãŠã‚Šã€ãƒã‚°ã‚‹ã ã‘ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã¨ã‹ãªã‚‰MyISAMã§ã‚‚ã„ã„ã¨ã¯æ€ã†ã‘ã©ã€‚ ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚„ãƒãƒƒã‚¯å‡¦ç†ãªã©ãŒå¿…è¦ãªã„å ´åˆãªã©ã€MyISAMå½¢å¼ã«ã‚‚è‰¯ã„ã¨ã“ã‚ã¯ã‚ã‚‹ã®ã§æ¤œè¨Žã—ã¦ã¿ã‚‹ä¾¡å€¤ã¯ã‚ã‚‹ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚ ã“ã‚Œã ã‘ã®æŒ‡æ‘˜ã ã¨ã¡ã‚‡ã£ã¨å¾®å¦™ãªæ°—ãŒã™ã‚‹ã§ã™ã€‚ MyISAMã®ä½¿ã„ã©ã“ã‚ã£ã¦ã®ã¯ã€ ãƒ”ãƒ³ã§ä»–ã¨ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ãŒç„¡ã„å˜ç´”è¿½è¨˜ç³»ã®ãƒ†ãƒ¼ãƒ–ãƒ« ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ãŒã‚ã‚Šã€åŒä¸€ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å†…ã§ã®æ›´æ–°ç³»ã‚¯ã‚¨ãƒªãŒå˜åœ¨ã™ã‚‹å ´åˆã¯ã€ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãŒæœŸå¾…é€šã‚Šã«å‹•ã‹ãªã„ã®ã§ã€åŸºæœ¬çš„ã«ã¯InnoDBã¨æ··åœ¨ã•ã›ã‚‹ã¹ãã§ã¯ãªã„
akaiho 2007/07/21
mysql
ãƒªãƒ³ã‚¯
ã‚¦ãƒŽã‚¦ãƒ©ãƒœ Unoh Labs: MySQLæœ€é©åŒ–ã®ãƒŸãƒ‹tips
yukiã§ã™ã€‚ ä»Šå›žã¯Webã‚µã‚¤ãƒˆã‚’è£½ä½œã™ã‚‹ä¸Šã§æ¬ ã‹ã›ãªã„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹(DB)ã®ãŠè©±ã§ã™ã€‚Linuxã€Apache,MySQL,PHPã‚’çµ„ã¿åˆã‚ã›ãŸLAMPã¨ã„ã†è¨€è‘‰ãŒç™»å ´ã—ã¦ä¹…ã—ã„ã§ã™ãŒã€Webã‚µãƒ¼ãƒ“ã‚¹ã‚’æ§‹ç¯‰ã™ã‚‹ä¸Šã§æ¬ ã‹ã›ãªã„ã®ãŒDBã®å˜åœ¨ã§ã™ãã€‚ é‹ç”¨å¾ŒWebã‚µã‚¤ãƒˆãŒé †èª¿ã«æ‹¡å¤§ã—è¦æ¨¡ã‚‚å¤§ãããªã£ã¦ããŸé ƒã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«æ‚©ã‚€ã“ã¨ã‚‚å‡ºã¦ãã‚‹ã‚‚ã®ã§ã™ã€‚ ãƒãƒ¼ãƒ‰ã‚¦ã‚§ã‚¢ã‚„æ§‹æˆã«å•é¡ŒãŒã‚ã‚‹å ´åˆã€ãƒã‚¸ãƒƒã‚¯ã«å•é¡ŒãŒã‚ã‚‹å ´åˆãªã©æ§˜ã€…ã§ã™ãŒã€DBã‚’è¦‹ç›´ã—ã¦ã¿ã‚‹ã®ã‚‚æ‰‹ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚ éŠ€è¡Œã®é é‡‘æ®‹é«˜ãªã©ã®ã‚ˆã†ã«ãƒŸãƒƒã‚·ãƒ§ãƒ³ã‚¯ãƒªãƒ†ã‚£ã‚«ãƒ«ã§ã‚ã‚‹å ´åˆã‚„ã€ã¨ã‚‚ã‹ããƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹æ€§ã‚’æ±‚ã‚ã‚‰ã‚Œã‚‹ãªã©æ§˜ã€…ã‚ã‚Šã€ä¸€æ¦‚ã«è¨€ãˆã‚‹ã‚‚ã®ã§ã‚‚ã‚ã‚Šã¾ã›ã‚“ãŒã€ Webã‚µãƒ¼ãƒ“ã‚¹ã«ãŠã„ã¦ã¯æœ‰åãª8ç§’ãƒ«ãƒ¼ãƒ«ã‚‚ã€æœ€è¿‘ã§ã¯6ç§’ã€3ç§’ã€1ç§’ã¨æ±‚ã‚ã‚‰ã‚Œã‚‹ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã¯ã©ã‚“ã©ã‚“çŸããªã£ã¦æ¥ã¦ã„ã¾ã™ã€‚ ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã ã‘ã§ãªãã€ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ã‚³
akaiho 2007/07/19
mysql
ãƒªãƒ³ã‚¯
èŒãˆèŒãˆãªMySQLäº’æ›ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ŒMoSQLã€
MySQLäº’æ›ã®æ—¥æœ¬èªžãŒä½¿ã„ã‚„ã™ã„ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ŒMoSQLï¼ˆã‚‚ãˆã™ãã‚…ãƒ¼ãˆã‚‹ï¼‰ã€ã ãã†ã§ã™ã€‚ ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®æ–‡å—ã‚³ãƒ¼ãƒ‰ãŒUTF-8ã§ã‚ã‚‹ã»ã‹ã€é«˜é€Ÿãªæ—¥æœ¬èªžå…¨æ–‡æ¤œç´¢ãŒå¯èƒ½ã€ã»ã¨ã‚“ã©ã®ã‚¨ãƒ©ãƒ¼ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚’æ—¥æœ¬èªžã«ã§ãã‚‹ã¨ã„ã£ãŸæ©Ÿèƒ½ãŒå‚™ã‚ã£ã¦ã„ã‚‹ã¨ã“ã‚ãŒã€ŒèŒãˆèŒãˆã€ã¨ã®ã“ã¨ã€‚ è©³ç´°ã¯ä»¥ä¸‹ã®é€šã‚Šã€‚ ãƒ¡ã‚¤ãƒ³ãƒšãƒ¼ã‚¸ - MoSQL ã“ã®ãƒšãƒ¼ã‚¸ã«ã‚ˆã‚‹ã¨ã€ ã€ŒMoSQLã€ãŒã€ŒMySQLã€ã¨ç•°ãªã‚‹ã¨ã“ã‚ã¯ä»¥ä¸‹ã®é€šã‚Šã€‚ ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®æ–‡å—ã‚³ãƒ¼ãƒ‰ã¯ UTF-8 ã§ã™ã€‚(5.0 & 5.1) æ–‡å—ã‚³ãƒ¼ãƒ‰ã®ç¯„å›²å¤–ã®ãƒã‚¤ãƒˆåˆ—ã§ã‚‚ãã®ã¾ã¾æ ¼ç´ã•ã‚Œã¾ã™ã€‚ãƒ‡ãƒ¼ã‚¿ãŒå¤±ã‚ã‚Œã‚‹ã“ã¨ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚(5.0 & 5.1) ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆãƒ©ã‚¤ãƒ–ãƒ©ãƒªã¯ç’°å¢ƒå¤‰æ•°ã«ã‚ˆã‚Šæ–‡å—ã‚³ãƒ¼ãƒ‰ã‚’æŒ‡å®šã§ãã‚‹ã®ã§ã€charset ã‚’æŒ‡å®šã™ã‚‹æ©Ÿèƒ½ãŒãªã„ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ã‚‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æ—¥æœ¬èªžã‚’æ ¼ç´ã§ã(ã‚‹ã‚ˆã†ã«ãªã‚‹å¯èƒ½æ€§ãŒã‚ã‚Š)ã¾ã™ã€‚(æ—¥æœ¬èªžãŒä½¿ç”¨ã§ãã‚‹
akaiho 2007/06/28
mysql
ãƒªãƒ³ã‚¯
ã€ŒMySQLï¼ŒPostgreSQLã¨Firebirdã®æ€§èƒ½ã‚’ãƒ¦ãƒ¼ã‚¶ãƒ¼ä¼šãƒ¡ãƒ³ãƒãƒ¼ãŒå¾¹åº•æ¯”è¼ƒï¼Œåˆ¤æ˜Ž...
ã€Œæ›´æ–°ã¨JOINãŒå¤šã‘ã‚Œã°MySQLï¼Œã‚·ãƒ³ãƒ—ãƒ«ãªSELECTä¸»ä½“ãªã‚‰PostgreSQLãŒå‘ã„ã¦ã„ã‚‹ã€‚ã‚¹ãƒˆã‚¢ãƒ‰ãƒ»ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã§ã‚·ãƒ³ã‚°ãƒ«ãƒ»ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãªã‚‰Firebirdã¯éžå¸¸ã«é€Ÿã„ã€---6æœˆ23æ—¥ã«é–‹å‚¬ã•ã‚ŒãŸã€Œã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹2007.DBï¼ˆOSC2007.DBï¼‰ã€ã§ï¼Œå„ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹DBã®ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ã®ãƒ¡ãƒ³ãƒãƒ¼ã«ã‚ˆã‚‹æ€§èƒ½æ¯”è¼ƒãŒæŠ«éœ²ã•ã‚Œï¼Œå¾“æ¥ã®ä¸€èˆ¬çš„ãªã‚¤ãƒ¡ãƒ¼ã‚¸ã¨ã¯ç•°ãªã‚‹â€œæ„å¤–ãªçµæžœâ€ãŒæ˜Žã‚‰ã‹ã«ã•ã‚ŒãŸã€‚ ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã¯ï¼Œã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹é–¢é€£ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãŒä¸»å‚¬ã™ã‚‹ã‚¤ãƒ™ãƒ³ãƒˆã§ï¼ŒOSC2007.DBã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é–¢é€£ã®ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãŒé›†ã¾ã£ãŸã‚¤ãƒ™ãƒ³ãƒˆã§ã‚ã‚‹ã€‚æ€§èƒ½æ¯”è¼ƒã‚»ãƒƒã‚·ãƒ§ãƒ³ã‚’æ‹…å½“ã—ãŸã®ã¯ï¼Œæ—¥æœ¬MySQLãƒ¦ãƒ¼ã‚¶ä¼šã®å ¤äº•æ³°å¿—æ°ï¼Œæ—¥æœ¬PostgreSQLãƒ¦ãƒ¼ã‚¶ä¼šã®ç‰‡å²¡è£•ç”Ÿæ°ï¼ŒFirebirdæ—¥æœ¬ãƒ¦ãƒ¼ã‚¶ãƒ¼ä¼šã®æœ¨æ‘æ˜Žæ²»æ°ã€‚ã€Œã‚ãã¾ã§ãƒœãƒ©ãƒ³ãƒ†ã‚£ã‚¢ã«ã‚ˆã‚‹æ€§èƒ½æ¯”è¼ƒã§ã‚ã£ã¦ï¼Œæœ€é€Ÿï¼Œæœ€æ–°ãƒž
akaiho 2007/06/25
mysql
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸