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

itboy id:itboy

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

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

Oracle Databaseã¨MySQLã¯ã€Œä½•ã€ãŒé•ã†ã®ã‹ã€€ã€Œã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã®é•ã„ã€ã‚’ç†è§£ã™ã‚‹
Oracle Databaseã¨MySQLã¯ã€Œä½•ã€ãŒé•ã†ã®ã‹ã€€ã€Œã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã®é•ã„ã€ã‚’ç†è§£ã™ã‚‹ï¼šå®Ÿè·µ OSSãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç§»è¡Œãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆï¼ˆ2ï¼‰ï¼ˆ1/3 ãƒšãƒ¼ã‚¸ï¼‰ æœ¬é€£è¼‰ã§ã¯ã€å•†ç”¨DBMSã‹ã‚‰OSSãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¸ã®ç§»è¡Œã‚’æ¤œè¨Žã™ã‚‹ä¼æ¥ã«å‘ã‘ã€ã€ŒMySQLã€ã¸ã®ç§»è¡Œãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã§å¿…è¦ã¨ãªã‚‹å…·ä½“çš„ãªãƒŽã‚¦ãƒã‚¦ã‚’ãŠå±Šã‘ã—ã¾ã™ã€‚ä»Šå›žã¯ã€ŒOracle Databaseã¨MySQLã®ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã®é•ã„ã€ã‚’è§£èª¬ã™ã‚‹ã¨ã¨ã‚‚ã«ã€æ£ã—ã„è¨å®šï¼ç§»è¡Œè¨ˆç”»ã«å‘ã‘ãŸãƒã‚¤ãƒ³ãƒˆã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ é€£è¼‰ãƒãƒƒã‚¯ãƒŠãƒ³ãƒãƒ¼ å‰å›žã¯ã€Oracle Databaseãªã©ã®å•†ç”¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ï¼ˆDBMSï¼‰è£½å“ã‹ã‚‰ã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ï¼ˆOSSï¼‰DBMSã§ã‚ã‚‹ã€ŒMySQLã€ã¸ã®ç§»è¡Œã‚’æ¤œè¨Žã™ã‚‹ä¼æ¥ãŒå¢—ãˆã¤ã¤ã‚ã‚‹ã“ã¨ã¨ã€å®Ÿéš›ã«ç§»è¡Œã™ã‚‹ãªã‚‰ã°ã€Œå…·ä½“çš„ã«ã€ä½•ã‚’è¡Œã£ã¦ã„ãã®ã‹ã€ã®é …ç›®å†…å®¹ã‚’èª¬æ˜Žã—ã¾ã—ãŸã€‚ ä»Šå›žã¯ã€DBMSã®ç§»è¡Œã§ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†è€…ã‚„
itboy 2016/12/01
oracle

database

mySQL
ãƒªãƒ³ã‚¯
PHP 5.5 ã§ mysql æ‹¡å¼µãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ãŒéžæŽ¨å¥¨ã«ãªã‚Šã€å°†æ¥ã«ãŠã„ã¦ WordPress ã‚’ç†é ã«ã•ã¾ã–ã¾ãª CMS ã®ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ä½œæ¥ãŒå¿…è¦ã«ãªã‚Šã¾ã™
PHP 5.5 ã§ mysql æ‹¡å¼µãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ãŒéžæŽ¨å¥¨ã«ãªã‚Šã€E_DEPRECATED ã‚¨ãƒ©ãƒ¼ãŒè¡¨ç¤ºã•ã‚Œã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸã€‚å°†æ¥ã® PHP ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã§å‰Šé™¤ã•ã‚Œã¾ã™ã€‚ mysql æ‹¡å¼µãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã«ä¾å˜ã™ã‚‹ CMS ã‚’ä½¿ã£ã¦ã‚µã‚¤ãƒˆã‚’é‹ç”¨ã—ã¦ã„ã‚‹å ´åˆã€å°†æ¥ã€é‹ç”¨ã‚µãƒ¼ãƒãƒ¼ã«å°Žå…¥ã•ã‚Œã¦ã„ã‚‹ PHP ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®åˆ‡ã‚Šæ›¿ãˆã«å‚™ãˆã¦ã€ mysqli ã‚‚ã—ãã¯ PDO ã«å¯¾å¿œã—ãŸ CMS ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¸ã®ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ã™ã‚‹ã‹ã€åˆ¥ã® CMS ã‚„ã‚¦ã‚§ãƒ–ã‚µãƒ¼ãƒ“ã‚¹ã«åˆ‡ã‚Šæ›¿ãˆã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ å¤šãã® PHP è£½ã® CMS ãŒå…±æœ‰ãƒ›ã‚¹ãƒ†ã‚£ãƒ³ã‚°ã«ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œã¦ãŠã‚Šã€å…±æœ‰ãƒ›ã‚¹ãƒ†ã‚£ãƒ³ã‚°ã¯æ¯”è¼ƒçš„å¤ã„ PHP ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®ã‚µãƒãƒ¼ãƒˆã‚’ç¶šã‘ã‚‹å‚¾å‘ã«ã‚ã‚Šã¾ã™ãŒã€å¤ã„ PHP ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚’ä½¿ã„ç¶šã‘ã‚‹å ´åˆã€PHP ã®ãƒã‚°ã‚„ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã®æœªå¯¾å¿œã€ã‚ˆã‚Šæ–°ã—ã„ PHP ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚’æœ€å°ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¨ã™ã‚‹ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‚„ CMS ã‚’å°Ž
itboy 2013/04/11
mySQL

