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

hurvinek id:hurvinek

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

Oracleã¨MySQLã®æ¯”è¼ƒ
2.1 ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ»ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ ã“ã®é …ã«ã¯ã€MySQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨Oracle Databaseã®ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£å•é¡Œã«é–¢ã™ã‚‹æƒ…å ±ãŒå«ã¾ã‚Œã¦ã„ã¾ã™ã€‚ Oracleã¨åŒæ§˜ã«ã€MySQLãƒ¦ãƒ¼ã‚¶ãƒ¼ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã‚ˆã£ã¦ç®¡ç†ã•ã‚Œã¾ã™ã€‚ MySQLã§ã¯ã€ä¸€é€£ã®ä»˜ä¸Žè¡¨ã‚’ä½¿ç”¨ã—ã¦ã€ãƒ¦ãƒ¼ã‚¶ãƒ¼ã¨ãƒ¦ãƒ¼ã‚¶ãƒ¼ãŒæ‰€æœ‰ã§ãã‚‹æ¨©é™ã‚’è¿½è·¡ã—ã¾ã™ã€‚ MySQLã§ã¯ã€ãƒ¦ãƒ¼ã‚¶ãƒ¼ã«å¯¾ã—ã¦èªè¨¼ã€èªå¯ãŠã‚ˆã³ã‚¢ã‚¯ã‚»ã‚¹åˆ¶å¾¡ã‚’å®Ÿè¡Œã™ã‚‹éš›ã«ã€ã“ã‚Œã‚‰ã®ä»˜ä¸Žè¡¨ã‚’ä½¿ç”¨ã—ã¾ã™ã€‚ 2.1.1 ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹èªè¨¼ Oracleï¼ˆãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹èªè¨¼ã‚’ä½¿ç”¨ã™ã‚‹ã‚ˆã†ã«è¨å®šã—ãŸå ´åˆï¼‰ã‚„ã€ãƒ¦ãƒ¼ã‚¶ãƒ¼åã¨ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã®ã¿ã‚’ä½¿ç”¨ã—ã¦ãƒ¦ãƒ¼ã‚¶ãƒ¼ã‚’èªè¨¼ã™ã‚‹ä»–ã®ã»ã¨ã‚“ã©ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã¯ç•°ãªã‚Šã€MySQLã§ã¯ã€ãƒ¦ãƒ¼ã‚¶ãƒ¼ã‚’èªè¨¼ã™ã‚‹éš›ã«ã€è¿½åŠ ã®locationãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã‚’ä½¿ç”¨ã—ã¾ã™ã€‚ ã“ã®locationãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã¯ã€é€šå¸¸ã€ãƒ›ã‚¹ãƒˆåã€IPã‚¢ãƒ‰ãƒ¬ã‚¹ã¾ãŸã¯ãƒ¯ã‚¤ãƒ«ãƒ‰ã‚«ãƒ¼ãƒ‰ï¼ˆ%ï¼‰ã§ã™ã€‚ My
hurvinek 2008/12/19
oracle

mysql

*database
ãƒªãƒ³ã‚¯
http://blogs.sun.com/takemura/date/20081202
hurvinek 2008/12/19
Oracleâ†’MySQLç§»è¡Œ

*database

oracle

