[B! database] k-holyã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

k-holy id:k-holy

databaseã«é–¢ã™ã‚‹k-holyã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (20)

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

ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸–ç•Œ
åºæ–‡ ç§ã®ä»•äº‹ã¯ã€DB ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã§ã™ã€‚ã¨ã„ã£ã¦ã‚‚åˆ¥ã«æœ›ã‚“ã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸–ç•Œã¸ããŸã‚ã‘ã§ã¯ãªãã€å½“åˆã€ç§ã¯ã“ã®åˆ†é‡ŽãŒé¢ç™½ãã‚ã‚Šã¾ã›ã‚“ã§ã—ãŸã€‚ã€ŒWebç³»ã¯èŠ±å½¢ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯æ—¥é™°ã€ã¨ã„ã†è¨€è‘‰ã‚‚å›ã‹ã‚Œã¦ã„ã¾ã—ãŸã€‚ä»Šã§ã‚‚å›ã‹ã‚Œã¦ã„ã‚‹ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚ ã§ã™ãŒã€ã—ã°ã‚‰ããƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’è§¦ã£ã¦ã„ã‚‹ã†ã¡ã«ã€ç§ã¯ã“ã®ä¸–ç•Œã«ã¨ã¦ã‚‚èˆˆå‘³æ·±ã„ãƒ†ãƒ¼ãƒžãŒå¤šãã‚ã‚‹ã“ã¨ã‚’çŸ¥ã‚Šã¾ã—ãŸã€‚ãªãœã‚‚ã£ã¨æ—©ãæ°—ã¥ã‹ãªã‹ã£ãŸã®ã‹ã€å¾Œæ‚”ã™ã‚‹ã“ã¨ã—ãã‚Šã§ã™ã€‚ ã‚‚ã¡ã‚ã‚“ã€è‡ªåˆ†ã®ä¸æ˜ŽãŒæœ€å¤§ã®åŽŸå› ã§ã™ãŒã€ã“ã®ä¸–ç•Œã«è¶³ã‚’è¸ã¿å…¥ã‚ŒãŸå½“æ™‚ã€å…ˆç”Ÿã‚‚ã€å°Žãã®æ›¸ã¨ãªã‚‹å…¥é–€æ›¸ã‚‚ãªã‹ã£ãŸã“ã¨ã‚‚äº‹å®Ÿã§ã™ã€‚ ä»Šã§ã“ããƒã‚¤ãƒ–ãƒ«ã¨ä»°ãã€Žãƒ—ãƒã‚°ãƒ©ãƒžã®ãŸã‚ã®SQL ç¬¬2ç‰ˆã€ã‚‚æ–°å…¥ç¤¾å“¡ã«ã¯æ•·å±…ãŒé«˜ã™ãŽã¾ã—ãŸ (2015å¹´2æœˆè¿½è¨˜ï¼šãã®å¾Œã€è‡ªåˆ†ã§ç¬¬4ç‰ˆã‚’è¨³å‡ºã§ããŸã®ã ã‹ã‚‰ã€ äººç”Ÿã¯ä½•ãŒã‚ã‚‹ã‹åˆ†ã‹ã‚‰ãªã„ã‚‚ã®ã§ã™)ã€‚ ãã“ã§ã€ã§ã™ã€‚ã“ã®ã‚µã‚¤ãƒˆã®ç›®çš„ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸–ç•Œã«è¶³ã‚’è¸ã¿
k-holy 2024/02/29
ãƒŸãƒƒã‚¯ã•ã‚“ã®è¨˜äº‹ã‚„è‘—æ›¸ã§SQLåŠ›ãŒä¸€æ®µéšŽä¸ŠãŒã£ãŸäººã¯å¤§å‹¢ã„ã‚‹ã¨æ€ã†ã€‚è‡ªåˆ†ã¯CASEå¼ã®ä½¿ã„æ–¹ã§ã‹ãªã‚ŠãŠä¸–è©±ã«ãªã£ãŸã€‚ã‚ã¨ã€RDBã§ãƒ„ãƒªãƒ¼æ§‹é€ ã‚’æ‰±ã†æ‰‹æ³•ã‚’æ—¥æœ¬èªžã§è§£èª¬ã—ã¦ã„ã‚‹æ•°å°‘ãªã„ã‚µã‚¤ãƒˆã ã£ãŸã€‚ç§»è»¢ã—ã¦ãŸã®ãã€‚

database

