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

honamis id:honamis

mysqlã«é–¢ã™ã‚‹honamisã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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}}

[MySQL] ã‚¹ãƒ†ãƒ¼ã‚¿ã‚¹å–å¾—ç³»ã® SQL ã¾ã¨ã‚ | ãƒã‚·ãƒ£ãƒã‚°ã€‚
å¤ä¼‘ã¿ã¾ã å–ã‚Œã¦ãªã„ã‚ˆï½žãƒ»ãƒ»ãƒ»å¤çµ‚ã‚ã£ã¡ã‚ƒã†ã‚ˆï½žãƒ»ãƒ»ãƒ»ã¿ãªã•ã‚“ã€ã“ã‚“ã¡ã«ã¯ nakamura ã§ã™ã€‚ ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ DB ã¸ã®æ›´æ–°ãƒ»å‚ç…§ç‰ã¯æ—¥ã€…ä½¿ã†ã®ã§å‰²ã‚Šã¨è¦šãˆã‚„ã™ã„ã§ã™ãŒã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ç‰è¡Œã†éš›ã«ãƒ†ãƒ¼ãƒ–ãƒ«ã‚„ MySQL è‡ªä½“ã®ã‚¹ãƒ†ãƒ¼ã‚¿ã‚¹ã‚’å–å¾—ã™ã‚‹ SQL ã£ã¦ã—ã‚‡ã£ã¡ã‚…ã†ä½¿ã†ã‚ã‘ã§ã¯ãªã„ã®ã§çµæ§‹å¿˜ã‚ŒãŒã¡ã§ã™ã‚ˆãï½žã€‚ä»Šæ—¥ã¯ãã®è¾ºã‚Šã® SQL æ–‡ã‚’å‚™å¿˜éŒ²ã‚‚å…¼ãã¦ã¾ã¨ã‚ã¦ã¿ã‚ˆã†ã¨æ€ã„ã¾ã™ã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«é–¢é€£ ãƒ†ãƒ¼ãƒ–ãƒ«ã®ä¸€è¦§ã‚’å–å¾—ã€‚ show tables; ãƒ†ãƒ¼ãƒ–ãƒ«æ§‹é€ ã‚’å–å¾—ã€‚ describe table_name; ; describe ã«ã¯ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆãŒç”¨æ„ã•ã‚Œã¦ã„ã¾ã™ã€‚ desc table_name; CREATE TABLE æ–‡ã‚’å–å¾—ã€‚ show create table table_name; ãƒ†ãƒ¼ãƒ–ãƒ«ã®çŠ¶æ…‹ã‚’å–å¾—ã€‚ ; å…¨ã¦ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’è¡¨ç¤º show table st
honamis 2012/08/30
database

sql

mysql
ãƒªãƒ³ã‚¯
http://japan.internet.com/busnews/20110909/6.html
honamis 2011/09/09
Oracle

mysql

rdbms