mysql
ãƒªãƒ³ã‚¯
ï¼»MySQLã‚¦ã‚©ãƒƒãƒï¼½ç¬¬17å›ž MS SQL Serverã‚„Oracleãªã©ã‹ã‚‰ã®ç§»è¡Œã‚’ç°¡å˜ã«ã™ã‚‹ã€ŒMySQL Migration Toolkitã€
ï¼»MySQLã‚¦ã‚©ãƒƒãƒï¼½ç¬¬17å›ž MS SQL Serverã‚„Oracleãªã©ã‹ã‚‰ã®ç§»è¡Œã‚’ç°¡å˜ã«ã™ã‚‹ã€ŒMySQL Migration Toolkitã€ MySQLã‚’æŽ¡ç”¨ã™ã‚‹ã‚·ã‚¹ãƒ†ãƒ ãŒç¢ºå®Ÿã«å¢—ãˆã¦ãŠã‚Šï¼Œã“ã®çž¬é–“ã‚‚æ–°ã—ã„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒMySQLã«ã‚ˆã£ã¦æ§‹ç¯‰ã•ã‚Œã¦ã„ã‚‹ã€‚ã—ã‹ã—ï¼Œæ—¢ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’é‹ç”¨ã—ã¦ã„ã‚‹é–‹ç™ºè€…ãŒï¼ŒMySQLã¸ä¹—ã‚Šæ›ãˆã‚‹ã«ã¯æ‰‹é–“ã¨æ™‚é–“ãŒå¿…è¦ã ã€‚ã‚‚ã¡ã‚ã‚“æŠ€è¡“ã‚‚è¦æ±‚ã•ã‚Œã‚‹ã€‚ ã“ã®ã‚ˆã†ãªæ—¢å˜ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‹ã‚‰MySQLã¸ã®ãƒžã‚¤ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã‚’æŽ¨é€²ã™ã‚‹ãŸã‚ï¼ŒMySQL ABç¤¾ã¯ç„¡å„Ÿãƒ„ãƒ¼ãƒ«ã€ŒMySQL Migration Toolkitã€ã®æä¾›ã‚’äºˆå®šã—ã¦ã„ã‚‹ã€‚ä»Šå›žã¯ï¼ŒMySQL Migration Toolkitã«ã‚ˆã‚‹ãƒžã‚¤ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ç´¹ä»‹ã™ã‚‹ã€‚ MySQL Migration Toolkitã®æ©Ÿèƒ½ MySQL Migration Toolkitã¯ï¼Œæ—¢å˜ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’MySQLã«ç§»è¡Œã™ã‚‹ãŸ
hurvinek 2008/12/19
Oracle â†’ MySQLãƒ‡ãƒ¼ã‚¿å¤‰æ›ãƒ„ãƒ¼ãƒ«

mysql

oracle

*database
ãƒªãƒ³ã‚¯
ã‚»ãƒƒã‚·ãƒ§ãƒ³ç®¡ç†ã«å‘ã„ã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ MySQL ? Oracle ?
Catalyst-Plugin-Session-Store-DBIC ã¨ã‹æ¤œè¨¼ã—ã¦ã¾ã™ã€‚ã§å‰ã‹ã‚‰æ°—ã«ãªã£ã¦ã¯ã„ãŸã®ã§ã™ãŒã€Perl ç•Œã§ã¯ã‚»ãƒƒã‚·ãƒ§ãƒ³ç®¡ç†ã™ã‚‹ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã¨ã„ãˆã°ã»ã¼å…¨ã¦ MySQL ãŒå‰æã£ã½ã„ä½œã‚Šã«ãªã£ã¦ã‚‹ã¨æ€ã„ã¾ã™ã€‚ã§ã‚‚æ¥å‹™ã§ä½¿ã£ã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ Oracle ã§ã—ã¦ã€ã†ã€œã‚“ãƒ»ãƒ»ãƒ»ã©ã†ã™ã£ã¹ã‹ãªãã€œã¨æ€ã£ã¦ã¾ã—ãŸã€‚ ã§ã€è©¦ã—ã« Oracle ã§ã‚»ãƒƒã‚·ãƒ§ãƒ³ç®¡ç†ã™ã‚‹ãŸã‚ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ã¤ãã£ã¦ã¿ã¾ã—ãŸã€‚Oracle ã¯ VACHAR2 åž‹ã¨ã‹ã¯ 4000 æ–‡å—ã¾ã§ã—ã‹æ‰±ãˆãªã„ã®ã§ã€ã‚»ãƒƒã‚·ãƒ§ãƒ³ãƒ‡ãƒ¼ã‚¿ã¨ã—ã¦ä½¿ã†ã«ã¯ã¡ã‚‡ã£ã¨ç‰©è¶³ã‚Šãªã„ãƒ‡ãƒ¼ã‚¿åž‹ã€‚CLOB åž‹ã‚’ä½¿ãˆã°è§£æ±ºã§ãã‚‹ã‚“ã§ã™ãŒã€DBI ãƒ™ãƒ¼ã‚¹ã«ã„ã‚ã„ã‚ã¨æŒ‡å®šã—ã¦ã‚ã’ãªã„ã¨ãƒ€ãƒ¡ã€‚ã—ã‹ã‚‚å¤šåˆ†é…ã„ã€‚é…ã„ã¨æŽ¨æ¸¬ã—ã¦ã„ãŸã‹ã‚‰ã€ä»Šã¾ã§ LOB ã‚„ LONG åž‹ã¯ã‚ãˆã¦ä½¿ã£ã¦ãã¾ã›ã‚“ã§ã—ãŸã€‚ session æ ¼ç´ã«ä½¿ã†ãƒ†ãƒ¼ãƒ–ãƒ«ã®æ§‹é€ ã¯ã“ã‚“ãª
hurvinek 2008/12/15
MySQLã®å‹ã¡