sql
ãƒªãƒ³ã‚¯
PostgreSQLã‚¢ãƒ³ãƒãƒã‚šã‚¿ãƒ¼ãƒ³
37. ç©ã¿é‡ãªã‚‹WHEREå¥ -- æœ‰åŠ¹ãªã‚¢ã‚«ã‚¦ãƒ³ãƒˆã®ãƒ–ãƒã‚°ã‚’å–ã£ã¦ããŸã„å ´åˆ SELECT * FROM blog INNER JOIN users ON users.id = blog.user_id AND users.delete_ï¬‚ag = 0 WHERE blog.delete_ï¬‚ag = 0 38. ç©ã¿é‡ãªã‚‹WHEREå¥ -- æœ‰åŠ¹ãªã‚¢ã‚«ã‚¦ãƒ³ãƒˆã®ãƒ–ãƒã‚°ã‚’å–ã£ã¦ããŸã„å ´åˆ SELECT * FROM blog INNER JOIN users ON users.id = blog.user_id AND users.delete_ï¬‚ag = 0 WHERE blog.delete_ï¬‚ag = 0 ãƒ¦ãƒ¼ã‚¶ã®å‰Šé™¤ãƒ•ãƒ©ã‚°ã‚’è¦‹ã‚‹ 39. ç©ã¿é‡ãªã‚‹WHEREå¥ -- æœ‰åŠ¹ãªã‚¢ã‚«ã‚¦ãƒ³ãƒˆã®ãƒ–ãƒã‚°ã‚’å–ã£ã¦ããŸã„å ´åˆ SELECT * FROM blog INNER JOIN users
k-holy 2015/11/30
database

postgresql
ãƒªãƒ³ã‚¯
è«–ç†å‰Šé™¤ã¨ãƒ¦ãƒ‹ãƒ¼ã‚¯ã‚ãƒ¼åˆ¶ç´„ã®ä¸¡ç«‹ - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
k-holy 2015/11/12
è«–ç†å‰Šé™¤ã«é™ã‚‰ãšä½•ã‚‰ã‹ã®ãƒ•ãƒ©ã‚°ã¨ä¸€æ„æ€§åˆ¶ç´„ã‚’çµ„ã¿åˆã‚ã›ã‚‹å ´åˆã«ä½¿ãˆãã†

database
ãƒªãƒ³ã‚¯
Web SQL Database
W3C Working Group Note 18 November 2010 This Version: http://www.w3.org/TR/2010/NOTE-webdatabase-20101118/ Latest Published Version: http://www.w3.org/TR/webdatabase/ Latest Editor's Draft: http://dev.w3.org/html5/webdatabase/ Previous Versions: http://www.w3.org/TR/2009/WD-webdatabase-20091222/ http://www.w3.org/TR/2009/WD-webdatabase-20091029/ http://www.w3.org/TR/2009/WD-webstorage-20090423/ Ed
k-holy 2015/07/31
html5

database
ãƒªãƒ³ã‚¯
RDBã«ãŠã‘ã‚‹ã‚ãƒ£ãƒƒã‚·ãƒ¥ã¨ã„ã†è€ƒãˆæ–¹
RDBã®å°‚é–€å®¶ã¨ã—ã¦æ—¥ã€…æ´»å‹•ã—ã¦ã„ã‚‹ä¸ã§æ°—ã¥ã„ãŸã“ã¨ã®ã²ã¨ã¤ã«ã€ã€ŒRDBã¯ãƒ‡ãƒ¼ã‚¿ã¸ã®ã‚¢ã‚¯ã‚»ã‚¹ã®å®Ÿè£…ã‚’ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«é ¼ã£ã¦ã„ã‚‹ãŒã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯å…¨ã¦ã®å•é¡Œã‚’è§£æ±ºã§ãã‚‹ã»ã©ä¸‡èƒ½ã§ã¯ãªã„ã€ã¨ã„ã†ã“ã¨ãŒã‚ã‚‹ã€‚ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¨ã„ã†ã®ã¯ã¨ã¦ã‚‚å¼·åŠ›ãªéƒ¨å“ã§ã‚ã‚Šã€ãã®ç‚¹ã«ã¯å…¨ãç•°è«–ã¯ãªã„ã€‚ã ãŒã€ä¸–ã®ä¸ã®å…¨ã¦ã®å•é¡Œï¼ˆã‚¯ã‚¨ãƒªï¼‰ã‚’è§£æ±ºã§ãã‚‹ã»ã©ã€æŸ”è»Ÿæ€§ã«å¯Œã‚“ã ã‚‚ã®ã§ã¯ãªã„ã¨ã„ã†ã“ã¨ã ã€‚RDBã¯ã€ã©ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ã£ã¦ãƒ‡ãƒ¼ã‚¿ã¸ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã‹ã¨ã„ã†ã“ã¨ã‚’ã€ã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶ã‚’ç”¨ã„ã¦åˆ¤æ–ã™ã‚‹ã€‚å¤§æŠµã®RDBè£½å“ã§ã¯ã€ã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶ã¯ã‚ˆã„ä»•äº‹ã‚’ã™ã‚‹ã®ã§ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¨ã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶ã®çµ„ã¿åˆã‚ã›ã«ã‚ˆã£ã¦ã€ã»ã¨ã‚“ã©ã®å•é¡Œã«å¯¾å¿œã§ãã‚‹ã€‚ã ãŒã€100%ã§ã¯ãªã„ã®ã§ã‚ã‚Šã€ãã®ã‚ˆã†ãªã‚±ãƒ¼ã‚¹ãŒã‚·ã‚¹ãƒ†ãƒ ã®æ€§èƒ½å•é¡Œã‚’å¼•ãèµ·ã“ã—ãŸã‚Šã€ãƒ—ãƒã‚°ãƒ©ãƒžï¼ˆã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®è¨è¨ˆè€…ï¼‰ã«ã€NoSQLã¸å®Œå…¨ã«ç§»è¡Œã—ãŸã‚Šã€ã‚¯ã‚¨ãƒªé«˜é€ŸåŒ–ã®ãŸã‚ã«éžæ£è¦åŒ–ã‚’ã™ã‚‹ã¨è¨€ã£
k-holy 2015/06/17
database
ãƒªãƒ³ã‚¯
SQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è©³è§£: é–‹ç™ºè€…ã®ãŸã‚ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°è§£èª¬æ›¸
å‰æ›¸ã ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã® å†…éƒ¨æ§‹é€ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ ãƒªãƒ¼ãƒ•ãƒŽãƒ¼ãƒ‰ æ¤œç´¢ ãƒ„ãƒªãƒ¼(Bãƒ„ãƒªãƒ¼) é…ã„ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ ãƒ‘ãƒ¼ãƒˆI where å¥ ç‰ä¾¡ æ¼”ç®—å ãƒ—ãƒ©ã‚¤ãƒžãƒªã‚ãƒ¼ è¤‡åˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ é…ã„ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ ãƒ‘ãƒ¼ãƒˆII é–¢æ•° - where å¤§æ–‡å—ãƒ»å°æ–‡å—ã‚’åŒºåˆ¥ã™ã‚‹ æ¤œç´¢ ãƒ¦ãƒ¼ã‚¶å®šç¾© é–¢æ•° ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ä½œã‚ŠéŽãŽ ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿åŒ– ã‚¯ã‚¨ãƒª ç¯„å›² æ¤œç´¢ å¤§ãªã‚Šã€å°ãªã‚Šã€ BETWEEN LIKEãƒ•ã‚£ãƒ«ã‚¿ã« å¯¾ã™ã‚‹ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®çµåˆ éƒ¨åˆ†ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ Oracleã«ãŠã‘ã‚‹NULL NULLã«å¯¾ã™ã‚‹ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ NOT NULL åˆ¶ç´„ éƒ¨åˆ†ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ ã‚¨ãƒŸãƒ¥ãƒ¬ãƒ¼ãƒˆã™ã‚‹ å‡¦ç†ã—ã«ãã„æ¡ä»¶ æ—¥ä»˜åž‹ æ•°å€¤æ–‡å—åˆ— åˆ—ã®é€£çµ ã‚¹ãƒžãƒ¼ãƒˆãªãƒã‚¸ãƒƒã‚¯ æ•°å¼ ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã¨ ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ ãƒ‡ãƒ¼ã‚¿ é‡ ã‚·ã‚¹ãƒ†ãƒ è² è· ãƒ¬ã‚¹ãƒãƒ³ã‚¹ ã‚¿ã‚¤ãƒ ã¨ã‚¹ãƒ«ãƒ¼ãƒ—ãƒƒãƒˆ çµåˆ å‡¦ç† å…¥ã‚Œå ãƒ«ãƒ¼ãƒ— ãƒãƒƒã‚·ãƒ¥ çµåˆ ã‚½ãƒ¼ãƒˆãƒž
k-holy 2015/04/07
database