windows
ãƒªãƒ³ã‚¯
MySQLã‚’master:slave=1:1æ§‹æˆã«ã—ã¦å‚ç…§ã‚’slaveã«å‘ã‘ã‚‹ã®ãŒãªãœè‰¯ããªã„ã‹ - é…’æ—¥è¨˜ ã¯ã¦ãªæ”¯åº—
MySQLã®masterã¨slave 1:1ã«ã—ã¦å‚ç…§ã‚’slaveå‘ã‘ã‚‹ã®ã£ã¦ã‚„ã‚ŠãŸãŒã‚‹äººå¤šã„ã¿ãŸã„ã ã‘ã©ã€æ€§èƒ½ãŸã„ã—ã¦ä¸ŠãŒã‚‰ãªã„å‰²ã«å¯ç”¨æ€§è½ã¡ã‚‹ã ã‘ã ã‹ã‚‰ã‚„ã‚ã‚ˆã†ã‚ãƒ£ãƒ³ãƒšãƒ¼ãƒ³ 2011-06-19 00:16:30 via YoruFukurou MySQL ã¯ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒç°¡å˜ã«æ§‹æˆã§ãã‚‹ã®ã§ã™ãŒã€æ™‚æŠ˜ master 1å° ã«å¯¾ã—ã¦ slave 1å°ã€æ›´æ–°å‡¦ç†ã¯ master ã«ã€å‚ç…§ã¯ slave ã«ã€ã¨ã„ã†æ§‹æˆã‚’ç›®ã«ã—ã¾ã™ã€‚ å€‹äººçš„ã«ã¯ã“ã®æ§‹æˆã¯ãŠå‹§ã‚ã§ãªã„ã¨æ€ã£ã¦ã„ã‚‹ã®ã§ã€ãã®ç†ç”±ã‚’è€ƒå¯Ÿã—ã¦ã¿ã¾ã™ã€‚ 1. å¯ç”¨æ€§ãŒè½ã¡ã‚‹ å½“ç„¶ã§ã™ãŒã€master, slave ã®ã©ã¡ã‚‰ãŒè½ã¡ã¦ã‚‚å½±éŸ¿ã‚’å—ã‘ã‚‹ãŸã‚ã«å¯ç”¨æ€§ãŒä½Žä¸‹ã—ã¾ã™ã€‚ 2. å…¨ä½“ã®æ€§èƒ½ãŒã»ã¨ã‚“ã©ä¸ŠãŒã‚‰ãªã„ master 1å°ã§ã™ã¹ã¦ã®ã‚¯ã‚¨ãƒªã‚’å‡¦ç†ã™ã‚‹å ´åˆã¨æ¯”ã¹ã¦ã€å¯ç”¨æ€§ãŒè½ã¡ã‚‹å¼•ãæ›ãˆã¨ã—ã¦è¦‹åˆã£ãŸæ€§èƒ½å‘ä¸ŠãŒå¾—ã‚‰ã‚Œã‚‹ã‹ã€ã¨ã„ã†
honamis 2011/06/21
database

server

architecture

replication

mysql
ãƒªãƒ³ã‚¯
å®ŸéŒ²ã€ã»ã¼ç„¡åœæ¢ãªMySQLã®ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒ (å‹•ç”»ã‚‚ã‚ã‚‹ã‚ˆ) - ï¼ˆã²ï¼‰ãƒ¡ãƒ¢
ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã—ã¦ã‚‹MySQLã§ã€ãƒžã‚¹ã‚¿ã‚„ã‚¹ãƒ¬ãƒ¼ãƒ–ãŒéšœå®³åœæ¢ã—ãŸå ´åˆã®ãƒªã‚«ãƒãƒªãƒ—ãƒ©ãƒ³ ã§ã‚‚æŽ²ã’ãŸã‚´ãƒ¼ãƒ«ã§ã‚ã‚‹ã€ã€Œãƒžã‚¹ã‚¿ãŒè½ã¡ã¦ã‚‚ããƒ¼ã™ã‹å¯ã¦ã„ã‚‰ã‚Œã‚‹ã‚ˆã†ã«ã—ãŸã„ã€ãŒã»ã¼ã§ããŸã®ã§ã€ã»ã¨ã‚“ã©ã‚µãƒ¼ãƒ“ã‚¹ãŒåœæ¢ã™ã‚‹ã“ã¨ãªãã€ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒã™ã‚‹æ§˜ã‚’ã‚¹ã‚¯ãƒªãƒ¼ãƒ³ã‚ãƒ£ã‚¹ãƒˆã«åŽã‚ã¾ã—ãŸã€‚ åŸ‹ã‚è¾¼ã¿ãƒ—ãƒ¬ã‚¤ãƒ¤ãƒ¼ã ã¨ã€å°ã•ãã¦ã‚ã‹ã‚‰ãªã„ã¨æ€ã†ã®ã§ã€ãƒªãƒ³ã‚¯ç›´æŽ¥ã§ã¿ã¦ãã ã•ã„ã€‚ http://www.irori.org/pub/mysql-mm.mov ç™»å ´ã™ã‚‹ãƒ›ã‚¹ãƒˆ ç™»å ´ã™ã‚‹ãƒ›ã‚¹ãƒˆã¯2å°ã€db 901ã¨db902ã§ã™ã€‚ æœ€åˆã¯ã€db 901ãŒæ›´æ–°ç³»ã‚¯ã‚¨ãƒªã‚’å—ã‘ã‚‹ãƒ—ãƒ©ã‚¤ãƒžãƒªã§db900ã®æµ®å‹•IPã‚¢ãƒ‰ãƒ¬ã‚¹ã‚’æŒã£ã¦ã„ã¾ã™ã€‚ ç”»é¢åˆ†å‰² ç”»é¢ã¯5åˆ†å‰²ã—ã¦ã„ã¾ã™ã€‚ å·¦ä¸Š = ã€Œselect sysdate(),@@server_idã€ã‚’db900ã«å¯¾ã—ã¦(sleep 1ã—ãªãŒã‚‰)å»¶ã€…ã¨å®Ÿè¡Œã—ã¾ãã‚Šã‚“ã å³ä¸Š = ping -n
honamis 2009/11/12
database