php
ãƒªãƒ³ã‚¯
Rails ã§ã€Controller ã«å®šç¾©ã•ã‚Œã¦ã„ã‚‹ action ã‚’ä¸€åº¦ã«å–å¾—ã™ã‚‹æ–¹æ³•ã¯ã‚ã‚Šã¾ã™ã‹ï¼Ÿ - QA@IT
å¹³ç´ ã‚ˆã‚ŠQAï¼ ITã‚’ã”åˆ©ç”¨ã„ãŸã ãã€èª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ QAï¼ ITã¯ã€Œè³ªå•ã‚„å›žç”ã‚’ã€Žå…±æœ‰ã€ã—ã€Žç·¨é›†ã€ã—ã¦ã„ãã“ã¨ã§ãƒ™ã‚¹ãƒˆãªQAã‚’è“„ç©ã§ãã‚‹ã€IT ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ãŸã‚ã®å•é¡Œè§£æ±ºã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãƒ¼ã€ã¨ã—ã¦ç´„7å¹´é–“é‹å–¶ã‚’ã—ã¦ãã¾ã—ãŸã€‚ã“ã‚Œã¾ã§ã‚µãƒ¼ãƒ“ã‚¹ã‚’ç¶šã‘ã‚‹ã“ã¨ãŒã§ããŸã®ã¯ã€QAï¼ ITã®ã‚³ãƒ³ã‚»ãƒ—ãƒˆã«å…±æ„Ÿã‚’ã„ãŸã ãã€é©åˆ‡ãªè³ªå•ã‚„å›žç”ã‚’ãŠå¯„ã›ã„ãŸã ã„ãŸçš†ã•ã¾ã®ã”æ”¯æ´ãŒã‚ã£ãŸã‹ã‚‰ã“ãã¨è€ƒãˆã¦ãŠã‚Šã¾ã™ã€‚é‡ãã¦å¾¡ç¤¼ç”³ã—ä¸Šã’ã¾ã™ã€‚ ã—ã‹ã—ãªãŒã‚‰ã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®æƒ…å ±å…¥æ‰‹æ–¹æ³•ã®å¤šæ§˜åŒ–ã‚„QAã‚µãƒ¼ãƒ“ã‚¹å¸‚å ´ã®çŠ¶æ³ã€ï¼ ITã®ä»Šå¾Œã®ãƒ¡ãƒ‡ã‚£ã‚¢é‹å–¶æ–¹é‡ãªã©ã‚’æ¤œè¨Žã—ãŸçµæžœã€2020å¹´2æœˆ28æ—¥ï¼ˆé‡‘ï¼‰15:00ã‚’ã‚‚ã¡ã¾ã—ã¦QAï¼ ITã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã™ã‚‹ã“ã¨ã«ã—ã¾ã—ãŸã€‚ ã“ã‚Œã¾ã§ã”åˆ©ç”¨ã‚’ã„ãŸã ãã¾ã—ãŸçš†ã•ã¾ã«ã¯æ®‹å¿µãªãŠçŸ¥ã‚‰ã›ã¨ãªã‚Šã€èª ã«å¿ƒè‹¦ã—ãæ€ã£ã¦ãŠã‚Šã¾ã™ã€‚ä½•ã¨ãžã€ã”ç†è§£ã‚’ã„ãŸã ã‘ã¾ã™ã¨å¹¸ã„ã§ã™ã€‚ QAï¼ ITã®7å¹´é–“ã§çš†ã•ã¾ã®çŸ¥è˜
itboy 2012/09/13
postgresql

