[B! database] mkawanoã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

mkawano id:mkawano

databaseã«é–¢ã™ã‚‹mkawanoã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (17)

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

Googleãƒ‰ãƒ©ã‚¤ãƒ–ã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒä½¿ãˆã‚‹ã¨ã„ã†è¡æ’ƒ | éžITä¼æ¥ã«å‹¤ã‚ã‚‹ä¸å¹´ã‚µãƒ©ãƒªãƒ¼ãƒžãƒ³ã®ITæ—¥è¨˜
Googleãƒ‰ãƒ©ã‚¤ãƒ–ä¸Šã§Fusion Tablesã¨ã„ã†ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒä½¿ãˆã¾ã™ã€‚Google Apps Scriptï¼ˆGASï¼‰ã§åˆ¶å¾¡ã§ãã‚‹ã®ã¨ã€ãã‚Œã‚’ä»‹ã—ã¦ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã¨é€£æºã§ãã‚‹ã®ã§ã¨ã¦ã‚‚ä¾¿åˆ©ã§ã™ã€‚ä»Šå›žã¯Fusion Tablesã®å°Žå…¥ã‹ã‚‰èªè¨¼æ–¹æ³•ã€GASã‹ã‚‰ã®åˆ¶å¾¡æ–¹æ³•ï¼ˆä»Šå›žã¯ç°¡å˜ã«SELECTæ–‡ã‹ã‚‰ã®èªã¿è¾¼ã¿ã®ã¿ï¼‰ã«ã¤ã„ã¦æ›¸ãç•™ã‚ã¦ãŠãã¾ã™ã€‚Fusion Tablesã®å°Žå…¥Google Driveä¸Šã®ã€Œã‚¢ãƒ—ãƒªã®è¿½åŠ ã€ã‹ã‚‰Fusion Tablesã‚’æŽ¢ã—ã¦æœ‰åŠ¹åŒ–ã—ã¾ã™ã€‚ç™»å ´ã—ã¦ã‹ã‚‰æ•°å¹´çµŒã¡ã¾ã™ãŒã¾ã ï¼ˆè©¦é¨“é‹ç”¨ï¼‰ã®ã¾ã¾ã§ã™ãã€‚Â æœ‰åŠ¹åŒ–ã™ã‚‹ã¨æ–°è¦ãƒ¡ãƒ‹ãƒ¥ãƒ¼ã«ç¾ã‚Œã‚‹ã®ã§ã‚¯ãƒªãƒƒã‚¯ã—ã¦èµ·å‹•ã—... ã„ã‚ã„ã‚ã‚¢ãƒ—ãƒªã‚’å°Žå…¥ã§ãã‚‹ã‚‰ã—ã„ã®ã§ã™ãŒã€ãã®ä¸ã‹ã‚‰ã€ã€ŒFusion Tablesï¼ˆè©¦é¨“é‹ç”¨ï¼‰ã€ã‚’é¸ã³ã¾ã™ã€‚ã¾ã è©¦é¨“é‹ç”¨ã¿ãŸã„ã§ã™ãã€‚ å°Žå…¥ã™ã‚‹ã¨ãƒ¡ãƒ‹ãƒ¥ãƒ¼ã«ç¾ã‚Œã¾ã™ã€‚ãã‚Œã‚’ã‚¯ãƒªãƒƒã‚¯ã€‚ ä»¥ä¸‹ã®ç”»é¢ãŒç¾ã‚Œ
mkawano 2016/02/04
google

google apps