server

mysql

replication
ãƒªãƒ³ã‚¯
ã€ŒLinux-DBã‚·ã‚¹ãƒ†ãƒ æ§‹ç¯‰ï¼é‹ç”¨å…¥é–€ã€ãŒã™ã”ã„ - ã‚ãªãŸã®ã‚·ã‚¹ãƒ†ãƒ ã€ã‚¬ãƒ©ãƒ‘ã‚´ã‚¹åŒ–ã—ã¦ã„ã¾ã›ã‚“ã‹ï¼Ÿ - kazuhoã®ãƒ¡ãƒ¢ç½®ãå ´
æ¾ä¿¡ã•ã‚“ãŒã‚„ã£ã¦ãã‚Œã¾ã—ãŸã€‚ ãšã„ã¶ã‚“å‰ã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã€Œæ£ã—ã„ã€æ§‹ç¯‰ã¨é‹ç”¨æ–¹æ³•ã«ã¤ã„ã¦ã¾ã¨ã‚ãŸæœ¬ã¯ãªã„ã‹ãªãƒ¼ã¨æ€ã£ã¦ã¾ã—ãŸã€‚è‡ªåˆ†ã¯ã“ã‚Œã¾ã§ã€æ§˜ã€…ãªãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã‚„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®è¨è¨ˆã€ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’è¡Œã£ã¦ãã¦ã„ã¾ã™*1ãŒã€å•é¡ŒãŒè§£æ±ºã§ããŸã‚ˆã†ã«ã¯è¦‹ãˆã¦ã‚‚ã€æžœãŸã—ã¦ãã‚ŒãŒæœ€é©ãªè§£æ±ºç–ã ã£ãŸã®ã‹ä¸å®‰ã«æ„Ÿã˜ã‚‹ã“ã¨ãŒã‚ã‚Šã¾ã—ãŸã€‚ãã‚Œã¯ã€ä½“ç³»çš„ãªçŸ¥è˜ã«æ¬ ã‘ã¦ã„ã‚‹ã‹ã‚‰ã§ã™ã€‚ã ã‹ã‚‰ã€ç¶²ç¾…çš„ãªæ•™ç§‘æ›¸ãŒã»ã—ã„ãªãã£ã¦æ€ã£ã¦ãŸã‚“ã§ã™ã€‚ ã¨ã‚ã‚‹ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆã§ã“ã®å‰ã€æ¾ä¿¡ã•ã‚“ã‹ã‚‰ã€Œã„ã¾æ›¸ã„ã¦ã‚‹ã€ã£ã¦è©±ã‚’èžã„ã¦ã€ä¸€éƒ¨ã‚’è¦‹ã›ã¦ã„ãŸã ã„ãŸã‚Šã—ãŸã‚“ã§ã™ãŒã€ã¤ã„æ˜¨æ—¥ã€æ‰‹å…ƒã«å±Šãã¾ã—ãŸã€‚ã‚„ã£ãŸãâ˜† åå‰ã¯ã€ŒLinux-DBã‚·ã‚¹ãƒ†ãƒ æ§‹ç¯‰ï¼é‹ç”¨å…¥é–€ã€ã€‚ã€Œå…¥é–€ã€ã¨éŠ˜æ‰“ãŸã‚Œã¦ã„ã‚‹ã‚‚ã®ã®ã€åŸºç¤Žçš„ãªçŸ¥è˜ã‹ã‚‰ã€ãªãœãã†ãªã‚‹ã®ã‹ã€ã©ã†å¿œç”¨ã™ã‚Œã°ã„ã„ã®ã‹ã€ã¨ã„ã£ãŸç‚¹ã¾ã§åºƒãã‚«ãƒãƒ¼ã—ã¦ã„ã‚‹*2ã€å…¨æ–¹ä½çš„ãªéš™ã®ãª
honamis 2009/09/16
ã‚·ã‚¹ãƒ†ãƒ é–‹ç™º

