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

legnum id:legnum

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

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

ã‚³ãƒ¼ã‚½ãƒ«Databaseã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®Blog
ã‚³ãƒ¼ã‚½ãƒ« Database ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®Blog ã¸ã‚ˆã†ã“ã ã‚³ãƒ¼ã‚½ãƒ« Database ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®Blogã§ã¯ã€ ã‚³ãƒ¼ã‚½ãƒ«æ‰€å±žã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãŒOracle Databaseã‚’ä¸å¿ƒã¨ã—ãŸDatabaseã«é–¢ã‚ã‚‹æŠ€è¡“æƒ…å ±ã‚’ç™ºä¿¡ã—ã¦ã„ã¾ã™ã€‚ ã‚³ãƒ¼ã‚½ãƒ«ã§ã¯ã€Oracle Databaseã‚’ã¯ã˜ã‚ã¨ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å…¨èˆ¬ã«é–¢ã‚ã‚‹ã‚µãƒ¼ãƒ“ã‚¹ï¼ˆã‚³ãƒ³ã‚µãƒ«ãƒ†ã‚£ãƒ³ã‚°ã€è¨è¨ˆã€æ§‹ç¯‰ãªã©ï¼‰ã€ã‚ªãƒ©ã‚¯ãƒ«è£½å“ã®ãƒ—ãƒãƒ€ã‚¯ãƒˆã‚µãƒãƒ¼ãƒˆã‚µãƒ¼ãƒ“ã‚¹ã‚’æä¾›ã—ã¦ã„ã¾ã™ã€‚ ã¾ãŸã€ä¸å®šæœŸã§ç„¡å„Ÿã®æŠ€è¡“ã‚»ãƒŸãƒŠãƒ¼ã‚’é–‹å‚¬ã—ã¦ã„ã¾ã™ã€‚ æ ªå¼ä¼šç¤¾ã‚³ãƒ¼ã‚½ãƒ« - ã‚µãƒ¼ãƒ“ã‚¹æ¡ˆå†… æ ªå¼ä¼šç¤¾ã‚³ãƒ¼ã‚½ãƒ« - ã‚»ãƒŸãƒŠãƒ¼æƒ…å ± ã‚³ãƒ¼ã‚½ãƒ«ã§ã¯ã€Oracle Databaseã‚¹ãƒšã‚·ãƒ£ãƒªã‚¹ãƒˆã«ãªã‚ŠãŸã„ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã€ Oracle Database æŠ€è¡“ã‚’æ´»ã‹ã—ã¦åƒããŸã„ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã‚’çµ¶è³›å‹Ÿé›†ä¸ã§ã™ã€‚ ã‚³ãƒ¼ã‚½ãƒ«ã«ã¤ã„ã¦çŸ¥ã‚‹ãŸã‚ã«ã¯ãƒ»ãƒ»ãƒ» æ ªå¼ä¼šç¤¾ã‚³ãƒ¼ã‚½ãƒ« - ä¼šç¤¾æƒ…å ± äººäº‹ãƒ–ãƒã‚° - ã€Žã‚³ãƒ¼
legnum 2013/12/03
sql

oracle

mysql

db

programming
ãƒªãƒ³ã‚¯
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å¹´é–“ã§çš†ã•ã¾ã®çŸ¥è˜
legnum 2012/09/13
db

sql

oracle

mysql