database

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
MySQLã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ–¹æ³•ãŒé€²åŒ–ã—ã¦ã„ãŸï¼ - sakaikã®æ—¥ã€…é›‘æ„Ÿï½ž(T)ç·¨
ãƒãƒ¼ã‚¸ãƒ§ãƒ³5.6 ãŒå¾…æœ›ã®GAã¨ãªã‚Šã¾ã—ãŸï¼æ—©é€Ÿã€ã‚ã„ã¦ã„ãŸã‚µãƒ¼ãƒã«å…¥ã‚Œã¦ã¿ã¾ã—ãŸã€‚ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«å¾Œã®è¨å®šãŒã€è‡³ã‚Œã‚Šå°½ãã›ã‚Šã«ãªã£ã¦ã„ã¦ã€ã³ã£ãã‚Šï¼*1 ã¡ã‚‡ã£ã¨å¼•ç”¨ãŒé•·ããªã‚‹ã‘ã©ã€æ•¢ãˆã¦é€”ä¸ã®ã‚«ãƒƒãƒˆã¨ã‹ã‚’ã—ãªã„ã§è¼‰ã›ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ã‚ã€linux(CentOS) ã¸ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã§ã™ã€‚ ã¾ãšã€å–å¾—ã—ãŸrpmã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ä½¿ã£ã¦ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¾ã™ã€‚ # rpm -ivh MySQL-server-5.6.10-1.rhel5.x86_64.rpm Preparing... ########################################### [100%] 1:MySQL-server ########################################### [100%]ã™ã‚‹ã¨ã€æ•°åˆ†é–“ã‹ã‘ã¦ã€ä»¥ä¸‹ã®ã‚ˆã†ãªæ–‡å—åˆ—ãŒã¤ã‚‰ã¤ã‚‰ã¨è¡¨ç¤ºã•ã‚Œã¦ãã¾ã™ï¼ˆã“ã“ã§ã¯ã€ã‚³ãƒ¡ãƒ³ãƒˆã‚’ã„
mkawano 2013/02/07
ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«

mysql

database
ãƒªãƒ³ã‚¯
MySQLã®å†—é•·åŒ– 2013-01-24
ï¼œSKILL BASECAMP 2013ï¼ž MySQLã®å†—é•·åŒ–ï½žç„¡åœæ¢é‹ç”¨ã‚’å®Ÿç¾ã™ã‚‹ã«ã¯ï½ž http://www.pasonatech.co.jp/entry/index.jsp?mode=2&d=on&no=3756
mkawano 2013/01/29
mysql

database

å†—é•·åŒ–

é‹ç”¨

slideshare

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
æ¬¡æœŸCiNiiã®è©¦é¨“å…¬é–‹ã‚’ã¯ã˜ã‚ã¾ã—ãŸ - @i2kã®ãƒ–ãƒã‚°
ã“ã®4æœˆã«ãƒªãƒ‹ãƒ¥ãƒ¼ã‚¢ãƒ«ã™ã‚‹ã€å›½ç«‹æƒ…å ±å¦ç ”ç©¶æ‰€ã®è«–æ–‡æ¤œç´¢ã‚µãƒ¼ãƒ“ã‚¹CiNiiï¼ˆã‚µã‚¤ãƒ‹ã‚£ï¼‰ã®è©¦é¨“å…¬é–‹ã‚’ã¯ã˜ã‚ã¾ã—ãŸã€‚ http://ciexam.nii.ac.jp/ http://ci.nii.ac.jp/ï¼ˆè¿½è¨˜ï¼šæ£å¼ç‰ˆã‚’å…¬é–‹ã—ã¾ã—ãŸï¼‰ CiNiiã®ãƒªãƒ‹ãƒ¥ãƒ¼ã‚¢ãƒ«ã¯2å¹´ãŒã‹ã‚Šã®å¤§ä»•äº‹ã§ã€ã¼ãå€‹äººã¨ã—ã¦ã‚‚ç ”ç©¶æ‰€ã§ã®ä»•äº‹ã®å¤§åŠã¯ã“ã‚Œã§ã—ãŸã€‚ã“ã®ã‚ˆã†ãªå½¢ã§å…¬é–‹ã™ã‚‹ã“ã¨ãŒã§ãã¦ã€ã¾ãšã¯ä¸€æ®µè½ã¨ã„ã†ã¨ã“ã‚ã§ã™ã€‚ æ–°ã—ã„CiNiiã§ã™ãŒã€åŸºæœ¬çš„ã«ã¯è«–æ–‡æ¤œç´¢ã‚µãƒ¼ãƒ“ã‚¹ã‚’ç²›ã€…ã¨æä¾›ã™ã‚‹ã¨ã„ã†ã“ã¨ã§æ©Ÿèƒ½çš„ã«å¤§ããªå¤‰åŒ–ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚é•·ã‚‰ãã®èª²é¡Œã ã£ãŸè² è·å¯¾ç–ã‚’ä¸‡å…¨ã«ã™ã‚‹ã®ã¨ã€ãƒ‡ã‚¶ã‚¤ãƒ³ãƒ»ãƒ¦ãƒ¼ã‚¶ãƒ“ãƒªãƒ†ã‚£ã‚’ã‚ˆãã™ã‚‹ã®ãŒç¬¬ä¸€ã®ãƒ†ãƒ¼ãƒžã§ã—ãŸã€‚ ãã‚Œã«åŠ ãˆã¦ã€ã¼ããŒã©ã†ã—ã¦ã‚‚å…¥ã‚ŒãŸã‹ã£ãŸã®ãŒãƒ¡ã‚¿ãƒ‡ãƒ¼ã‚¿ã‚’æä¾›ã™ã‚‹æ©Ÿèƒ½ã§ã™ã€‚æ¤œç´¢æ©Ÿèƒ½ã¯OpenSearchã«å¯¾å¿œã—ã€RSS 1.0ï¼ˆã™ãªã‚ã¡RDFï¼‰ã¨Atom 1.0ã‚’è¿”ã™ã‚ˆã†ã«ã—ã¾ã—ãŸ
mkawano 2009/03/12
å›³æ›¸é¤¨