database

db

linux

mysql

book
ãƒªãƒ³ã‚¯
ã€ŒMySQLï¼ŒPostgreSQLã¨Firebirdã®æ€§èƒ½ã‚’ãƒ¦ãƒ¼ã‚¶ãƒ¼ä¼šãƒ¡ãƒ³ãƒãƒ¼ãŒå¾¹åº•æ¯”è¼ƒï¼Œåˆ¤æ˜Ž...
ã€Œæ›´æ–°ã¨JOINãŒå¤šã‘ã‚Œã°MySQLï¼Œã‚·ãƒ³ãƒ—ãƒ«ãªSELECTä¸»ä½“ãªã‚‰PostgreSQLãŒå‘ã„ã¦ã„ã‚‹ã€‚ã‚¹ãƒˆã‚¢ãƒ‰ãƒ»ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã§ã‚·ãƒ³ã‚°ãƒ«ãƒ»ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãªã‚‰Firebirdã¯éžå¸¸ã«é€Ÿã„ã€---6æœˆ23æ—¥ã«é–‹å‚¬ã•ã‚ŒãŸã€Œã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹2007.DBï¼ˆOSC2007.DBï¼‰ã€ã§ï¼Œå„ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹DBã®ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ã®ãƒ¡ãƒ³ãƒãƒ¼ã«ã‚ˆã‚‹æ€§èƒ½æ¯”è¼ƒãŒæŠ«éœ²ã•ã‚Œï¼Œå¾“æ¥ã®ä¸€èˆ¬çš„ãªã‚¤ãƒ¡ãƒ¼ã‚¸ã¨ã¯ç•°ãªã‚‹â€œæ„å¤–ãªçµæžœâ€ãŒæ˜Žã‚‰ã‹ã«ã•ã‚ŒãŸã€‚ ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã¯ï¼Œã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹é–¢é€£ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãŒä¸»å‚¬ã™ã‚‹ã‚¤ãƒ™ãƒ³ãƒˆã§ï¼ŒOSC2007.DBã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é–¢é€£ã®ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãŒé›†ã¾ã£ãŸã‚¤ãƒ™ãƒ³ãƒˆã§ã‚ã‚‹ã€‚æ€§èƒ½æ¯”è¼ƒã‚»ãƒƒã‚·ãƒ§ãƒ³ã‚’æ‹…å½“ã—ãŸã®ã¯ï¼Œæ—¥æœ¬MySQLãƒ¦ãƒ¼ã‚¶ä¼šã®å ¤äº•æ³°å¿—æ°ï¼Œæ—¥æœ¬PostgreSQLãƒ¦ãƒ¼ã‚¶ä¼šã®ç‰‡å²¡è£•ç”Ÿæ°ï¼ŒFirebirdæ—¥æœ¬ãƒ¦ãƒ¼ã‚¶ãƒ¼ä¼šã®æœ¨æ‘æ˜Žæ²»æ°ã€‚ã€Œã‚ãã¾ã§ãƒœãƒ©ãƒ³ãƒ†ã‚£ã‚¢ã«ã‚ˆã‚‹æ€§èƒ½æ¯”è¼ƒã§ã‚ã£ã¦ï¼Œæœ€é€Ÿï¼Œæœ€æ–°ãƒž
honamis 2007/06/25
db

firebird

mysql

postgresql
ãƒªãƒ³ã‚¯
1