pstgresql
ãƒªãƒ³ã‚¯
å•†ç”¨ã‚µã‚¤ãƒˆã§ã‚‚MySQLã®æŽ¡ç”¨ã¯ã‚ã‚Šã¨æ€ã£ã¦ã¾ã—ãŸãŒã€ä¸Šå¸ã«ã‚ˆã‚‹ã¨ã€MySQLã¯æ¤œç´¢ãŒé…ãã¦SQLæ–‡ã«ã‚‚åˆ¶é™ãŒã‚ã‚‹ã‹ã‚‰è‰¯ããªã„... - Y...
ã‚‚ã†ã“ã‚Œã¯æ–‡åŒ–ã®é•ã„ã§ã™ã€‚MySQL ãªã‚“ã¦ã‚ªãƒ¢ãƒãƒ£ã¯ãƒ€ãƒ¡ã¨ã„ã† äººã‚‚ã„ã‚Œã°ã€MySQL ã§ä½•åå„„ãƒ¬ã‚³ãƒ¼ãƒ‰ã§ã‚‚ã„ã‘ã‚‹ã‚ˆ! ã¨ã„ã†äººã‚‚ ã„ã¾ã™ã€‚ ä»¥ä¸‹ã€ãŠã‚‚ã†ã¨ã“ã‚ã‚’ã¤ã‚‰ã¤ã‚‰ã¨æ›¸ã„ã¦ã¿ã¾ã™ã€‚ â—æ©Ÿèƒ½ é•ã„ã¯å¤šã€…ã‚ã‚Šã¾ã™ãŒã€å€‹äººçš„ã«ã¯è¡¨å±¤çš„ãªå•é¡Œã¨æ€ã„ ã¾ã™ã®ã§ã€ã“ã“ã§ã¯è§¦ã‚Œã¾ã›ã‚“ã€‚ â—çµŒé¨“ã®æœ‰ç„¡ ã‚ãŸã—ã¯ Oracleãƒ»MySQL ä½¿ã„ã§ã™ãŒã€DB2 ã¨ã‹ SQLServer ã‚’ä½¿ã£ã¦ã¨è¨€ã‚ã‚Œã‚‹ã¨å°»è¾¼ã¿ã—ã¾ã™ã€‚DB2 ã‚„ SQLServer ãŒ æ‚ªã„ã¨è¨€ã£ã¦ã„ã‚‹ã‚ã‘ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ã‚ˆãçŸ¥ã‚‰ãªã„ä¸–ç•Œ ã ã‹ã‚‰ã§ã™ã€‚ ä¸Šå¸ã®æ–¹ã‚‚çŸ¥ã‚‰ãªã„ä¸–ç•Œã«é£›ã³è¾¼ã‚€ã®ã¯æ€–ã„ã§ã—ã‚‡ã†ã€‚MySQL ã‚’ æŽ¨ã—ãŸã„ã®ã§ã‚ã‚Œã°ã€ãã®ä¸å®‰ã‚’è§£æ¶ˆã™ã‚‹ãŸã‚ã«ã€ ã€Œã‚ãŸã—ãŒè©³ã—ã„ã®ã§ç¤¾å†…æ•™è‚²ã—ã¾ã™ã‚ˆã€ ã€Œæœ‰å„Ÿã‚µãƒãƒ¼ãƒˆã‚ã‚Šã¾ã™ã‚ˆã€ ã€Œåœ§å€’çš„ã«ã‚³ã‚¹ãƒˆãŒé•ã„ã¾ã™ã‚ˆã€ ã€Œã¾ãšã¯ãƒ—ãƒãƒˆã‚¿ã‚¤ãƒ—é–‹ç™ºã§ MySQL ä½¿ã£ã¦ã¿ã¾ã›ã‚“ã‹?ã€ ãªã©ã€ä¸Š
legnum 2011/12/16
è³ªå•ã®1ç‚¹ã«é™ã‚Œã°ãã‚“ãªäº‹ãªã„ã‚ˆã€ã ã‘ã©ãã‚Œã ã‘ã˜ã‚ƒãªã„ã‹ã‚‰ãŠã‚Œã‚‚ã“ã®è€ƒãˆã ãªã‚ã€‚ã©ã‚Œé¸ã‚“ã§ã‚‚ãƒˆãƒ©ãƒ–ãƒ«ã¯ã‚ã‚‹ã‚ã‘ã§ãã†ãªã£ãŸæ™‚ãªã‚‹ã¹ãã‚ã‚“ã©ãã•ã„ã“ã¨è¨€ã‚ã‚Œãªã„é¸æŠžã‚’ã—ã¦ã¾ã†ã€‚ã‚´ãƒªæŠ¼ã—ã™ã‚‹æ™‚ã¯è…¹ããã‚‹

db

oracle

mysql