library

nlp

rdf

foaf

è«–æ–‡

database

search

research
ãƒªãƒ³ã‚¯
ã‚¯ãƒãƒ¼ãƒªãƒ³ã‚°ã—ã¦ã‚‹æš‡ãŒã‚ã‚‹ãªã‚‰â€¦è«–æ–‡ã‹ã„ãŸã‚‰? | EDGE Datasets(ç ”ç©¶ç”¨ãƒ‡ãƒ¼ã‚¿ã‚»ãƒƒãƒˆ)
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session. Dismiss alert
mkawano 2009/03/11
ç ”ç©¶

research

sbm

database

livedoor

web

ã“ã‚Œã¯ã™ã”ã„
ãƒªãƒ³ã‚¯
MySQL FULLTEXT Ngram : LIKEæ¤œç´¢ã‚ˆã‚Šæ•°åå€é«˜é€Ÿãªã€ãŠæ‰‹è»½ æ—¥æœ¬èªžå…¨æ–‡æ¤œç´¢ ã«ã¤ã„ã¦ï½œblogï½œãŸãŸã¿ãƒ©ãƒœ
tatamilab.jp
mkawano 2007/03/15
database

db

mysql

search

å…¨æ–‡æ¤œç´¢
ãƒªãƒ³ã‚¯
MySQLã§å…¨æ–‡æ¤œç´¢ - FULLTEXTã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åŸºç¤ŽçŸ¥è˜ï½œblogï½œãŸãŸã¿ãƒ©ãƒœ
tatamilab.jp
mkawano 2007/03/15
database

db

mysql

å…¨æ–‡æ¤œç´¢

search

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

optimize

db

database

performance

tuning

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°

ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹
ãƒªãƒ³ã‚¯
çž¬æ™‚ã«ãƒ†ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿ã‚’å¤§é‡ç”Ÿæˆã—ã¦ãã‚Œã‚‹ã€ŽData Generatorã€ - IDEA*IDEA ï½ž ç™¾å¼ç®¡ç†äººã®ãƒ©ã‚¤ãƒ•ãƒãƒƒã‚¯ãƒ–ãƒã‚° ï½ž
We'll be back soon! Our site is currently undergoing maintenance. Please check back later.
mkawano 2006/12/04
é–‹ç™º

development

database

db

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

database

db

tuning

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