book
ãƒªãƒ³ã‚¯
ã€ŒSQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è©³è§£ã€ã¨ã„ã†æœ¬ã‚’ç¿»è¨³ã—ã¾ã—ãŸ | b.l0g.jp
ã€ŒSQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è©³è§£ã€ã¨ã„ã†æœ¬ã‚’ç¿»è¨³ã—ã¾ã—ãŸ 2015-04-07 é¡Œã®é€šã‚Šã€ã€ŒSQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è©³è§£ã€(åŽŸæ–‡ã‚¿ã‚¤ãƒˆãƒ«SQL Performance Explained)ã¨ã„ã†æœ¬ã‚’ç¿»è¨³ã—ã¾ã—ãŸã€‚PDFç‰ˆã¨å°åˆ·ç‰ˆãŒä¸Šè¨˜ã‚µã‚¤ãƒˆã‹ã‚‰è³¼å…¥ã§ãã¾ã™ã€‚ (è¿½è¨˜ 2017å¹´9æœˆã‹ã‚‰ã€æ¸‹è°·ã®BOOK LAB TOKYOã•ã‚“ã§ã‚‚å°åˆ·ç‰ˆã‚’è²©å£²ã—ã¦ã„ãŸã ã„ã¦ã„ã¾ã™ã€‚è¼¸é€ã‚³ã‚¹ãƒˆã®é–¢ä¿‚ã§ã€ã‚µã‚¤ãƒˆã‹ã‚‰è³¼å…¥ã™ã‚‹ã‚ˆã‚Šè‹¥å¹²å®‰ããªã£ã¦ã„ã¾ã™) ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ãŠã„ã¦ã€SQLã¨ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒã©ã®ã‚ˆã†ã«é–¢é€£ã—ã€ã©ã®ã‚ˆã†ã«ã™ã‚Œã°SQLã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’è‰¯ãã§ãã‚‹ã®ã‹ã‚’è§£èª¬ã—ãŸæœ¬ã§ã™ã€‚ç‰¹å®šã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è£½å“ã«ç„¦ç‚¹ã‚’å½“ã¦ãŸæœ¬ã¯å¤šæ•°ã‚ã‚Šã¾ã™ãŒã€ã“ã®æœ¬ã§ã¯Oracle Databaseã€PostgreSQLã€MySQLã€SQL Serverã®4ã¤ã®ãƒ¡ã‚¸ãƒ£ãƒ¼ãªãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è£½å“ã‚’åŒæ™‚ã«æ‰±ã£ã¦ã„ã¦ã€ãã‚Œãžã‚Œã®ã‚¯
k-holy 2015/04/07
database