sql
ãƒªãƒ³ã‚¯
IBM Developer
IBM Developer is your one-stop location for getting hands-on training and learning in-demand skills on relevant techno logies such as generative AI, data science, AI, and open source.
legnum 2011/11/29
db

mysql

oracle
ãƒªãƒ³ã‚¯
ã€ŽOracleã‚ˆã‚Šã‚‚MySQLã®æ–¹ãŒä¾¿åˆ©ã ã¨æ€ã†SQLæ§‹æ–‡æ¯”è¼ƒã€
mysql> select sysdate(); +---------------------+ | sysdate() | +---------------------+ | 2010-08-18 23:11:27 | +---------------------+ 1 row in set (0.00 sec) â– 2. ã‚·ãƒ¼ã‚±ãƒ³ã‚¹ä½œã‚‰ãªãã¦ã„ã„ è¡¨ã®åˆ—ã«auto_incrementå±žæ€§ã‚’ã¤ã‘ã‚‹ã“ã¨ã§ã€insertæ™‚ã«å‹æ‰‹ã«æŽ¡ç•ªã—ã¦ãã‚Œã‚‹ã€‚å˜ã«å›ºæœ‰ã®IDç•ªå·ã‚’æŒ¯ã‚ŠãŸã„æ™‚ã¯ä¾¿åˆ©ã™ãŽã‚‹ã€‚ä½•ã§Oracleã«ã¯ãªã„ã‚“ã ï¼Ÿã£ã¦ãã‚‰ã„ã€‚ãƒ†ãƒ¼ãƒ–ãƒ«ã”ã¨ã«ã‚·ãƒ¼ã‚±ãƒ³ã‚¹ä½œã£ã¦ç®¡ç†ã™ã‚‹ã®ã£ã¦çµæ§‹ã‚ã‚“ã©ã†ãã•ã„ã€‚ ãŸã ã€æ€§èƒ½é¢ã§è¨€ã†ã¨ã€ä»•çµ„ã¿çš„ã«ç®¡ç†ãƒ†ãƒ¼ãƒ–ãƒ«ã®è¡Œãƒãƒƒã‚¯ã‚’å–ã£ã¦ã—ã¾ã†ã¯ãšãªã®ã§ã€Oracleã®SEQUENCEã«ã¯å…¨ãæ•µã‚ãªã„ã§ã—ã‚‡ã†ã€‚å¾Œã¯ã€è¤‡æ•°ãƒ†ãƒ¼ãƒ–ãƒ«ã«åŒã˜ç•ªå·ã‚’æŒ¯ã‚ŠãŸã„ã¨ãã‚‚å›°ã‚‹ã€‚ â– 3.ä¸€åˆ—
legnum 2011/03/04
å…¨éƒ¨ã‚ã‚‹ã‚ã‚‹ã™ãŽã‚‹ï¼group byã®ç•ªå·æŒ‡å®šã¯ã¾ã‚order byã§ã‚‚ã»ã¨ã‚“ã©ã‚„ã‚‰ãªã„ã‹ã‚‰ã„ã£ã‹ãª

oracle

mysql

sql

programming

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

webservice

game

db

programming

tactics

biz

marketing

mysql
ãƒªãƒ³ã‚¯
è‡ªåˆ†ã§WEBã‚µãƒ¼ãƒ“ã‚¹ã‚’ä½œã‚ŠãŸã„ã¨æ€ã£ã¦ã„ã‚‹äººã¸
legnum 2011/01/08
æƒ…ç†±ã ã„ã˜ã ãªãƒ¼

anonymous

programming

vps

linux

mysql

db

