[B! db] rudo108ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

rudo108 id:rudo108

dbã«é–¢ã™ã‚‹rudo108ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (12)

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

1æ—¥ã«100ä¸‡ãƒ¬ã‚³ãƒ¼ãƒ‰å¢—ãˆã‚‹å ´åˆã®ãƒ†ãƒ¼ãƒ–ãƒ«è¨è¨ˆ
MySQLï¼ˆãƒžã‚¤ã‚¨ã‚¹ã‚ãƒ¥ãƒ¼ã‚¨ãƒ«ï¼‰ã¯ã€TCX DataKonsultABç¤¾ãªã©ãŒé–‹ç™ºã™ã‚‹RDBMSï¼ˆãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ )ã§ã™ã€‚ä¸–ç•Œã§æœ€ã‚‚äººæ°—ã®é«˜ã„ã‚·ã‚¹ãƒ†ãƒ ã§ã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã§é–‹ç™ºã•ã‚Œã¦ã„ã¾ã™ã€‚MySQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒã¯ã€é«˜é€Ÿæ€§ã¨ä¿¡é ¼æ€§ãŒã‚ã‚Šã€Linuxã€UNIXã€Windowsãªã©ã®è¤‡æ•°ã®ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ ã§å‹•ä½œã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ PHPã¯ã€Webã‚µã‚¤ãƒˆæ§‹ç¯‰ã«ç‰¹åŒ–ã—ã¦é–‹ç™ºã•ã‚ŒãŸãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžã§ã™ã€‚å¤§ããªç‰¹å¾´ã®ã²ã¨ã¤ã¯ã€HTMLã«ç›´æŽ¥ãƒ—ãƒã‚°ãƒ©ãƒ ã‚’åŸ‹ã‚è¾¼ã‚€ã“ã¨ãŒã§ãã‚‹ã¨ã„ã†ç‚¹ã§ã™ã€‚PHPã‚’ç”¨ã„ã‚‹ã“ã¨ã§ã€HTMLã‚’å‹•çš„ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã¨ã—ã¦å‡ºåŠ›ã§ãã¾ã™ã€‚HTMLãŒãã®ã¾ã¾ãƒ–ãƒ©ã‚¦ã‚¶ã«è¡¨ç¤ºã•ã‚Œã‚‹ã®ã«å¯¾ã—ã€PHPãƒ—ãƒã‚°ãƒ©ãƒ ã¯ã‚µãƒ¼ãƒå´ã§å®Ÿè¡Œã•ã‚ŒãŸçµæžœãŒãƒ–ãƒ©ã‚¦ã‚¶ã«è¡¨ç¤ºã•ã‚Œã‚‹ãŸã‚ã€PHPã‚¹ã‚¯ãƒªãƒ—ãƒˆã¯ã€Œã‚µãƒ¼ãƒã‚µã‚¤ãƒ‰ã‚¹ã‚¯ãƒªãƒ—ãƒˆã€ã¨å‘¼ã°ã‚Œã¦ã„ã¾ã™ã€‚
rudo108 2016/08/29
db

architecture
ãƒªãƒ³ã‚¯
gh-ost: GitHub's online schema migration tool for MySQL
AI & MLLearn about artificial intelligence and machine learning across the GitHub ecosystem and the wider industry. Generative AILearn how to build with generative AI. GitHub CopilotChange how you work with GitHub Copilot. LLMsEverything developers need to know about LLMs. Machine learningMachine learning tips, tricks, and best practices. How AI code generation worksExplore the capabilities and be
rudo108 2016/08/04
db