book
ãƒªãƒ³ã‚¯
é–‹ç™ºè€…ã®ãŸã‚ã®SQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®å…¨ã¦
å‰æ›¸ã - ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ä½œæˆã¯ãªãœé–‹ç™ºè€…ã®ã‚¿ã‚¹ã‚¯ãªã®ã‹ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã® å†…éƒ¨æ§‹é€ - ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯ä½•ã«ä¼¼ã¦ã„ã‚‹ã‹ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ ãƒªãƒ¼ãƒ•ãƒŽãƒ¼ãƒ‰ - äºŒé‡é€£çµãƒªã‚¹ãƒˆ æ¤œç´¢ ãƒ„ãƒªãƒ¼(Bãƒ„ãƒªãƒ¼) - ãƒãƒ©ãƒ³ã‚¹æœ¨ é…ã„ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ ãƒ‘ãƒ¼ãƒˆI - ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’é…ãã™ã‚‹2ã¤ã®åŽŸå› where å¥ - æ¤œç´¢ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’æ”¹å–„ã™ã‚‹ãŸã‚ã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½œæˆ ç‰ä¾¡ æ¼”ç®—å - ä¸€è‡´ã™ã‚‹ã‚ãƒ¼ã®æ¤œç´¢ ãƒ—ãƒ©ã‚¤ãƒžãƒªã‚ãƒ¼ - ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ä½¿ã„æ–¹ã‚’ç¢ºèª è¤‡åˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ - è¤‡æ•°åˆ—ã«å¯¾ã™ã‚‹ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ é…ã„ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ ãƒ‘ãƒ¼ãƒˆII - å‰ã®å•é¡Œç‚¹ãŒå†ã³ é–¢æ•° - whereå¥ã® ä¸ã§ã®é–¢æ•° å¤§æ–‡å—ãƒ»å°æ–‡å—ã‚’åŒºåˆ¥ã™ã‚‹ æ¤œç´¢ - UPPERã¨ LOWER ãƒ¦ãƒ¼ã‚¶å®šç¾© é–¢æ•° - é–¢æ•°ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åˆ¶é™ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ä½œã‚ŠéŽãŽ - å†—é•·æ€§ã®æŽ’é™¤æ³• ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿åŒ– ã‚¯ã‚¨ãƒª - ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã¨ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®ãŸã‚ã« ç¯„å›² æ¤œ
k-holy 2014/10/20
sql

database
ãƒªãƒ³ã‚¯
Adminer - Database management in a single PHP file
Adminer (formerly phpMinAdmin) is a full-featured database management tool written in PHP. Conversely to phpMyAdmin, it consist of a single file ready to deploy to the target server. Adminer is available for MySQL, MariaDB, PostgreSQL, SQLite, MS SQL, Oracle, Elasticsearch, Mongo DB and others via plugin. Features, Requirements, Skins, References Why is Adminer better than phpMyAdmin? Replace phpMy
k-holy 2014/08/08
php

database
ãƒªãƒ³ã‚¯
é•·å¹´ã®è°è«–ã«çµ‚æ¢ç¬¦ -- MySQLã€MariaDBã€PostgreSQLã®ã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶/ã‚¨ã‚¯ã‚¼ã‚ãƒ¥ãƒ¼ã‚¿æ¯”è¼ƒ - interdbâ€™s blog
https://mariadb.com/kb/en/optimizer-switch/ã«ã‚ã‚‹ã‚ˆã†ã«ã€MariaDBã®ã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶ã¯ã‹ãªã‚Šæ”¹è‰¯ã•ã‚Œã¦ã„ã‚‹ã€‚ ã§ã¯ã€MariaDBã®ã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶/ã‚¨ã‚¯ã‚¼ã‚ãƒ¥ãƒ¼ã‚¿ã¯ã©ã®ç¨‹åº¦å„ªç§€ã‹ã€ï¼”ã¤ã®SELECTæ–‡ã®å®Ÿè¡Œã‚’é€šã—ã¦MySQLã¨(ã¤ã„ã§ã«PostgreSQLã¨)æ¯”è¼ƒã—ã¦ã¿ã‚‹ã€‚ (2014.12.3è¿½è¨˜ï¼šã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶ã«ã¤ã„ã¦ã¯çœç•¥ã—ã¦ã¾ã™ãŒã€ã“ã‚“ãªæœ¬ãŒã§ã¾ã™ã€‚) çµè«–ã‚’å…ˆã«ã„ãˆã°ã€ŒMySQLã¯æ¤œç´¢ãŒé€Ÿã„ã€ã¨ã„ã†ã®ã¯éƒ½å¸‚ä¼èª¬ã€‚MariaDBã¯ãŒã‚“ã°ã£ã¦ã‚‹ã‘ã©PostgreSQLã«ã¯ã¾ã ã¾ã åŠã°ãšã€‚ ï¼Šå¿µã®ãŸã‚ã€‚ã“ã‚Œã¯ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã˜ã‚ƒãªã„ã‚ˆã€ã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶/ã‚¨ã‚¯ã‚¼ã‚ãƒ¥ãƒ¼ã‚¿ã®æ©Ÿèƒ½æ¯”è¼ƒã§ã™ã€‚ è‡ªåˆ†ã§å†ç¢ºèªã—ãŸã„å ´åˆã¯ã“ã¡ã‚‰ã«ã‚¹ã‚¯ãƒªãƒ—ãƒˆç¾¤ã¨å®Ÿé¨“ã®ã‚„ã‚Šæ–¹ã‚’ç°¡å˜ã«æ›¸ã„ãŸã®ã§å‚ç…§ã®ã“ã¨ã€‚ èª¿æŸ»ç’°å¢ƒ åŒä¸€ãƒžã‚·ãƒ³ã«MySQL5.6.14ã€MariaDB10.0.4ã€
k-holy 2013/10/23
ã‚¹ã‚±ãƒ¼ãƒ«ä¸è¦ãªè¦æ¨¡ã®ãŠä»•äº‹ã ã¨PostgreSQLã®ãŒç„¡é›£ãªã®ã‹ãªã€‚JOIN+ã‚µãƒ–ã‚¯ã‚¨ãƒªã§ã®count()ã¯å¤šç”¨ã—ã¦ã‚‹ã—ãªã