server
ãƒªãƒ³ã‚¯
MySQLç”¨ã®SCOTTãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ - SH2ã®æ—¥è¨˜
Oracleã‚’è§¦ã£ãŸã“ã¨ã®ã‚ã‚‹äººã¯ã€ä¸€åº¦ã¯SCOTTã‚¹ã‚ãƒ¼ãƒžã®EMPãƒ†ãƒ¼ãƒ–ãƒ«ã€DEPTãƒ†ãƒ¼ãƒ–ãƒ«ã‚’è¦‹ãŸã“ã¨ãŒã‚ã‚‹ã¨æ€ã„ã¾ã™ã€‚ãã‚Œãžã‚Œ14ãƒ¬ã‚³ãƒ¼ãƒ‰ã€4ãƒ¬ã‚³ãƒ¼ãƒ‰ã—ã‹ãªã„ã®ã«SQLã®åŸºç¤Žã‚’å¦ã¶ãŸã‚ã®è¦ç´ ãŒã„ã‚ã„ã‚è©°ã¾ã£ã¦ã„ã¦ã€ã¨ã¦ã‚‚ä¾¿åˆ©ãªã‚¹ã‚ãƒ¼ãƒžã§ã™ã€‚ ã¨ã„ã†ã‚ã‘ã§MySQLã«ç§»æ¤ã—ã¦ã¿ã¾ã—ãŸã€‚ create table dept (deptno decimal(2) primary key, dname varchar(14) , loc varchar(13)); create table emp (empno decimal(4) primary key, ename varchar(10), job varchar(9), mgr decimal(4), hiredate date, sal decimal(7,2), comm decimal(7,2), deptno decimal(2
legnum 2009/05/14
ã“ã‚Œã¯è‰¯ã„TIGERã®å·»

oracle

mysql

environment
ãƒªãƒ³ã‚¯
Oracleã®Sunè²·åŽã‚’æ”¯æŒã—ã¾ã™:Kenn's Clairvoyance
OracleãŒSunã‚’è²·åŽã™ã‚‹ã¨ã®ç™ºè¡¨ãŒã‚ã‚Šã¾ã—ãŸãŒã€ãƒãƒƒãƒˆä¸Šã§ã¯ã‚ã¾ã‚Šå¥½æ„çš„ãªæ„è¦‹ãŒãªã‹ã£ãŸã®ã§ã€ä¸€è¨€ã‚³ãƒ¡ãƒ³ãƒˆã—ãŸããªã‚Šã¾ã—ãŸã€‚ï¼ˆãƒ‡ã‚£ã‚¹ã‚¯ãƒãƒ¼ã‚¸ãƒ£ã€‚ã€‚ã€‚ã¨ã„ã†ã‚ã‘ã§ã‚‚ã‚ã‚Šã¾ã›ã‚“ãŒç†è€…ã¯æ–°å’ã§å…¥ç¤¾ã—ãŸä¼šç¤¾ãŒOracleã ã£ãŸã“ã¨ã‚‚ã‚ã‚Šã€é©å½“ã«å‰²ã‚Šå¼•ã„ã¦ã¿ã¦ãã ã•ã„ï¼‰ ã¨ã„ã†ã®ã‚‚ã€æ˜”ã‹ã‚‰ã‚·ãƒªã‚³ãƒ³ãƒãƒ¬ãƒ¼ã®ã€ŒãŠã—ã©ã‚Šå¤«å©¦ã€ã¨å‘¼ã°ã‚Œã‚‹ãã‚‰ã„ã€äº’ã„ãŒäº’ã„ã®æˆé•·ã‚’æ”¯ãˆåˆã£ã¦ããŸOracleã¨Sunã®ã‚³ãƒ³ãƒ“ãªã®ã ã‹ã‚‰ã€ã“ã®äºŒäººãŒãã£ã¤ãã®ã¯å®Ÿã«ã„ã„çµæœ«ã ã¨æ€ã£ã¦ã„ã‚‹ã®ã§ã™ã€‚ æ™‚ä»£ãŒãƒ¡ã‚¤ãƒ³ãƒ•ãƒ¬ãƒ¼ãƒ ã‹ã‚‰ãƒŸãƒ‹ã‚³ãƒ³ã€UNIXã¸ã¨å‘ã‹ã„ã€ãƒ€ã‚¦ãƒ³ã‚µã‚¤ã‚¸ãƒ³ã‚°ãŒé€²ã‚“ã 1980-1990å¹´ä»£ã€Sunã¨Oracleã¯ã¨ã‚‚ã«UNIXä¸–ä»£ã®ç›Ÿä¸»ã¨ã—ã¦å›è‡¨ã—ã¦ã„ã¾ã—ãŸã€‚ã¨ã“ã‚ãŒ2000å¹´ä»£ä»¥é™ã€ã•ã‚‰ã«UNIXã‹ã‚‰PCã‚µãƒ¼ãƒã¸ã¨ãƒ€ã‚¦ãƒ³ã‚µã‚¤ã‚¸ãƒ³ã‚°ãŒé€²ã‚€ã«ã¤ã‚Œã€ä¸¡è€…ã¯å…¸åž‹çš„ãªã‚¤ãƒŽãƒ™ãƒ¼ã‚·ãƒ§ãƒ³ã®ã‚¸ãƒ¬ãƒ³ãƒžã«é™¥ã£ã¦ã„ã¾ã—ãŸã€‚ãŸã¾ãŸã¾ç›´æŽ¥çš„ãªãƒ€
legnum 2009/04/22
ç¢ºã‹ã«ãã“ã¯ä»Šå¾Œã•ã‚‰ã«é¬±é™¶ã—ããªã‚Šãã†ã§å«Œã ãªãƒ¼ã¨æ€ã£ã¦ãŸã‘ã©ç¬¬äºŒç¬¬ä¸‰ã®MySQLã©ã†ã›å‡ºã¦æ¥ã‚‹ã‹ã‚‰ã‚ã‚“ã¾å¤‰ã‚ã‚‰ãªã„ã‚ˆã†ãªæ°—ã‚‚ï¼žã‚³ã‚¹ãƒˆãƒ€ã‚¦ãƒ³ã¨å¼•ãæ›¿ãˆã«ã‚‚ãŸã‚‰ã—ãŸè¤‡é›‘æ€§ï¼ˆçµ„ã¿åˆã‚ã›ã‚„ç›¸æ€§ï¼‰ã®å•é¡Œ

biz

management

oracle

mysql
ãƒªãƒ³ã‚¯
Oracleã¯Sunã®è¼ãã‚’æ°¸ä¹…ã«å¥ªã†
Oracleã«ã‚ˆã‚‹Sunã®è²·åŽã¯ã€ã¨ã‚Šã‚ã‘ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãƒ¼ã«ã¨ã£ã¦æ‚²ã—ã„å‡ºæ¥äº‹ã ã€‚OracleãŒã†ã‚‹ã•ã„ç«¶åˆè£½å“ã®MySQLã‚’ç”Ÿã‹ã—ç¶šã‘ã‚‹ç†ç”±ã¯ãªã„ã€‚ Oracleã¯Sun Microsystemsã‚’æ®ºãã†ã¨ã—ã¦ã„ã‚‹ã€‚ ä¸¡ç¤¾ã¯4æœˆ20æ—¥æœã€74å„„ãƒ‰ãƒ«ã®å–å¼•ã‚’ç™ºè¡¨ã—ãŸã€‚ä¸¡ç¤¾ã‚’é™¤ãITæ¥ç•Œå…¨ä½“ã«ã¨ã£ã¦ã€ã“ã‚Œã¯æ‚²ã—ã‚€ã¹ãå‡ºæ¥äº‹ã§ã‚ã‚‹ã€‚å–ªæœã‚’ç€ã¦ã€å“€æ‚¼ã®æ„ã‚’è¡¨ãã†ã§ã¯ãªã„ã‹ã€‚ã‚·ãƒªã‚³ãƒ³ãƒãƒ¬ãƒ¼ã§æœ€ã‚‚å„ªç§€ãªä¼æ¥ã®1ç¤¾ãŒæ¶ˆãˆãŸã®ã ã€‚ã‚·ãƒªã‚³ãƒ³ãƒãƒ¬ãƒ¼ãŒ1æœ¬ã®æœ¨ã ã¨ã™ã‚Œã°ã€Sunã¯ãã®å¤ªã„æ ¹ã®1æœ¬ã§ã‚ã‚‹ã€‚Sunã®å…±åŒå‰µæ¥è€…ã®ã‚¹ã‚³ãƒƒãƒˆãƒ»ãƒžã‚¯ãƒ‹ãƒ¼ãƒªãƒ¼æ°ã¯ã€åŒæ°ã‚’è¦‹ç¿’ã£ãŸå¤šãã®ã‚·ãƒªã‚³ãƒ³ãƒãƒ¬ãƒ¼ã®èµ·æ¥å®¶ã¨åŒã˜ãã‚¹ã‚¿ãƒ³ãƒ•ã‚©ãƒ¼ãƒ‰å¤§å¦å‡ºèº«ã§ã‚ã‚‹ã€‚ãƒžã‚¯ãƒ‹ãƒ¼ãƒªãƒ¼æ°ã‚’ã¯ã˜ã‚ã¨ã™ã‚‹ã‚¹ã‚¿ãƒ³ãƒ•ã‚©ãƒ¼ãƒ‰å¤§å‡ºèº«ã®èµ·æ¥å®¶ãŸã¡ã¯ã€ã‚·ãƒªã‚³ãƒ³ãƒãƒ¬ãƒ¼ã®æ–°èˆˆä¼æ¥ã«ã‚¤ãƒ³ãƒ†ãƒªã‚¸ã‚§ãƒ³ã‚¹ã¨ã‚¹ã‚¿ã‚¤ãƒ«ã‚’æŒã¡è¾¼ã‚“ã ã€‚1990å¹´ä»£ã‹ã‚‰2000å¹´ä»£åˆé ã«ã‹ã‘ã¦ã€
legnum 2009/04/21
ã‚„ã£ã±MySQLæ®ºã™ç‚ºã ã‘ãªã®ã‹ãªã‚ã€‚ç¢ºã‹ã«ãã“ã ã‘ã¯ã‚¬ãƒƒãƒ„ãƒªç´å¾—ã„ãã‚‚ã‚“ãªã‚

it

oracle

sun

mysql
ãƒªãƒ³ã‚¯
MySQLã®ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã‚’ç”¨ã„ãŸIntel X25-M SSDã®è©•ä¾¡ - SH2ã®æ—¥è¨˜
X25-Mã€SSDã§æ¤œç´¢ã—ã¦ãã‚‹æ–¹ãŒéžå¸¸ã«å¤šã„ã®ã§ã€æœ¬ãƒ–ãƒã‚°å†…ã®SSDé–¢é€£è¨˜äº‹ã‚’ãƒªã‚¹ãƒˆã—ã¦ãŠãã¾ã™ã€‚ MySQLã®ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã‚’ç”¨ã„ãŸIntel X25-M SSDã®è©•ä¾¡ (æœ¬è¨˜äº‹) SSDã®çœŸã®æ€§èƒ½ã‚’å¼•ãå‡ºã™ MySQL 5.1.38 InnoDB Plugin (2009/09/07) å…ˆé€±æœ«Intelã®SSDã€X25-MãŒçªç„¶7,000å††ã»ã©å€¤ä¸‹ãŒã‚Šã—ãŸã®ã§ã€ã¤ã„ã«æˆ‘æ…¢ã§ããšæ‰‹ã‚’å‡ºã—ã¦ã—ã¾ã„ã¾ã—ãŸã€‚åˆã‚ã¦ã®SSDå°Žå…¥ã§ã™ã€‚ SSDã®ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯è¨˜äº‹ã¯å›½å†…ãƒ»æµ·å¤–å•ã‚ãšãŸãã•ã‚“ã‚ã‚Šã¾ã™ãŒã€å®Ÿéš›ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä¹—ã›ã¦è¨ˆæ¸¬ã—ãŸè¨˜äº‹ã¯ãã‚Œã»ã©å¤šãã‚ã‚Šã¾ã›ã‚“ã€‚ãã“ã§ã€å…ˆæ—¥ã”ç´¹ä»‹ã—ãŸtpcc-mysqlã‚’ç”¨ã„ã¦ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ãƒ†ã‚¹ãƒˆã‚’è¡Œã£ã¦ã¿ã¾ã—ãŸã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒ OS ï¼š Windows XP SP3 32bit CPU ï¼š Core2 Duo T7300 2.0GHz (EIST OFF)
legnum 2009/03/28
ãŠãŠç´ æ™´ã‚‰ã—ã„ã€‚å°Žå…¥äºˆå®šç„¡ãã¦ã‚‚ãƒ†ãƒ¼ãƒ–ãƒ«è¨è¨ˆè€ƒãˆã¨ã„ãŸæ–¹ãŒã„ã„ãªï¼žãƒ¡ãƒ¢ãƒªã«åŽã¾ã‚‰ãªã„å¤§ããªãƒ†ãƒ¼ãƒ–ãƒ«

db

mysql

storage

ssd

analyze
ãƒªãƒ³ã‚¯
DBç§»è¡Œã®7ã¤ã®ã‚¹ãƒ†ãƒƒãƒ—
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç§»è¡Œã§ã¯ã©ã®ã‚ˆã†ãªä½œæ¥ã‚’è¡Œã‚ãªã„ã¨ã„ã‘ãªã„ã®ã‹ï¼Ÿå…¨ä½“çš„ãªæµã‚Œã‚’ä¿¯çž°çš„ã«è¦‹ãªã‘ã‚Œã°ã€ä½œæ¥ã®è¦‹ç©ã‚‚ã‚Šãªã©ãŒé›£ã—ã„ã“ã¨ã ã‚ã†ã€‚ã¨ã„ã†ã‚ã‘ã§ã€ä»Šæ—¥ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç§»è¡Œæ™‚ã«å¿…è¦ã«ãªã‚‹ä½œæ¥ã«ã¤ã„ã¦7ã¤ã®ã‚¹ãƒ†ãƒƒãƒ—ã«åˆ†ã‘ã¦ç´¹ä»‹ã—ã‚ˆã†ã¨æ€ã†ã€‚è¨€ã†ã¾ã§ã‚‚ãªã„ã“ã¨ã§ã‚ã‚‹ãŒã€ç§»è¡Œæ™‚ã«ã¯æ—¢å˜ã‚·ã‚¹ãƒ†ãƒ ã‚’ç›´æŽ¥ã„ã˜ã‚‹ã‚ã‘ã§ã¯ãªã„ã€‚ï¼ˆç¨¼åƒä¸ã®ã‚·ã‚¹ãƒ†ãƒ ã‚’ç›´æŽ¥ã„ã˜ã‚‹ã®ã¯ã€èµ°ã£ã¦ã‚‹ã‚¯ãƒ«ãƒžã«ä¹—ã‚Šè¾¼ã‚€ã®ã¨åŒã˜ãã‚‰ã„å±é™ºãªè¡Œç‚ºã§ã‚ã‚‹ï¼ï¼ï¼‰é–‹ç™ºç”¨ã®ã‚·ã‚¹ãƒ†ãƒ ã‚’åˆ¥é€”ç”¨æ„ã—ã¦ä½œæ¥ã‚’é€²ã‚ã‚‹ã¨ã„ã†å‰æã§èªã‚“ã§æ¬²ã—ã„ã€‚ 1. ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æ§‹ç¯‰ã¾ãšã¯ä½•ã¯ã¨ã‚‚ã‚ã‚Œæ–°è¦ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ§‹ç¯‰ã™ã‚‹ã“ã¨ã§ã‚ã‚‹ã€‚MySQLã§ã‚ã‚Œã°å…¸åž‹çš„ãªæ§‹æˆã«ã—ã¦ãŠã‘ã°ãã‚Œãªã‚Šã«é«˜é€Ÿã«å‹•ä½œã™ã‚‹ã®ã§ã€ç´°ã‹ã„ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¯å¾Œã§å•é¡ŒãŒå‡ºã¦ã‹ã‚‰ã‚„ã‚Œã°è‰¯ã„ã€‚my.cnfã¯ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã®ä¸‹ã®support-filesãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã«ã‚ã‚‹ã‚‚ã®ã‚’å¼„ã£ã¦ã‚‚ã„ã„ã—ã€MySQL P
legnum 2009/03/23
db

oracle

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

db

mysql

search

tips
ãƒªãƒ³ã‚¯
1