tools
ãƒªãƒ³ã‚¯
ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã¯å†åˆ©ç”¨ã®æ•µã§ã‚ã‚‹
é‡£ã‚Šã£ã½ã„ã‚¿ã‚¤ãƒˆãƒ«ã€‚ã€ŒRDBã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãŒçµ¡ã‚€ã¨ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³å´ã®ãƒ—ãƒã‚°ãƒ©ãƒ ãŒæ›¸ãã«ãããªã‚‹ã€ã¨ã„ã†è©±ã§ã™ã€‚ ã‚‚ã¡ã‚ã‚“ã§ã™ãŒã€RDBã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³æ©Ÿèƒ½ã¯å‰å¤§ã§ã‚ã‚Šã€Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ã‚‚æ„è˜ã—ã¦ä½¿ã‚ãªã‘ã‚Œã°ãªã‚‰ãšã€ã€Œãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãªã‚“ã¦ä½¿ã†ãªã€ã¨è¨€ã„ãŸã„ã‚ã‘ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ åˆæˆã§ããªã„é–¢æ•° PHPã§ç´ ã®PDOã‹ã‚‰è€ƒãˆã¾ã™ã€‚ãŸã¨ãˆã°ã€ä»¥ä¸‹ã®é–¢æ•°ã«å•é¡Œã¯ã‚ã‚‹ã§ã—ã‚‡ã†ã‹ï¼Ÿ <?php /* * å¤ã„ãƒ‡ãƒ¼ã‚¿ã‚’ã‚¢ãƒ¼ã‚«ã‚¤ãƒ–ãƒ†ãƒ¼ãƒ–ãƒ«ã«ç§»ã™é–¢æ•°ã®ã‚¤ãƒ¡ãƒ¼ã‚¸ */ function moveDataToArchive(PDO $db) { $db->beginTransaction(); try { $db->exec(' INSERT INTO archives SELECT * FROM data WHERE published < CURRENT_DATE '); $db->exec
rudo108 2016/05/19
db

sql
ãƒªãƒ³ã‚¯
Macã§ä½¿ãˆã‚‹PostgreSQL GUI client - Qiita
æœ€è¿‘Mac+Heorku+PostgreSQLã§ã‚¢ãƒ—ãƒªã‚’ä½œã‚‹ã“ã¨ãŒå¤šã„ã®ã§ã€GUIã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã‚’ã„ãã¤ã‹è©¦ã—ã¾ã—ãŸã€‚ ãªãŠã€ä»–ã®DBã§ã¯ MySQL: Sequel Pro SQLite 3: Base 2 ã‚’ä½¿ã£ã¦ã„ã¾ã™ã€‚ PG Commander, a PostgreSQL client for Mac ä»Šã®ã¨ã“ã‚ä¸€ç•ªä½¿ã„ã‚„ã™ã„ æœ‰æ–™(ä»Šæ—¥ç¾åœ¨: Â¥5,200) ã‚‚ã†ã¡ã‚‡ã£ã¨ä½¿ã£ãŸã‚‰æ‰•ã£ã¦ã—ã¾ãŠã†ã‹ã¨æ€ã£ã¦ã„ã‚‹ ç„¡æ–™ã§ã‚‚ä½¿ãˆã‚‹ æŽ¥ç¶šå…ˆã®ä¿å˜ã¯5ä»¶ã¾ã§ è¤‡æ•°ã‚¦ã‚£ãƒ³ãƒ‰ã‚¦ã‚’é–‹ã‘ãªã„ (PG Commander.appã‚’è¤‡è£½ã™ã‚‹ã“ã¨ã§å›žé¿å¯èƒ½ï¼Ÿ) Herokuã®PostgreSQLã«æŽ¥ç¶šã™ã‚‹æ–¹æ³• heroku configã—ã¦ã€DATABASE_URLã‚’ã‚¯ãƒªãƒƒãƒ—ãƒœãƒ¼ãƒ‰ã«ã‚³ãƒ”ãƒ¼(Command+C) PG Commanderã‚’èµ·å‹•ã—ã¦ã€New Favoriteã‚’æŠ¼ã™ã¨DBæƒ…å ±ãŒå…¥åŠ›æ¸ˆã«ãªã£ã¦ã„ã‚‹
rudo108 2015/12/17
db-client

db

mac
ãƒªãƒ³ã‚¯
Scalaã‚’ç”¨ã„ã¦åˆ†æ•£IDãƒ¯ãƒ¼ã‚«ã‚’å®Ÿè£…ã™ã‚‹ | ãƒãƒ£ãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ã‚¯ãƒªã‚¨ãƒ¼ã‚¿ãƒ¼ã‚ºãƒ–ãƒã‚°
ãŠä¹…ã—ã¶ã‚Šã§ã™ã€‚ã‹ã¨ã˜ã‚…ã‚“(@j5ik2o)ã§ã™ã€‚ã•ã¦ã€åƒ•ã¯ã€ChatWorkã«å…¥ç¤¾ã—ã¦ã‚‚ã€ç›¸å¤‰ã‚ã‚‰ãš Scala ã‚„ DDD ã‚’å®Ÿè·µã—ã¦ã„ã‚‹ã‚ã‘ã§ã™ãŒã€ä»Šå›žã¯å°‘ã—æ¯›è‰²ãŒé•ã†è©±ã‚’ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚å…ˆæ—¥ã€ChatWork Advent Calendar 2014 15æ—¥ç›®ã®è¨˜äº‹ã§ã€å®‰é”ãã‚“ãŒã€IDç”Ÿæˆå™¨ã®è©±ã‚’æ›¸ã„ã¦ãã‚ŒãŸã®ã§ã€ã›ã£ã‹ããªã®ã§ã€ChatWork Advent Calendar 2014 23æ—¥ç›®ã®è¨˜äº‹ã¨ã—ã¦ã€Scalaç‰ˆã‚‚èª¬æ˜Žã—ã¦ã¿ã‚ˆã†ã‹ã¨æ€ã„ã¾ã™ã€‚ PHPã§IDç”Ÿæˆå™¨ã‚’å®Ÿè£…ã—ã¦ã¿ã¾ã—ãŸ | ãƒãƒ£ãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ã‚¯ãƒªã‚¨ãƒ¼ã‚¿ãƒ¼ã‚ºãƒ–ãƒã‚° DBã®ã‚·ãƒ¼ã‚±ãƒ³ã‚¹ã«ã‚ˆã‚‹IDç”Ÿæˆã‚¦ã‚§ãƒ–ã‚µãƒ¼ãƒ“ã‚¹ã§ã¯ã€æ™‚ç³»åˆ—ãƒ‡ãƒ¼ã‚¿ã‚’æ‰±ã†ã“ã¨ã¯ã‚ˆãã‚ã‚Šã¾ã™ãŒã€ã‚¿ã‚¤ãƒ ã‚¹ã‚¿ãƒ³ãƒ—ãƒ™ãƒ¼ã‚¹ã§ãƒ¦ãƒ‹ãƒ¼ã‚¯ãªIDã‚’åˆ©ç”¨ã—ãŸã„ã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚æ–¹æ³•è«–ã¯ã„ãã¤ã‹ã‚ã‚Šã¾ã™ãŒã€ãŠæ‰‹è»½ãªIDç”Ÿæˆã¨ã„ãˆã°ã€DBã®ã‚·ãƒ¼ã‚±ãƒ³ã‚¹ã‚’ä½¿ã£ãŸã‚‚ã®ã§ã™ã€‚ã—ã‹ã—ãªãŒã‚‰
rudo108 2015/03/28
scala

db
ãƒªãƒ³ã‚¯
JDBCçµŒç”±ã§100ä¸‡ä»¶å–å¾—ãƒ»è¿½åŠ ã—ã¦ã¿ãŸ - kagamihogeã®æ—¥è¨˜
ç’°å¢ƒ jdk 1.7.0_05 eclipse 3.7 oracle 11g xe ojdbc6.jar setF etchSizeã®å¤‰æ›´ã«ã‚ˆã‚‹å½±éŸ¿ JDBCçµŒç”±ã§ãƒ‡ãƒ¼ã‚¿å–å¾—ã™ã‚‹ã¨ãã€java.sql.Statement#setF etchSize(int rows)ã§ãƒ•ã‚§ãƒƒãƒã™ã‚‹è¡Œæ•°ã‚’æŒ‡å®šã§ãã‚‹ã€‚ã“ã®è¡Œæ•°ã‚’å¤‰ãˆãŸã¨ãã€å®Ÿè¡Œæ™‚é–“ãŒã©ã®ç¨‹åº¦å¤‰ã‚ã‚‹ã‹ã‚’ç¢ºèªã™ã‚‹ã€‚ ã¾ãšä¸‹è¨˜ã®é©å½“ãªãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œã‚Šãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’100ä¸‡ä»¶å…¥ã‚Œã¦ãŠãã€‚ CREATE TABLE FROM_A_TBL (CLM VARCHAR2(16)); æ¬¡ã«ã“ã‚“ãªæ„Ÿã˜ã®ã‚³ãƒ¼ãƒ‰ã‚’å®Ÿè¡Œã™ã‚‹ã€‚å®Ÿè¡Œæ™‚é–“ã®è¨ˆæ¸¬æ‰‹é †ã¯ã€åŒä¸€ãƒ•ã‚§ãƒƒãƒã‚µã‚¤ã‚ºã§ä¸‰å›žé€£ç¶šå®Ÿè¡Œã™ã‚‹ã€‚ãã®å¾Œã€ãƒ•ã‚§ãƒƒãƒã‚µã‚¤ã‚ºã‚’å¤‰æ›´ã—ã¦å†åº¦å®Ÿè¡Œã€ã¨ã„ã†æµã‚Œã€‚ long start = System.currentTimeMillis(); Connection connection = Drive
rudo108 2015/02/27
java

jdbc

db
ãƒªãƒ³ã‚¯
ã€DBã¾ã¨ã‚ã€‘MySQLã‹ã‚‰PostgreSQL,SQLiteã¾ã§ - Qiita
PostgreSQLã¯ã€MySQLã¨åŒç’§ã‚’ãªã™ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®RDBMSè£½å“ã§ã™ã€‚ ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹è£½å“ã®ä¸ã§ã¯æ©Ÿèƒ½ãŒè±Šå¯Œã‹ã¤æ¨™æº–SQLã¸ã®æº–æ‹ åº¦ãŒæ¯”è¼ƒçš„é«˜ã„ã€‚ ABOUT æ¨™æº–SQLã¸ã®æº–æ‹ åº¦ãŒé«˜ã„ CPUæ•°ãŒå¢—ãˆãŸå ´åˆã®ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ãŒé«˜ãã€æŽ¥ç¶šæ•°ãŒå¢—ãˆã¦ã‚‚æ€§èƒ½ãŒç¶æŒã•ã‚Œã‚‹ ãƒžãƒ«ãƒãƒã‚¤ãƒˆå¯¾å¿œ PostGISã¨ã„ã†GIS(åœ°ç†æƒ…å ±ã‚·ã‚¹ãƒ†ãƒ ï¼‰ã‚’æ‰±ã†ã‚¢ãƒ‰ã‚ªãƒ³ã‚½ãƒ•ãƒˆãŒã‚ã‚Šã€ä½¿ã„å‹æ‰‹ãŒæ¯”è¼ƒçš„è‰¯ã„ OTHERS ãƒ†ãƒ¼ãƒ–ãƒ«åãªã©ã¯å¤§æ–‡å—å°æ–‡å—ã‚’åŒºåˆ¥ã—ãªã„ å¤§æ–‡å—ã‚’ä½¿ã„ãŸã„å ´åˆã¯"ã‚’ä½¿ç”¨ã™ã‚‹å¿…è¦ãŒã‚ã‚‹ DDLæ–‡ã‚‚ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å‡¦ç†ã®ä¸€éƒ¨ã¨ã—ã¦ç®¡ç†ã•ã‚Œã‚‹ãŸã‚ã€ã‚³ãƒŸãƒƒãƒˆå‰ã§ã‚ã‚Œã°ãƒãƒ¼ãƒ«ãƒãƒƒã‚¯ã«ã‚ˆã‚Šã‚ãƒ£ãƒ³ã‚»ãƒ«ã§ãã‚‹ ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©æ™‚ã«AUTO_INCREMENTæŒ‡å®šã‚’åˆ—ã«åŠ ãˆã‚‹äº‹ã§é€£ç•ªã‚’æŒ¯ã‚‹ã“ã¨ãŒã§ãã‚‹ SQLiteã¯ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ä¸€éƒ¨ã«çµ„ã¿è¾¼ã¾ã‚Œã¦å‹•ä½œã™ã‚‹ã‚¿ã‚¤ãƒ—ã®ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®RDBMSã€‚ å¤§è¦æ¨¡åˆ©
rudo108 2015/01/19
db
ãƒªãƒ³ã‚¯
é»’çŒ«ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢å·¥æˆ¿ - é»’çŒ« SQL Studio (æ±Žç”¨SQLé–‹ç™ºç’°å¢ƒ/é–‹ç™ºãƒ„ãƒ¼ãƒ«/ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆ)
â– é»’çŒ« SQL Studio Next é»’çŒ« SQL Studio Next ã¯ã€ã‚ã‚‰ã‚†ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æŽ¥ç¶šå¯èƒ½ãªæ±Žç”¨SQLé–‹ç™ºç’°å¢ƒã§ã™ã€‚ é»’çŒ« SQL Studio Next ã«ã¯ã€SQLã‚’æ‰‹æ—©ãä½œã‚‹ãŸã‚ã®å€™è£œè¡¨ç¤ºæ©Ÿèƒ½ã‚„ã€ SQLã‚’è¦–è¦šçš„ã« ãƒ‡ã‚¶ã‚¤ãƒ³ã™ã‚‹ãƒ“ã‚¸ãƒ¥ã‚¢ãƒ«ã‚¯ã‚¨ãƒªãƒ¼ãªã©ã€SQLé–‹ç™ºè€…ã«ä¾¿åˆ©ãªæ©Ÿèƒ½ãŒç”¨æ„ã•ã‚Œã¦ã„ã¾ã™ã€‚ é»’çŒ« SQL Studio Next ã¯ãƒ•ãƒªãƒ¼ã‚¦ã‚§ã‚¢ã§ã™ã€‚å€‹äººä½¿ç”¨ã€æ¥å‹™ä½¿ç”¨ã«é–¢ã‚ã‚‰ãšè‡ªç”±ã«ä½¿ç”¨ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ é»’çŒ« SQL Studio Next ã®ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ â– ã‚¯ã‚¤ãƒƒã‚¯ãƒ„ã‚¢ãƒ¼ ã¾ãŸã¯ã“ã¡ã‚‰ â‡’ é»’çŒ« SQL Studio Next ã‚¯ã‚¤ãƒƒã‚¯ãƒ„ã‚¢ãƒ¼ â– ç‰¹å¾´ é»’çŒ« SQL Studio Next ã¯ã€é–‹ç™ºç¾å ´ã§ã®ä½¿ã„å‹æ‰‹ã®è‰¯ã•ã‚’è¿½æ±‚ã—ã¦ã„ã¾ã™ã€‚ 1. ã‚ã‚‰ã‚†ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æŽ¥ç¶š ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŽ¥ç¶šã«ADOã‚’ä½¿ç”¨ã—ã¦ã„ã‚‹ãŸã‚ã€OLE DB ãƒ—ãƒãƒã‚¤ãƒ€(ã‚ã‚‹ã„ã¯OD
rudo108 2015/01/19
software

db

sql
ãƒªãƒ³ã‚¯
http://blog.ume108.mobi/?p=5649
rudo108 2015/01/19
db

licence

mysql

postgresql
ãƒªãƒ³ã‚¯
UNIQUE åˆ¶ç´„
UNIQUE åˆ¶ç´„ã‚’ä½¿ç”¨ã—ã¦ã€ä¸»ã‚ãƒ¼ã«é–¢ä¿‚ã—ãªã„ç‰¹å®šã®åˆ—ã«é‡è¤‡ã—ãŸå€¤ãŒå…¥åŠ›ã•ã‚Œãªã„ã‚ˆã†ã«ã§ãã¾ã™ã€‚UNIQUE åˆ¶ç´„ã‚‚ PRIMARY KEY åˆ¶ç´„ã‚‚ä¸€æ„æ€§ã‚’è¨å®šã—ã¾ã™ãŒã€ä¸»ã‚ãƒ¼ã§ã¯ãªã„åˆ—ã¾ãŸã¯åˆ—ã‚»ãƒƒãƒˆã«ä¸€æ„æ€§ã‚’è¨å®šã™ã‚‹å ´åˆã¯ã€PRIMARY KEY åˆ¶ç´„ã§ã¯ãªã UNIQUE åˆ¶ç´„ã‚’ä½¿ç”¨ã—ã¾ã™ã€‚ UNIQUE åˆ¶ç´„ã¯ 1 ã¤ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã«è¤‡æ•°å®šç¾©ã§ãã¾ã™ãŒã€PRIMARY KEY åˆ¶ç´„ã¯ 1 ã¤ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã« 1 ã¤ã—ã‹å®šç¾©ã§ãã¾ã›ã‚“ã€‚ ã¾ãŸã€PRIMARY KEY åˆ¶ç´„ã¨ã¯ç•°ãªã‚Šã€UNIQUE åˆ¶ç´„ã¯ NULL å€¤ã‚’è¨±å®¹ã§ãã¾ã™ã€‚ãŸã ã—ã€UNIQUE åˆ¶ç´„ãŒé©ç”¨ã•ã‚Œã‚‹ä»–ã®å€¤ã¨åŒæ§˜ã«ã€NULL å€¤ã‚‚ 1 åˆ—ã« 1 ã¤ã—ã‹ä½¿ç”¨ã§ãã¾ã›ã‚“ã€‚ UNIQUE åˆ¶ç´„ã¯ FOREIGN KEY åˆ¶ç´„ã‹ã‚‰å‚ç…§ã™ã‚‹ã“ã¨ã‚‚ã§ãã¾ã™ã€‚
rudo108 2013/02/08
tood

db
ãƒªãƒ³ã‚¯
æ•´åˆæ€§åˆ¶ç´„ - Oracle/ã‚ªãƒ©ã‚¯ãƒ«ã‚’ãƒžã‚¹ã‚¿ãƒ¼ã™ã‚‹ãŸã‚ã®åŸºæœ¬ã¨ä»•çµ„ã¿
æ•´åˆæ€§åˆ¶ç´„ã®ã‚¿ã‚¤ãƒ— ä¸»ã‚ãƒ¼åˆ¶ç´„ ï¼ ãƒ—ãƒ©ã‚¤ãƒžãƒªã‚ãƒ¼ è¡¨ã®å„è¡Œã‚’å®Œå…¨ã«ä¸€æ„ã«è˜åˆ¥ã§ãã‚‹ã‚«ãƒ©ãƒ ã¾ãŸã¯ã‚«ãƒ©ãƒ é›†åˆã§ã‚ã‚Šã€ã™ã¹ã¦ã®ã‚«ãƒ©ãƒ ã« NULL ã‚’å«ã¾ãªã„ã€‚ è˜åˆ¥ã™ã‚‹ã¨ã„ã†ã“ã¨ã¯ã€ä¾‹ãˆã°ä¼šå“¡ã‚’ç®¡ç†ã™ã‚‹å ´åˆã®ä¼šå“¡ç•ªå·ã‚’ã‚ã‚‰ã‚ã™ã€‚ ä¸»ã‚ãƒ¼ã¯åŽŸå‰‡ã¨ã—ã¦ã€å¤‰æ›´ã—ãªã„é …ç›®ã®é›†åˆã§ã‚ã‚‹ã“ã¨ãŒæœ›ã¾ã—ã„ã€‚ ã¾ãŸã€ä¸»ã‚ãƒ¼ã«ã¯è¡¨ã®ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã‚’è¡Œãªã†ã¨ã„ã†é‡è¦ãªå½¹å‰²ã‚‚ã‚ã‚‹ã€‚ ãã—ã¦ã€1 ã¤ã®è¡¨ã« 1 ã¤ã—ã‹å®šç¾©ã§ããªã„ã€‚ å‚è€ƒ â‡’ ä¸»ã‚ãƒ¼ãƒ»ãƒ—ãƒ©ã‚¤ãƒžãƒªã‚ãƒ¼ã®è¿½åŠ ã€å¤‰æ›´ã€å‰Šé™¤ ä¸»ã‚ãƒ¼ä»¥å¤–ã®ä¸»ã‚ãƒ¼ã«ãªã‚Šå¾—ã‚‹ã‚ãƒ¼ã®é›†ã¾ã‚Šã¯å€™è£œã‚ãƒ¼ã€ãã—ã¦ã€ä¸€æ„ã¨ãªã‚‹ã™ã¹ã¦ã®ãƒ‘ã‚¿ãƒ¼ãƒ³ã¯ã‚¹ãƒ¼ãƒ‘ãƒ¼ã‚ãƒ¼ã¨å‘¼ã°ã‚Œã‚‹ã€‚ ã‚ãƒ¼ã«ã¯ã‚¨ãƒ³ãƒ†ã‚£ãƒ†ã‚£æœ¬æ¥ãŒã‚‚ã¤è‡ªç„¶ã‚ãƒ¼ (ãƒŠãƒãƒ¥ãƒ©ãƒ«ã‚ãƒ¼)ã¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã‚ˆã£ã¦ç™ºç•ªã—ã¦ç®¡ç†ã™ã‚‹ä»£æ›¿ã‚ãƒ¼(ã‚µãƒã‚²ãƒ¼ãƒˆã‚ãƒ¼ï¼‰ãŒã‚ã‚‹ã€‚ è¤‡åˆä¸»ã‚ãƒ¼ ï¼ è¤‡åˆãƒ—ãƒ©ã‚¤ãƒžãƒªã‚ãƒ¼ ä¸»ã‚ãƒ¼ã§è¤‡æ•°ã®ã‚«ãƒ©ãƒ ã‹ã‚‰æ§‹æˆã•ã‚Œã¦ã„ã‚‹ã“ã¨ã‚’å¼·èª¿ã—ãŸã„å ´åˆã«ã¯
rudo108 2013/02/08
DB

todo
ãƒªãƒ³ã‚¯
Data::ObjectDriver
& COPYRIGHT Adam Thomason Akira Sawada Ben Trott Brad Choate Brad Fitzpatrick Brad Whitaker David Steinbrunner Garth Webb Graham Blankenbaker Jonathan Steinert Keita Jamadam Sugama Kenichi Ishigaki Kevin Goess Mark Paschal Mart Atkins Masahiro Iuchi Mischa Paul Lindner Sekimura Simon Wistow Takatsugu Shigeta Taku AMANO Tatsuhiko Miyagawa Tsuyoshi Watanabe Yann Kerherve ambs ziguzagu NAME Data::Obj
rudo108 2012/12/19
perl

cpan

db
ãƒªãƒ³ã‚¯
1