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

dewdrop id:dewdrop

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

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

NoSQLã¨ã—ã¦MySQLã‚’ä½¿ã†DeNAãŒã€memcachedã‚ˆã‚Šã‚‚é«˜é€Ÿãª75ä¸‡ã‚¯ã‚¨ãƒªï¼ç§’ã‚’å®Ÿç¾
ãƒ¢ãƒã‚²ãƒ¼ã§çŸ¥ã‚‰ã‚Œã‚‹DeNAã¯ã€ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«NoSQLã‚’ä½¿ã£ã¦ã„ã¾ã›ã‚“ã€‚ãªãœã‹ï¼Ÿ ãã‚Œã¯MySQL/InnoDB 5.1ã®ç’°å¢ƒã§ç§’é–“75ä¸‡ã‚¯ã‚¨ãƒªã¨ã„ã†ã€å¤šãã®NoSQLã§ã‚‚å®Ÿç¾ã§ããªã„ã‚ˆã†ãªé«˜æ€§èƒ½ã‚’å®Ÿç¾ã—ã¦ã„ã‚‹ã‹ã‚‰ã€‚DeNAã®æ¾ä¿¡å˜‰ç¯„ï¼ˆã¾ã¤ã®ã¶ã‚ˆã—ã®ã‚Šï¼‰æ°ã¯ã€è‡ªèº«ã®ãƒ–ãƒã‚°ã«ã“ã‚“ãªå†…å®¹ã®ã‚¨ãƒ³ãƒˆãƒªã€ŒUsing MySQL as a NoSQL - A story for exceeding 750,000 qps on a commodity serverã€ï¼ˆè‹±èªžï¼‰ã‚’ãƒœã‚¹ãƒˆã—ã¦ã„ã¾ã™ã€‚ Yoshinori Matsunobu's blog: Using MySQL as a NoSQL - A story for exceeding 750,000 qps on a commodity server æ¾ä¿¡æ°ãŒæŒ‡æ‘˜ã™ã‚‹ã‚ˆã†ã«ã€å¤§è¦æ¨¡ãªãƒãƒƒãƒˆã‚µãƒ¼ãƒ“ã‚¹ã‚’æä¾›ã—ã¦ã„ã‚‹ä¼æ¥ã®å¤šãã¯åˆ†æ•£ç’°å¢ƒã§
dewdrop 2010/10/28
mysql
ãƒªãƒ³ã‚¯
phpMyAdmin
About phpMyAdmin is a free software tool written in PHP, intended to handle the administration of MySQL over the Web. phpMyAdmin supports a wide range of operations on MySQL and MariaDB. Frequently used operations (managing databases, tables, columns, relations, indexes, users, permissions, etc) can be performed via the user interface, while you still have the ability to directly execute any SQL s
dewdrop 2008/01/10
mysql
ãƒªãƒ³ã‚¯
mysql -Xã§ã‚¯ã‚¨ãƒªãƒ¼ã®çµæžœã‚’XMLã§å–å¾— - æŠ€è¡“ãƒ¡ãƒ¢å¸³
mysql -X ã§ã‚¯ã‚¨ãƒªãƒ¼ã®çµæžœãŒXMLã§å–å¾—ã§ãã‚‹ã‚‰ã—ã„ã€‚ èˆˆå‘³æ·±ã„ã®ã§ã‚„ã£ã¦ã¿ãŸã€‚ ãªã‚“ã‹é©å½“ã«ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œæˆã™ã‚‹ã€‚ ã¨ã‚Šã‚ãˆãšã€4ã¤ã®ã‚«ãƒ©ãƒ ã‚’æŒã¤tã¨ã„ã†ãƒ†ãƒ¼ãƒ–ãƒ«ä½œã£ãŸã€‚ mysql> create table t(id int not null, name varchar(255), body text, updated_at datetime); mysql> insert into t values(1, 'name', 'body', current_timestamp); mysql> insert into t values(2, 'name2', 'body2', current_timestamp); ã¨ã‚Šã‚ãˆãšã€æ™®é€šã«SELECTã§è¡¨ç¤ºã—ã¦ã¿ã‚‹ã€‚ # mysql -e 'SQL' ã§ä»»æ„ã®SQLã‚’å®Ÿè¡Œå¯èƒ½ã€‚ãƒ¯ãƒ³ãƒ©ã‚¤ãƒŠãƒ¼ã«ä½¿ãˆã¾ã™ã€‚ $ mysql -e 'sele
dewdrop 2007/02/28
mysql