database

mysql

postgresql
ãƒªãƒ³ã‚¯
Clojureã®ä½œè€…ãŒä½œã£ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹DatomicãŒå‡„ã„
ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžClojureã®ä½œè€…Rich Hickeyæ°çŽ‡ã„ã‚‹Clojure Hackerã®ãƒãƒ¼ãƒ ãŒDatomic(ãƒ‡ãƒ¼ãƒˆãƒŸãƒƒã‚¯ã¨ç™ºéŸ³ã™ã‚‹ã‚‰ã—ã„)ã¨ã„ã†ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ãƒªãƒªãƒ¼ã‚¹ã—ã¾ã—ãŸã€‚ã“ã‚ŒãŒä½•ã‚„ã‚‰ã¨ã¦ã¤ã‚‚ãªã„ã§ã™ã€‚10å¹´å…ˆã‚’è¡Œã£ã¦ã‚‹æŠ€è¡“ã˜ã‚ƒãªã„ã§ã—ã‚‡ã†ã‹ã€‚ ã¾ã æœ¬ç•ªã‚µãƒ¼ãƒ“ã‚¹ã¯å§‹ã¾ã£ã¦ã„ã¾ã›ã‚“ãŒé–‹ç™ºç’°å¢ƒç”¨ã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªãŒé…å¸ƒã•ã‚Œã¦ã„ã¾ã™ã€‚ Datomicã¯æ–¬æ–°ãªã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ãªã®ã§ä¸€è¨€ã§èª¬æ˜Žã™ã‚‹ã®ã¯ã¨ã¦ã‚‚é›£ã—ã„ã§ã™ã€‚ ç§ãŒç†è§£ã§ããŸã“ã¨ã‚’ç°¡å˜ã«èª¬æ˜Žã—ã¾ã™ã€‚ 2014/1/20è¿½è¨˜ ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ãƒ¢ãƒ‡ãƒ«ã€ã‚µãƒãƒ¼ãƒˆã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã€ã‚µãƒ¼ãƒ“ã‚¹ã¨ã—ã¦ã§ã¯ãªãç‹¬ç«‹ã—ã¦ä½¿ç”¨ã™ã‚‹å½¢ã«ãªã‚‹ãªã©è¨˜äº‹ä½œæˆæ™‚ã®å†…å®¹ã‹ã‚‰è‰²ã€…å¤‰æ›´ãŒåˆã£ãŸéƒ¨åˆ†ã‚’æ›´æ–°ã—ã¾ã—ãŸã€‚ å¤‰æ›´ä¸å¯ãªAppend-onlyãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ å¾“æ¥ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã€ã‚ã‚‹ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’å¤‰æ›´ã™ã‚‹ã¨ã„ã†ã®ã¯ãã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã«å¯¾å¿œã—ãŸå ´æ‰€ãŒã‚ã‚Šã€ãã“ã®ãƒ‡ãƒ¼ã‚¿ã‚’æ›¸ãæ›ãˆã‚‹ã¨ã„ã†ã“
k-holy 2013/03/13
database