æœ€é©åŒ–
ãƒªãƒ³ã‚¯
Tags: Database schemas
An online tech community is the most exciting place for a software developer to spend their time. It not only offers the chance to work and interact remotely, but also helps in honing oneâ€™s own skills and becoming a well-rounded programmer. Whether you are a budding software developer or simply passionate about techno logy, here are the best online software development communities you can join. The
mkawano 2006/11/16
database

db

tag

tagging
ãƒªãƒ³ã‚¯
ç¬¬1å›žã€€ã©ã†ã—ã¦Webï¼‹DBãŒæ±‚ã‚ã‚‰ã‚Œã‚‹ã‚ˆã†ã«ãªã£ã¦ããŸã®ã‹ï¼šITpro
ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼ˆDBï¼‰ã‚·ã‚¹ãƒ†ãƒ ã‚’è£å´ã§ç¨¼å‹•ã•ã›ã¦ã„ã‚‹ä¼æ¥ã‚µã‚¤ãƒˆãŒæ€¥å¢—ã—ã¦ã„ã¾ã™ã€â€•â€•ã“ã‚Œã ã‘æ›¸ãã¨æ•°å¹´å‰ã«èªžã‚Šã¤ãã•ã‚ŒãŸãƒ‹ãƒ¥ãƒ¼ã‚¹ã§ã™ã€‚ç¢ºã‹ã«å¤§ä¼æ¥ã¯ï¼Œè‡ªç¤¾ã®Webã‚·ã‚¹ãƒ†ãƒ ã«ä½•å„„å††ã¨ã„ã†è¦æ¨¡ã®æŠ•è³‡ã‚’ã—ã¦ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ´»ç”¨ã‚’æŽ¨é€²ã—ã¦ãã¾ã—ãŸã€‚ ã§ã¯ä¸å°ä¼æ¥ã§ã¯ã©ã†ã§ã—ã‚‡ã†ã‹ã€‚ ç§ã¯ç¾è·ã®Webãƒ—ãƒã‚°ãƒ©ãƒžã§ã™ã€‚å¤šãã®é–‹ç™ºæ¡ˆä»¶ã«ã‚¿ãƒƒãƒã—ã¦ãã¾ã—ãŸãŒï¼Œå¤§å¤šæ•°ã®ä¸å°ä¼æ¥ã«ã¯ãã‚“ãªäºˆç®—ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚è‡ªç¤¾ã‚µã‚¤ãƒˆã¯ãƒ¬ãƒ³ã‚¿ãƒ«ã‚µãƒ¼ãƒãƒ¼ã ã£ãŸã‚Šï¼Œãƒ‰ãƒ¡ã‚¤ãƒ³ã‚’å¥‘ç´„ãƒ—ãƒãƒã‚¤ãƒ€ä¸Šã§æ§‹ç¯‰ã—ã¦ã„ã‚‹ã¨ã„ã†è¦æ¨¡ï¼ˆå¹´é–“ç¶æŒè²»20ä¸‡ï½ž100ä¸‡å††ï¼‰ãŒã»ã¨ã‚“ã©ã§ã™ã€‚Webã‚„DBã«ã¤ã„ã¦æ·±ã„çŸ¥è˜ã®ã‚ã‚‹æ‹…å½“è€…ã‚‚ã„ã¾ã›ã‚“ã€‚ ã—ã‹ã—ï¼Œã“ã“3å¹´ã»ã©ï¼Œã“ã†ã—ãŸå°ã•ãªè¦æ¨¡ã®ä¼æ¥ã‚µã‚¤ãƒˆã‹ã‚‰ï¼Œç¶šã€…ã¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’çµ„ã¿è¾¼ã‚“ã Webã‚·ã‚¹ãƒ†ãƒ ã®é–‹ç™ºä¾é ¼ãŒèˆžã„è¾¼ã‚“ã§ãã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸã€‚ã‚‚ã¯ã‚„ï¼ŒWebï¼‹DBã‚·ã‚¹ãƒ†ãƒ ã¯ï¼ŒWebã‚µã‚¤ãƒˆã®è¦æ¨¡ã«é–¢ä¿‚ãªãå¸¸è˜ã¨ãªã‚Šã¤ã¤ã‚
mkawano 2006/10/25
database