mySQL

database
ãƒªãƒ³ã‚¯
https://jp.techcrunch.com/2012/08/21/20120818oracle-makes-more-moves-to-kill-open-source-mysql/
itboy 2012/08/21
mySQL

oracle
ãƒªãƒ³ã‚¯
åˆå¿ƒè€…å‘ã‘MySQLã®å§‹ã‚æ–¹
1. åˆå¿ƒè€…å‘ã‘ MySQLã®å§‹ã‚æ–¹ MySQL Beginners Talk ã¨ã¿ãŸã¾ã•ã²ã‚ 2012-05-29 åˆå¿ƒè€…å‘ã‘MySQLã®å§‹ã‚æ–¹ - MySQL Beginners Talk Powered by Rabbit 1.0.6 2. è‡ªå·±ç´¹ä»‹ âœ“ ã¨ã¿ãŸã¾ã•ã²ã‚ âœ“ MySQLãƒ¦ãƒ¼ã‚¶ä¼š(ä»£è¡¨) âœ“ id:tmtms âœ“ @tmtms âœ“ Rubyã‹ã‚‰MySQLã‚’ä½¿ã†ãƒ©ã‚¤ãƒ–ãƒ©ãƒªæ›¸ã„ãŸã‚Š 1/80 åˆå¿ƒè€…å‘ã‘MySQLã®å§‹ã‚æ–¹ - MySQL Beginners Talk Powered by Rabbit 1.0.6
itboy 2012/05/30
mySQL

database
ãƒªãƒ³ã‚¯
ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆ
2. è‡ªå·±ç´¹ä»‹ ï® MySQL/Linuxå‘¨ã‚Šã®ã‚¹ãƒšã‚·ãƒ£ãƒªã‚¹ãƒˆ ï¬ 2006å¹´9æœˆã‹ã‚‰2010å¹´8æœˆã¾ã§MySQL æœ¬å®¶(MySQL/Sun/Oracle)ã§ APAC/USåœã®MySQL ã‚³ãƒ³ã‚µãƒ«ãƒ†ã‚£ãƒ³ã‚°ã«å¾“äº‹ ï¬ ä¸»ãªè‘—æ›¸ã«ã€Œç¾å ´ã§ä½¿ãˆã‚‹MySQLã€ã€ŒLinux-DBã‚·ã‚¹ãƒ†ãƒ æ§‹ç¯‰/ é‹ç”¨å…¥é–€ã€ã€ŒJavaãƒ‡ãƒ¼ã‚¿ã‚¢ã‚¯ã‚»ã‚¹å®Ÿè·µè¬›åº§ã€ ï® DeNAã§ã®ä¸»ãªå½¹å‰² ï¬ å®‰å®šåŒ–/ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹/é‹ç”¨å‘¨ã‚Šã®ä¸é•·æœŸçš„ãªæ”¹å–„æ´»å‹• ï¬ L3ã‚µãƒãƒ¼ãƒˆ/é‹ç”¨/ãƒˆãƒ©ãƒ–ãƒ«ã‚·ãƒ¥ãƒ¼ãƒ†ã‚£ãƒ³ã‚° â€“ é›£åº¦ã®é«˜ã„MySQLå‘¨ã‚Šã®å•é¡Œã®æ ¹æœ¬åŽŸå› ã®ç‰¹å®šã¨è§£æ±º ï¬ å¤šãã®ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆæ”¯æ´ ï¬ ç¤¾å†…å‹‰å¼·ä¼š/ãƒˆãƒ¬ãƒ¼ãƒ‹ãƒ³ã‚° â€“ MySQLã‚„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å‘¨ã‚Šã®ãƒ™ã‚¹ãƒˆãƒ—ãƒ©ã‚¯ãƒ†ã‚£ã‚¹ã‚’ç¤¾å†…ã§å…±æœ‰ã—ã€ æŠ€è¡“ã‚¹ã‚ãƒ«ã‚’åº•ä¸Šã’ã™ã‚‹ ï¬ æŠ€è¡“ãƒžãƒ¼ã‚±ãƒ†ã‚£ãƒ³ã‚° â€“ å›½å†…å¤–ã®ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã‚„ã€æŠ€è¡“é›‘èªŒç‰
itboy 2011/01/17
database