datomic
ãƒªãƒ³ã‚¯
CAPå®šç†ã‚’è¦‹ç›´ã™ã€‚â€œCAPã®3ã¤ã‹ã‚‰2ã¤ã‚’é¸ã¶â€ã¨ã„ã†èª¬æ˜Žã¯ãƒŸã‚¹ãƒªãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã ã£ãŸ
åˆ†æ•£ã‚·ã‚¹ãƒ†ãƒ ã«ãŠã„ã¦ã¯ä»¥ä¸‹ã®3ã¤ã®è¦ç´ ã®ã†ã¡2ã¤ã—ã‹åŒæ™‚ã«æº€ãŸã™ã“ã¨ãŒã§ããªã„ã€ã¨ã„ã†CAPå®šç†ã‚’æå”±ã—ãŸã®ã¯ã€Eric Breweræ°ã§ã—ãŸã€‚ Cï¼šConsistencyï¼ˆä¸€è²«æ€§ï¼‰ Aï¼šAvailabilityï¼ˆå¯ç”¨æ€§ï¼‰ Pï¼šTolerance to network Paritionsï¼ˆãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯åˆ†æ–ã¸ã®è€æ€§ï¼‰ ä¸€èˆ¬ã«ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã¯ã€ä¸€è²«æ€§ï¼ˆCï¼‰ã¨å¯ç”¨æ€§ï¼ˆAï¼‰ã‚’ã§ãã‚‹ã ã‘ä¿è¨¼ã™ã‚‹ä»£ã‚ã‚Šã«ã€ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯åˆ†æ–ã¸ã®è€æ€§ï¼ˆPï¼‰ã‚’çŠ ç‰²ã«ã—ã¦ã„ã¾ã™ã€‚ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ãŒé€”ä¸ã§åˆ‡ã‚ŒãŸã‚Šå¤§ããé…å»¶ã—ãŸå ´åˆã€å‹•ä½œãŒä¿è¨¼ã•ã‚Œãªããªã£ã¦ã—ã¾ã†ã‚ã‘ã§ã™ã€‚ ä¸€æ–¹ã§NoSQLã§ã¯ä¸€è²«æ€§ï¼ˆCï¼‰ã‚ˆã‚Šã‚‚å¯ç”¨æ€§ï¼ˆAï¼‰ã¨ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯åˆ†æ–ã¸ã®è€æ€§ï¼ˆPï¼‰ã‚’å„ªå…ˆã•ã›ã‚‹ã‚‚ã®ãŒå¤šãã€åˆ†æ•£ã‚·ã‚¹ãƒ†ãƒ ã§ã®å‹•ä½œã«å‘ã„ã¦ã„ã‚‹ã¨èª¬æ˜Žã•ã‚Œã¾ã™ã€‚ã“ã®ã‚ˆã†ã«NoSQLã®èª¬æ˜Žã«ã“ã®CAPå®šç†ãŒã—ã°ã—ã°å¼•ç”¨ã•ã‚Œã‚‹ã“ã¨ã«ãªã‚Šã€NoSQLã®æ™®åŠã¨ã¨
k-holy 2013/01/29
"CAPã®æœ¬è³ªã¯ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯åˆ†æ–ã«ã‚ˆã£ã¦å‡¦ç†ã®ã‚¿ã‚¤ãƒ ã‚¢ã‚¦ãƒˆãŒç™ºç”Ÿã—ãŸã¨ãã«è¡¨ã‚Œã‚‹"

database

education
ãƒªãƒ³ã‚¯
ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆã€€ã¾ã¨ã‚ - ãŠç¬‘ã„ãƒ—ãƒã‚°ãƒ©ãƒžã®æŠ€è¡“ãƒ¡ãƒ¢
ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã‚’ä½œã‚‹æ™‚ã«å‚è€ƒã«ãªã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚„KVSã®é¸å®šã€è¨è¨ˆãªã©ã®è¨˜äº‹ã‚„ã‚¹ãƒ©ã‚¤ãƒ‰ã®ã¾ã¨ã‚ 2013-02-03è¿½è¨˜ ã‚¹ãƒ©ã‚¤ãƒ‰ ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆ http://www.slideshare.net/matsunobu/ss-6584540 ã¨ã‚ã‚‹ã‚¢ãƒ—ãƒªã®é–‹ç™ºé‹ç”¨(ãƒˆãƒ©ãƒ–ãƒ«ã‚·ãƒ¥ãƒ¼ãƒˆ) http://www.slideshare.net/takafumionaka/ss-5852561 PHPã§å¤§è¦æ¨¡ãƒ–ãƒ©ã‚¦ã‚¶ã‚²ãƒ¼ãƒ ã‚’é–‹ç™ºã—ã¦ã‚ã‹ã£ãŸã“ã¨ http://www.slideshare.net/ketaiorg/php-4638298 Lampã§ä½œã‚‹ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚¢ãƒ—ãƒªã®è² è·å¯¾ç–ã€œã‚¢ãƒ—ãƒªã¨ã‚¤ãƒ³ãƒ•ãƒ©ã®èª¿å’Œã®ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã€œ (Klabã•ã‚“) http://www.slideshare.net/klab/4-d6963726f736f667420506f776572506f696e
k-holy 2012/11/22
database