xml
ãƒªãƒ³ã‚¯
Oracleã®ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹è²·åŽç†± - SourceForge.JP Magazine
Oracleç¤¾ã¯æœ€è¿‘è²·åŽã«ç†±å¿ƒã§ã€å™‚ãŒæœ¬å½“ãªã‚‰ã“ã‚Œã¯ä»Šå¾Œã‚‚ã¾ã ç¶šãã¨ã„ã†ã€‚Oracleç¤¾ã®ã‚ˆã†ãªè¦æ¨¡ã®ä¼šç¤¾ã¨ã—ã¦ã¯ç•°ä¾‹ã®è¡Œå‹•ã ãŒã€åŒç¤¾ãŒã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ä¼æ¥ã‚’ç‹™ã£ã¦ã„ã‚‹ã“ã¨ã¯ã€MySQLãã®ä»–ã®ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ã«å¤§ããå½±éŸ¿ã—ãã†ã ã€‚ Oracleç¤¾ã¯æ˜¨å¹´10æœˆã€Innobaseç¤¾ã‚’è²·åŽã—ã€ä»Šåº¦ã¯Sleepycatç¤¾ã‚‚è²·åŽã—ãŸã€‚Innobaseç¤¾ã¨Sleepycatç¤¾ã®ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã¯MySQLã«å«ã¾ã‚Œã¦ã„ã‚‹ãŸã‚ã€MySQLç¤¾ã¯å°†æ¥ã€ã“ã‚Œã«ã¤ã„ã¦Oracleç¤¾ã¨äº¤æ¸‰ã—ãªã‘ã‚Œã°ãªã‚‰ãªããªã‚‹ã€‚ Oracleç¤¾ã¯MySQLç¤¾ã‚‚è²·åŽã—ã‚ˆã†ã¨ã—ãŸãŒã€MySQLç¤¾ã¯ç‹¬ç«‹ã‚’ç¶æŒã™ã‚‹é“ã‚’é¸ã‚“ã ã€‚ MySQLç¤¾CEOã§ã‚ã‚‹Marten Mickosæ°ã¯ã€è³ªå•ã‚’å—ã‘ã¦ã€åŒç¤¾ãŒç›®æŒ‡ã™ã®ã¯ã€Œç‹¬ç«‹ã—ãŸå˜åœ¨ã¨ã—ã¦ã®æˆåŠŸã€ã§ã‚ã‚Šã€Oracleç¤¾ã«ã‚ˆã‚‹Sleepycatç¤¾è²·åŽã¯ã€Œã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®åŠ›ã‚’å¤§ã„
dewdrop 2006/02/20
db

oracle

mysql
ãƒªãƒ³ã‚¯
http://www.flashmyadmin.org/original/flashmyadmin.org.php
dewdrop 2006/01/20
Flashè£½ã®MySQLç®¡ç†ãƒ„ãƒ¼ãƒ«

flash

mysql
ãƒªãƒ³ã‚¯
PostgreSQLã‚’MySQLäº’æ›ã«ã™ã‚‹ - SourceForge.JP Magazine
PostgreSQLã¯å¼·åŠ›ãªæ©Ÿèƒ½ã‚’å‚™ãˆã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«ã‚‚å®‰å®šæ€§ã«ã‚‚å„ªã‚Œã¦ã„ã‚‹ã€‚ã—ã‹ã—ã€è‚å¿ƒãªåˆ†é‡Žã§MySQLã«å¤§ããæ°´ã‚’ã‚ã‘ã‚‰ã‚Œã¦ã„ã‚‹ã€‚ã™ãªã‚ã¡ã€PostgreSQLã‚’ã‚µãƒãƒ¼ãƒˆã™ã‚‹ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ»ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã¯ã€MySQLã‚’ã‚µãƒãƒ¼ãƒˆã—ã¦ã„ã‚‹ã‚‚ã®ã‚ˆã‚Šé¥ã‹ã«å°‘ãªã„ã®ã§ã‚ã‚‹ã€‚ãã—ã¦ã€ã“ã®çŠ¶æ³ãŒPostgreSQLã®æ™®åŠã‚’é˜»ã‚“ã§ã„ã‚‹ã€‚ãƒ¦ãƒ¼ã‚¶ãƒ¼ã®å¤šãã¯MySQLã‚’é¸ã¶ãŒã€ãã‚Œã¯MySQLãŒPostgreSQLã‚ˆã‚Šã‚‚å„ªã‚Œã¦ã„ã‚‹ã‹ã‚‰ã§ã¯ãªãã€è‡ªåˆ†ãŒä½¿ã£ã¦ã„ã‚‹ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ»ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ãŒMySQLã—ã‹ã‚µãƒãƒ¼ãƒˆã—ã¦ã„ãªã„ã‹ã‚‰ãªã®ã ã€‚ã“ã†ã—ãŸçŠ¶æ³ã«ã€Christopher Kings-LynneãŒæŒ‘ã‚“ã§ã„ã‚‹ã€‚ PostgreSQLã®é–‹ç™ºè€…Kings-Lynneâ€•â€•phpPgAdminãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã«ã‚‚å‚åŠ ã—ã¦ã„ã‚‹â€•â€•ãŒã€PostgreSQLãƒ»MySQLäº’æ›ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã«å–ã‚Šçµ„ã‚“ã§ã„ã‚‹ã€‚MySQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
dewdrop 2005/12/22
db

postgresql

mysql
ãƒªãƒ³ã‚¯
1