mysql

oracle

*database
ãƒªãƒ³ã‚¯
Did you reboot?:Mysqlã§ã‚·ãƒ¼ã‚±ãƒ³ã‚¹ã®ã‚·ãƒŸãƒ¥ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ - livedoor Blogï¼ˆãƒ–ãƒã‚°ï¼‰
Orable,Postgresãªã©ã‹ã‚‰ã€MySQLã‚„ã‚‹ãƒãƒ¡ã«ãªã£ãŸã‚¢ãƒŠã‚¿ï¼ ã¾ãšæ€ã†ã®ãŒã€ã‚·ãƒ¼ã‚±ãƒ³ã‚¹ãƒ†ãƒ¼ãƒ–ãƒ« (ã¤Ð´âŠ‚)ï½ºï¾žï½¼ï½ºï¾žï½¼ (Â´Ð”âŠ‚)ãƒŠãƒ¼ã‚¤ ï½¡ï¾Ÿ(ï¾ŸÂ´Ð”ï½€ï¾Ÿ)ã‚œï½¡ï½³ï½§ï½§ï½§ï¾ ä»Šæ—¥ã€DBç§»è¡Œä½œæ¥ã§ã‚„ã‚‹ãƒãƒ¡ã«ãªã‚Šã¾ã—ãŸã£ã£ã€‚ ãƒãƒžã£ãŸã®ã§ã€ãƒ¡ãƒ¢ã—ã¦ãŠãã¾ã™ã€‚è„‡ã®ä¸‹ã€è»½ãæ±—ã‹ã„ã¡ã‚ƒã„ã¾ã—ãŸã€‚ ã©ã†ã‚„ã‚‰LAST_INSERT_IDã‚’ä½¿ã†ã‚‰ã—ã„ã€‚ LAST_INSERT_ID(expr)ã«ã¤ã„ã¦ã€å…¬å¼ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã«ã¯ä¸‹è¨˜ã®ã‚ˆã†ã«ã‚ã‚‹ã€‚ LAST_INSERT_ID(expr) ã®å¼•æ•°ã¨ã—ã¦ expr ã‚’æŒ‡å®šã—ãŸå ´åˆã€å¼•æ•°ã®å€¤ãŒé–¢æ•°ã‹ã‚‰è¿”ã•ã‚Œã€ã“ã®å€¤ãŒ LAST_INSERT_ID() ã«ã‚ˆã£ã¦è¿”ã•ã‚Œã‚‹æ¬¡ã®å€¤ã¨ã—ã¦è¨å®šã•ã‚Œã‚‹ã€‚ ã†ã…ã€œã‚€ã€‚æ—¥æœ¬èªžé›£ã—ã„ã€‚ è©¦ã—ã«ã€ã‚„ã£ã¦ã¿ã‚‹ã€‚ ã¾ãšã€ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œæˆã™ã‚‹ã€‚ mysql> CREATE TABLE sequence (i
hurvinek 2008/12/12
MySQLã§Oracleã®ã‚ˆã†ãªã‚·ãƒ¼ã‚±ãƒ³ã‚¹ã‚’å®Ÿç¾

mysql

oracle

*database
ãƒªãƒ³ã‚¯
A5:SQL Mk-2 - ãƒ•ãƒªãƒ¼ã®æ±Žç”¨SQLé–‹ç™ºãƒ„ãƒ¼ãƒ«/ERå›³ãƒ„ãƒ¼ãƒ«
A5:SQL Mk-2ã¯è¤‡é›‘åŒ–ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é–‹ç™ºã‚’æ”¯æ´ã™ã‚‹ãŸã‚ã«é–‹ç™ºã•ã‚ŒãŸãƒ•ãƒªãƒ¼ã®SQLé–‹ç™ºãƒ„ãƒ¼ãƒ«ã§ã™ã€‚ é«˜æ©Ÿèƒ½ã‹ã¤è»½é‡ã§ã€ä½¿ã„æ–¹ãŒåˆ†ã‹ã‚Šã‚„ã™ã„ã“ã¨ã‚’ç›®æ¨™ã«é–‹ç™ºã•ã‚Œã¦ã„ã¾ã™ã€‚ SQLã‚’å®Ÿè¡Œã—ãŸã‚Šã€ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ç·¨é›†ã™ã‚‹ã»ã‹ã«ã€SQLã®å®Ÿè¡Œè¨ˆç”»ã‚’å–å¾—ã—ãŸã‚Šã€ERå›³ã‚’ä½œæˆã—ãŸã‚Šã™ã‚‹ã“ã¨ãŒå‡ºæ¥ã¾ã™ã€‚ ç‰¹å¾´ãƒ»æ©Ÿèƒ½ OCIæŽ¥ç¶šãƒ»ç›´æŽ¥æŽ¥ç¶šãƒ»ADOã¾ãŸã¯ODBCã‚’ä»‹ã—ãŸDBã¸ã®æŽ¥ç¶š Oracle Databaseã¯OCIçµŒç”±ã®æŽ¥ç¶šãƒ»ç›´æŽ¥æŽ¥ç¶šãŒå‡ºæ¥ã¾ã™ã€‚ PostgreSQLã¨MySQLã¯ç›´æŽ¥æŽ¥ç¶šãŒå‡ºæ¥ã¾ã™ã€‚ Microsoft SQL Serverã¯ã€OLE DBãƒ—ãƒãƒã‚¤ãƒ€ã‚’ç›´æŽ¥å‘¼ã³å‡ºã—ãŸæŽ¥ç¶šãŒã§ãã¾ã™ã€‚ IBM DB2ã¯ã€ODBCãƒ‰ãƒ©ã‚¤ãƒã‚’ç›´æŽ¥å‘¼ã³å‡ºã—ãŸæŽ¥ç¶šãŒã§ãã¾ã™ã€‚ ãã®ä»–ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã€ADOã¾ãŸã¯ODBCã‚’åˆ©ç”¨ã—ã¦æŽ¥ç¶šã—ã¾ã™ã€‚ Oracle, PostgreSQL, MySQLã¯ã€A5:SQL
hurvinek 2008/12/04
è‡³ã‚Œã‚Šå°½ãã›ã‚Šï¼Žè©¦ã™ï¼Ž

*database

*é–‹ç™º

*SoftWare

mysql

oracle
ãƒªãƒ³ã‚¯
1