architecture
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è² è·ãƒ†ã‚¹ãƒˆãƒ„ãƒ¼ãƒ«ã¾ã¨ã‚(5) - SH2ã®æ—¥è¨˜
ã¨ã„ã†ã‚ã‘ã§ã€JPOUG> SET EVENTS 20120721 | Japan Oracle User Groupã«å‚åŠ ã—ã¦ç™ºè¡¨ã‚’ã—ã¦ãã¾ã—ãŸã€‚é€šå¸¸ã®å‹‰å¼·ä¼šã¨æ¯”ã¹ã¦ç™ºè¡¨è€…ã¨è´è¬›è€…ã®ä¸€ä½“æ„Ÿã‚’å¢—ã™ãŸã‚ã®å·¥å¤«ãŒãªã•ã‚Œã¦ã„ã¦ã€ã¨ã¦ã‚‚è‰¯ã‹ã£ãŸã¨æ€ã„ã¾ã™ã€‚æœ‰é™ã‚³ãƒ¼ãƒ’ãƒ¼ã‹ã¨æ€ã£ãŸã‚‰ç„¡é™ãƒ“ãƒ¼ãƒ«ã ã£ãŸã®ã‚‚é©šãã§ã™ã€‚JPOUGã®é‹å–¶ãƒ¡ãƒ³ãƒã®ã¿ãªã•ã¾ã€ä¼šå ´ã‚’æä¾›ã—ã¦ãã ã•ã£ãŸæ—¥æœ¬ã‚ªãƒ©ã‚¯ãƒ«ã®ã¿ãªã•ã¾ã€å½“æ—¥ãŠè¶Šã—ã„ãŸã ã„ãŸã¿ãªã•ã¾ã€ã©ã†ã‚‚ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã—ãŸã€‚ ç§ã®ã‚»ãƒƒã‚·ãƒ§ãƒ³ã§ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è² è·ãƒ†ã‚¹ãƒˆãƒ„ãƒ¼ãƒ«ã¾ã¨ã‚(5)ã¨é¡Œã—ã¦éŽåŽ»4å›žåˆ†ã®ã¾ã¨ã‚ã¨è‡ªä½œãƒ„ãƒ¼ãƒ«ã®ç´¹ä»‹ã‚’ã•ã›ã¦ã„ãŸã ãã¾ã—ãŸã€‚JdbcRunnerã¯Oracle Databaseã€MySQLã¨PostgreSQLã®é–“ã§TPC-Bã¨TPC-Cã®æ€§èƒ½æ¯”è¼ƒãŒã§ãã‚‹å”¯ä¸€ã®ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã™ã®ã§ã€ã„ã‚ã„ã‚è©¦ã—ã¦ã¿ã¦ã„ãŸã ã‘ã‚Œã°ã¨æ€ã„ã¾ã™ã€‚è©¦ã—ãŸçµæžœ
k-holy 2012/07/27
database
ãƒªãƒ³ã‚¯
ã€Œè¤‡åˆã‚ãƒ¼ã€ã¨å®Ÿè£…ç”¨ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ - è¨è¨ˆè€…ã®ç™ºè¨€
ãƒ†ãƒ¼ãƒ–ãƒ«ã®ä¸»ã‚ãƒ¼ã®è¨å®šã«é–¢ã—ã¦ã€Œè¤‡åˆã‚ãƒ¼ã¨ä»£ç†ã‚ãƒ¼ã®ã©ã¡ã‚‰ãŒé©åˆ‡ã‹ã€ã¨ã„ã†è°è«–ãŒã‚ã‚‹ã€‚ç§ã®ç«‹å ´ã¯æ˜Žç¢ºã§ã€ åˆ†æžæ®µéšŽã§ã¯å¿…è¦ã«å¿œã˜ã¦è¤‡åˆã‚ãƒ¼ã‚’ç”¨ã„ãªãŒã‚‰ãƒ¢ãƒ‡ãƒªãƒ³ã‚°ã—ã€å®Ÿè£…æ®µéšŽã§ç’°å¢ƒã®äº‹æƒ…ã«å¿œã˜ã¦ä»£ç†ã‚ãƒ¼ã‚’å°Žå…¥ã™ã‚Œã°ã‚ˆã„ã€‚ã‚‚ã¡ã‚ã‚“ã€ãƒ¢ãƒ‡ãƒ«ã®ã¨ãŠã‚Šã«å®Ÿè£…ã™ã‚‹ã“ã¨ãŒè¨±ã•ã‚Œã‚‹ãªã‚‰ã°ã€ãã‚ŒãŒã„ã¡ã°ã‚“ã‚ˆã„ã€‚ ã¨ã„ã†ã‚‚ã®ã ã€‚æ ¹æ‹ ã‚’èª¬æ˜Žã—ã‚ˆã†ã€‚ ä»¥ä¸‹ã®ã‚ˆã†ãªãƒ‡ãƒ¼ã‚¿è¦ä»¶ãŒã‚ã‚‹ã¨ã™ã‚‹ã€‚è¨˜å·ã§ã¯ã‚¤ãƒ¡ãƒ¼ã‚¸ã—ã«ãã„ã¨ã„ã†èªè€…ã«ã¯ã€ãƒ†ãƒ¼ãƒ–ãƒ«ï¼¡ãŒã€Œç¤¾å“¡ã€ã§ã€ï¼£ãŒã€Œè¶£å‘³ã€ã§ã€ï¼¡ï¼£ãŒã€Œç¤¾å“¡ã®è¶£å‘³ã€ã¨æƒ³åƒã—ã¦ã‚‚ã‚‰ãˆã°ã‚ˆã„ã€‚ãã®å ´åˆã®å±žæ€§eã¯ã€å„ç¤¾å“¡ã®å„è¶£å‘³ã«å¯¾ã™ã‚‹ã€Œå¥½ã¿ã®åº¦åˆã„(-2ã¯å¤§å«Œã„ã€2ã¯å¤§å¥½ãã€ã¨ã‹)ã€ãã‚‰ã„ã¨è€ƒãˆã¦ã‚‚ã‚‰ãˆã°ã‚ˆã„ã€‚è¦ã¯ a,b,c,d,e ã®ï¼•ã¤ã®ç®¡ç†é …ç›®ãŒè¦‹å‡ºã•ã‚Œã€é …ç›®é–“ã« b=F(a)ã€d=F(c)ã€e=F(a,c) ã®é–¢æ•°å¾“å±žæ€§ãŒèªã‚ã‚‰ã‚ŒãŸã¨ã„ã†ä¾‹ã ã€‚ [ï¼¡] {a},ã€€ã€€b ï¼‹ã€€100 aaa
k-holy 2011/07/20
database