web

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

database

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

database

db

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—

mysql

tool

ãƒ„ãƒ¼ãƒ«
ãƒªãƒ³ã‚¯
Googleã¯ãƒ‡ãƒ¼ã‚¿ã«ä½•ã‚‰ã‹ã®æ‰‹ã‚’åŠ ãˆã¦ã„ã‚‹ï¼Ÿã€€ã‚³ãƒ³ãƒ†ãƒ³ãƒ„æ™‚ä»£ã®ãƒ‡ãƒ¼ã‚¿åƒ
æ—¥æœ¬SGIã¯6æœˆ28æ—¥ã€æ±äº¬ãƒ»æµæ¯”å¯¿ã®ã‚¦ã‚§ã‚¹ãƒ†ã‚£ãƒ³ãƒ›ãƒ†ãƒ«æ±äº¬ã§ã€ŒSiliconLIVE! Forum 2006ã€ã‚’é–‹å‚¬ã—ãŸã€‚åŒãƒ•ã‚©ãƒ¼ãƒ©ãƒ ã®ä¸ã‹ã‚‰ã€ã€Œãƒžãƒ«ãƒãƒ¡ãƒ‡ã‚£ã‚¢ãƒ»ã‚³ãƒŸãƒ¥ãƒ‹ã‚±ãƒ¼ã‚·ãƒ§ãƒ³ï¼†ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ã¨é¡Œã—ãŸãŠèŒ¶ã®æ°´å¥³åå¤§å¦ç†å¦éƒ¨æƒ…å ±ç§‘å¦ç§‘ã®å¢—æ°¸è‰¯æ–‡æ•™æŽˆã®åŸºèª¿è¬›æ¼”ã‚’ç´¹ä»‹ã™ã‚‹ã€‚ DBã®ç ”ç©¶é–‹ç™ºã¯ã‚·ã‚¹ãƒ†ãƒ ã‹ã‚‰ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã¸ç§»è¡Œ å¢—æ°¸æ•™æŽˆã¯ã€ŒDBã¨ã¯ä½•ã‹ã€ã®èª¬æ˜Žã«ã¤ã„ã¦ã€ï½¢DBã«ã¯2ã¤æ„å‘³ãŒã‚ã‚‹ã€‚1ã¤ã¯DBã®ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã€‚ã‚‚ã†1ã¤ã¯ã€Oracleãªã©ãƒ‡ãƒ¼ã‚¿ã‚’ç®¡ç†ã™ã‚‹DBç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ï½£ã¨è§£èª¬ã—ãŸã€‚ãã—ã¦ã€DBã«é–¢ã™ã‚‹æœ€è¿‘ã®é–¢å¿ƒäº‹ã«ã¤ã„ã¦ã€ã€Œå¾“æ¥ã¯ã€DBç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ã«é–¢å¿ƒãŒé›†ã¾ã£ã¦ã„ãŸãŒã€æœ€è¿‘ã¯ã€ãƒ‡ãƒ¼ã‚¿ã‚¦ã‚¨ã‚¢ãƒã‚¦ã‚¹ãªã©ã«è“„ç©ã—ãŸãƒ‡ãƒ¼ã‚¿ã‹ã‚‰ã©ã†ã„ã£ãŸçŸ¥è˜ã€ãƒ«ãƒ¼ãƒ«ãŒå‡ºã¦ãã‚‹ã®ã‹ã€DBã®ä¸èº«ã«é–¢å¿ƒãŒç§»ã£ã¦ããŸã€ã¨è¿°ã¹ãŸã€‚ ã€ŒDBã¯ã‚ã‚Œã‚ã‚ŒãŒä½ã‚“ã§ã„ã‚‹ä¸–ã®ä¸ã®â€œå†™ã—çµµâ€ã ã€‚ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«DBã¯è¡¨ã®å½¢ã§ãƒ‡ãƒ¼ã‚¿ã‚’ç®¡ç†
mkawano 2006/06/29
google