development

MySQL
ãƒªãƒ³ã‚¯
Oracleã€MySQLã«é–¢ã™ã‚‹10ã®ç´„æŸã‚’ç™ºè¡¨
Sunè²·åŽã®å®Œäº†ã‚’æ€¥ãOracleãŒæ¬§å·žå§”å“¡ä¼šã«ã‚ˆã‚‹æ‰¿èªã‚’ç›®æŒ‡ã—ã€MySQLã®ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãƒ¼ç‰ˆé–‹ç™ºã‚„ãƒ™ãƒ³ãƒ€ãƒ¼ã«ã‚ˆã‚‹APIåˆ©ç”¨ã«é–¢ã™ã‚‹å…·ä½“çš„ãªâ€œå…¬ç´„â€ã‚’ç™ºè¡¨ã—ãŸã€‚ ç±³Oracleã¯12æœˆ14æ—¥ã€åŒç¤¾ã«ã‚ˆã‚‹ç±³Sun Microsystemsè²·åŽã«ã¤ã„ã¦å¯©æŸ»ã—ã¦ã„ã‚‹æ¬§å·žå§”å“¡ä¼šã®æ‡¸å¿µã‚’é™¤ããŸã‚ã€MySQLã«é–¢ã™ã‚‹10ã®ç´„æŸã‚’ç™ºè¡¨ã—ãŸã€‚ æ¬§å·žå§”å“¡ä¼šã¯ã€OracleãŒSunã®è²·åŽã«ã‚ˆã‚Šã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æœ€å¤§æ‰‹ã®MySQLã‚’ç²å¾—ã™ã‚‹ã“ã¨ãŒã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å¸‚å ´ã«ãŠã‘ã‚‹ç«¶äº‰ã«æ‚ªå½±éŸ¿ã‚’åŠã¼ã™ã“ã¨ã‚’æ‡¸å¿µã—ã¦ãŠã‚Šã€2010å¹´1æœˆ27æ—¥ã®æ±ºå®šã«å‘ã‘ã¦åŒè²·åŽå–å¼•ã‚’å¯©æŸ»ã—ã¦ã„ã‚‹ã€‚ Oracleã¯æ¬§å·žå§”å“¡ä¼šã¨ã“ã®æ‡¸å¿µã«é–¢ã—ã¦å»ºè¨çš„ãªè©±ã—åˆã„ã‚’è¡Œã£ãŸã¨ã—ã€å§”å“¡ä¼šã«åŒç¤¾ã®æ„å‘ã‚’å†ç¢ºèªã—ã¦ã‚‚ã‚‰ã†ãŸã‚ã€è©±ã—åˆã„ã§å–ã‚Šæ±ºã‚ãŸç´„æŸã‚’å…¬é–‹ã™ã‚‹ã¨ã„ã†ã€‚ç´„æŸã¯ä»¥ä¸‹ã®é€šã‚Šã€‚ MySQLã®Storage Engine APIã®ç¶™ç¶š M
itboy 2009/12/15
DBãƒ™ãƒ³ãƒ€ãŒåˆ¥ã®DBè£½å“ã‚’ãã®æ©Ÿèƒ½ã‚„é¡§å®¢ã‚’ç²å¾—ã™ã‚‹ä»¥å¤–ã«ä¿æœ‰ã™ã‚‹ãƒ¡ãƒªãƒƒãƒˆã£ã¦ãªã«ï¼Ÿã¨ã£ã¨ã¨æ‰‹æ”¾ã›ã°ã„ã„ã®ã§ã¯ã¨æ€ã£ã¦ã—ã¾ã†ã€‚

oracle

mySQL
ãƒªãƒ³ã‚¯
1