è¨è¨ˆ

æ¸¡è¾ºå¹¸ä¸‰
ãƒªãƒ³ã‚¯
DBè¨è¨ˆã¨ã‹ - wwolf.web.fc2.com
æ–‡æ›¸æƒ…å ± æ›´æ–°å±¥æ´ 2009.12.16 -- æ–°è¦ä½œè£½ 2010.06.27 -- ã‚¹ãƒˆã‚¢ãƒ‰ã«é–¢ã™ã‚‹ãƒ¡ãƒ¢æ›¸ãã‚’è¿½åŠ 2010.08.16 -- ã‚¹ã‚¿ã‚¤ãƒ«ä¿®æ£ 2010.10.14 -- æœ€çµ‚æ›´æ–° æœ¬ç¨¿ã®ç›®çš„ DBè¨è¨ˆã«é–¢ã™ã‚‹é›‘å¤šãªäº‹æŸ„ã‚’è¨˜éŒ²ã™ã‚‹ã€‚ç‰¹ã«æ–ã‚ŠãŒç„¡ã„å ´åˆMySQLãŒå¯¾è±¡ã§ã‚ã‚‹ã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«ã®è€ƒãˆæ–¹ ãƒªã‚½ãƒ¼ã‚¹ã¨ã‚¤ãƒ™ãƒ³ãƒˆ ä¸»ã‚ãƒ¼ã¨å¤–éƒ¨ã‚ãƒ¼ å¿…é ˆãªãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ ã‚ªãƒ—ã‚·ãƒ§ãƒŠãƒ«ãªãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã®æ¡æ•°ã¨ã‹ãƒ‡ãƒ¼ã‚¿åž‹ã«ã¤ã„ã¦ ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã®å½¹å‰²ã¨ã‹ ã‚ãƒ¼é …ç›® ãã‚Œä»¥å¤– å¤§é›‘æŠŠãªæŒ‡é‡ãªã©ã€‚ (1) ç‰¹ã«æ¡æ•°ã«ç¸›ã‚ŠãŒç„¡ã„é …ç›®ã§255æ–‡å—ä»¥ä¸‹ã«ç´ã¾ã‚‹ãƒ‡ãƒ¼ã‚¿ã¯ä¸€å¾‹varchar(255) (2) (1)ä»¥ä¸Šã®æ¡æ•°ãŒå…¥ã‚‹ãƒ‡ãƒ¼ã‚¿ã¯(text)åž‹ (3) (2)ã®æ¡ä»¶ã«ã‚ã¦ã¯ã¾ã‚‹ãŒã€æ¤œç´¢å¯¾è±¡ã¨ãªã‚‹é …ç›®ã¯ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®è€ƒæ…®ãŒå¿…è¦ãªã®ã§åˆ¥é€”è€ƒãˆã‚‹ (4) ä¸»ã‚ãƒ¼ã¯AutoIncrimentã®INT(UNSIG
k-holy 2011/06/23
database

architecture

MySQL
ãƒªãƒ³ã‚¯
Comparison of different SQL implementations
The goal of this page was to gather information relevant for people who are porting SQL from one product to another and/or are interested in possibilities and limits of 'cross-product' SQL. The following tables compare how different DBMS products handled various SQL (and related) features. If possible, the tables also stated how the implementations should do things, according to the SQL standard.
k-holy 2011/05/06
sql

database
ãƒªãƒ³ã‚¯
SQLã§æœ¨ã¨éšŽå±¤æ§‹é€ ã®ãƒ‡ãƒ¼ã‚¿ã‚’æ‰±ã†â€•â€•å…¥ã‚Œåé›†åˆãƒ¢ãƒ‡ãƒ«
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
k-holy 2009/06/25
database
ãƒªãƒ³ã‚¯
MySQL Workbench
Thank you very much for the great reactions and contributions we received since we put our first alpha build out last week. We have incorporated patches submitted by the community and further improved some code (even though we're currently busy sitting together at our Database Group Developer Meeting). So we've prepared the next packages and put them on our server. We also updated (cleaned up) the
k-holy 2008/04/04
database

tool

mysql
ãƒªãƒ³ã‚¯
http://www.azzurri.co.jp/clay/
k-holy 2008/04/04
database

tool
ãƒªãƒ³ã‚¯
1