database

db

web

ãƒžã‚¤ãƒ‹ãƒ³ã‚°

webãƒžã‚¤ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
ç´ æ—©ãæ£è¦å½¢ã‚’è¦‹æŠœãå®Ÿè·µãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ï¼ˆ1/4ï¼‰ ï¼ ï¼ IT
ä»Šå›žã®ãƒ†ãƒ¼ãƒžã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®å¿…é ˆçŸ¥è˜ã®1ã¤ã§ã‚ã‚‹ã€Œæ£è¦åŒ–ã€ã§ã™ã€‚æ£è¦åŒ–ã¯ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ†ãƒ¼ãƒ–ãƒ«è¨è¨ˆã‚’è¡Œã†ã†ãˆã§éžå¸¸ã«é‡è¦ãªãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã§ã‚ã‚Šã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’è¨è¨ˆã€å®Ÿè£…ã—ãŸã“ã¨ã®ã‚ã‚‹æ–¹ãªã‚‰ä¸€åº¦ã¯æ£è¦åŒ–ã«è§¦ã‚Œã¦ã„ã‚‹ã®ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚ ãã‚Œã»ã©åŸºæœ¬çš„ãªçŸ¥è˜ã§ã‚ã‚‹ã«ã‚‚ã‹ã‹ã‚ã‚‰ãšã€æ£è¦åŒ–ã‚’èª¬æ˜Žã§ãã‚‹äººã¯ãªã‹ãªã‹ã„ã¾ã›ã‚“ã€‚å¤šãèžã‹ã‚Œã‚‹ã®ãŒã€Œä½•ã¨ãªããƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œã‚‹ã¨è‡ªç„¶ã«ç¬¬3æ£è¦å½¢ã«ãªã‚‹ã€ã¨ã‹ã€Œå®Ÿå‹™ä¸Šã¯ç¬¬3æ£è¦åŒ–ã¾ã§è¡Œãˆã°å•é¡Œãªã„ã€ã¨ã„ã†ã‚‚ã®ã§ã™ã€‚ ã§ã¯ãªãœã€Œç¬¬3æ£è¦åŒ–ã¾ã§è¡Œãˆã°å•é¡Œãªã„ã€ã®ã§ã—ã‚‡ã†ã‹ã€‚æœ¬ç¨¿ã§ã¯ã²ã¨ã¨ãŠã‚Šæ£è¦åŒ–ã«ã¤ã„ã¦ç¢ºèªã—ãªãŒã‚‰ã€ã‚ã¾ã‚Šè§¦ã‚Œã‚‰ã‚Œã‚‹ã“ã¨ã®ãªã„ç¬¬3æ£è¦åŒ–ã‚ˆã‚Šå…ˆã®æ£è¦åŒ–ã‚’ç´¹ä»‹ã—ã¦ã€ã“ã®ç–‘å•ã«ç”ãˆã¦ã„ããŸã„ã¨æ€ã„ã¾ã™ã€‚ æ£è¦åŒ–ã®ä½ç½®ä»˜ã‘ æ£è¦åŒ–ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆå…¨èˆ¬ã«ã‹ã‹ã‚ã‚‹åŸºç¤ŽçŸ¥è˜ã§ã™ãŒã€ç‰¹ã«è«–ç†ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒªãƒ³ã‚°ã®ä½œæ¥ã®ä¸ã§å¿…è¦ã«ãªã‚Šã¾ã™ã€‚æœ¬ç¨¿
mkawano 2006/05/12
db

dbè¨è¨ˆ

database

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

æ£è¦å½¢

è¨è¨ˆ
ãƒªãƒ³ã‚¯
MySQLã®å°æŠ€
My WordPress Blog
mkawano 2006/04/13
mysql

sql

tips

ã¾ã¨ã‚

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

ä¾¿åˆ©

è³‡æ–™

db

database

MySQL
ãƒªãƒ³ã‚¯
1