[B! database] Cherenkovã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

Cherenkov id:Cherenkov

databaseã«é–¢ã™ã‚‹Cherenkovã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (21)

${{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æžšãšã¤è¦‹ãªã‘ã‚Œã°åˆ†ã‹ã‚‰ãªã‹ã£ãŸãã‚“ãªæƒ…å ±ã‚’ç°¡å˜ã«æ¤œç´¢ã§ãã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒ4æœˆã€ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆä¸Šã§å…¬é–‹ã•ã‚ŒãŸã€‚ä½œæˆã—ãŸã®ã¯æ”¿åºœã‚„å›½ä¼šã§ã¯ãªãã€1äººã®æ°‘é–“äººã€‚è‡ªæ°‘å…šã®æ´¾é–¥ã‚„æ±äº¬éƒ½è°ä¼šã®è£é‡‘äº‹ä»¶ãªã©ã€Œæ”¿æ²»ã¨ã‚«ãƒã€ã®å•é¡ŒãŒå¾Œã‚’çµ¶ãŸãšã€ä¼æ¥ãƒ»å›£ä½“çŒ®é‡‘ã®åœ¨ã‚Šæ–¹ã‚’å·¡ã‚‹è°è«–ãŒä»Šã‚‚ç¶šãä¸ã€è‹¦åŠ´ã—ã¦ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ã¤ãã‚Šä¸Šã’ãŸãã®æ€ã„ã¯ã€‚ï¼ˆäº•ä¸Šå³»è¼”ï¼‰
Cherenkov 2025/05/11
database

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

db

database

programming

èªã¿ç‰©

sql
ãƒªãƒ³ã‚¯
Game UI Database
Visualizers Default Greyscale Filter Protanopia Filter Deuteranopia Filter Tritanopia Filter Inversion Scanline/CRT ?????????
Cherenkov 2020/12/11
game

database

ui

gallery

development

idea
ãƒªãƒ³ã‚¯
GitHubãŒéšœå®³ã‚’ç·æ‹¬ã€43ç§’é–“ã®ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯æ–ãŒ1æ—¥ã®ã‚µãƒ¼ãƒ“ã‚¹éšœå®³ã«ã¤ãªãŒã£ãŸï¼šãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸æ•´åˆè§£æ¶ˆã«æ™‚é–“ - ï¼ IT
GitHubãŒéšœå®³ã‚’ç·æ‹¬ã€43ç§’é–“ã®ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯æ–ãŒ1æ—¥ã®ã‚µãƒ¼ãƒ“ã‚¹éšœå®³ã«ã¤ãªãŒã£ãŸï¼šãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸æ•´åˆè§£æ¶ˆã«æ™‚é–“ GitHubã¯2018å¹´10æœˆ30æ—¥ï¼ˆç±³å›½æ™‚é–“ï¼‰ã€2018å¹´10æœˆ21æ—¥16æ™‚é ƒï¼ˆç±³å›½å¤ªå¹³æ´‹æ™‚ï¼‰ã‹ã‚‰ç´„24æ™‚é–“ã«ã‚ãŸã£ã¦ç™ºç”Ÿã—ãŸéšœå®³ã«é–¢ã™ã‚‹åˆ†æžå ±å‘Šã‚’ã€åŒç¤¾ã®ãƒ–ãƒã‚°ã«æŽ²è¼‰ã—ãŸã€‚ã“ã‚Œã«ã‚ˆã‚‹ã¨ã€ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯æ©Ÿå™¨ã®éƒ¨å“äº¤æ›ã§ç”Ÿã˜ãŸ43ç§’ã®ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯æŽ¥ç¶šæ–ãŒã€GitHubã®ãƒ¡ã‚¿ãƒ‡ãƒ¼ã‚¿ç®¡ç†ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸æ•´åˆã‚’å¼•ãèµ·ã“ã—ã€å¾©æ—§ã«æ™‚é–“ã‚’è¦ã—ãŸã¨ã„ã†ã€‚ GitHubã¯2018å¹´10æœˆ30æ—¥ï¼ˆç±³å›½æ™‚é–“ï¼‰ã€2018å¹´10æœˆ21æ—¥16æ™‚é ƒï¼ˆç±³å›½å¤ªå¹³æ´‹æ™‚ï¼‰ã‹ã‚‰ç´„24æ™‚é–“ã«ã‚ãŸã£ã¦ç™ºç”Ÿã—ãŸéšœå®³ã«é–¢ã™ã‚‹åˆ†æžå ±å‘Šã‚’ã€åŒç¤¾ã®ãƒ–ãƒã‚°ã«æŽ²è¼‰ã—ãŸã€‚ã“ã‚Œã«ã‚ˆã‚‹ã¨ã€ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯æ©Ÿå™¨ã®éƒ¨å“äº¤æ›ã§ç”Ÿã˜ãŸ43ç§’ã®ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯æŽ¥ç¶šæ–ãŒã€GitHubã®ãƒ¡ã‚¿ãƒ‡ãƒ¼ã‚¿ã‚’ç®¡ç†ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸æ•´åˆã‚’å¼•ãèµ·ã“ã—ã€å¾©æ—§ã«æ™‚é–“ã‚’è¦ã—ãŸ
Cherenkov 2018/11/01
github

database

éšœå®³äº‹ä¾‹

db

network
ãƒªãƒ³ã‚¯
Sequel Pro
Full MySQL Support Sequel Pro is a fast, easy-to-use Mac database management application for working with MySQL databases. Perfect Web Development Companion Whether you are a Mac Web Developer, Programmer or Software Developer your workflow will be streamlined with a native Mac OS X Application! Flexible Connectivity Sequel Pro gives you direct access to your MySQL Databases on local and remote se
Cherenkov 2018/04/26
â€œSequel Proâ€

db

database

software

MySQL

tool
ãƒªãƒ³ã‚¯
RDBã¨NoSQLã«ã¿ã‚‹DBè¿‘ç¾ä»£å² ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ç ´å£Šçš„ã‚¤ãƒŽãƒ™ãƒ¼ã‚·ãƒ§ãƒ³ã¯äºŒåº¦èµ·ãã‚‹ã‹ï¼Ÿ - ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢Hubï½œè‹¥æ‰‹Webã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ã‚ãƒ£ãƒªã‚¢ã‚’è€ƒãˆã‚‹ï¼
ã€Œãƒ¦ãƒ¼ã‚¶ãƒ¼ç›®ç·šã€ã®ã‚·ã‚¹ãƒ†ãƒ ã‚’ç›®æŒ‡ã—ã¦ RDBãŒå¾“æ¥ã®éšŽå±¤åž‹DBã«æ¯”ã¹ã¦å„ªã‚Œã¦ã„ãŸç‚¹ã¯ã„ãã¤ã‹æŒ™ã’ã‚‹ã“ã¨ãŒã§ãã¾ã™ãŒã€ã‚·ã‚§ã‚¢ã‚’ä¼¸ã°ã™ã†ãˆã§æœ€ã‚‚å¤§ããªå½±éŸ¿ã¯ã€ãƒ¦ãƒ¼ã‚¶ãƒ¼ãŒä½¿ã„ã‚„ã™ã„ãƒ‡ãƒ¼ã‚¿æ§‹é€ ã¨ã‚¤ãƒ³ã‚¿ãƒ•ã‚§ãƒ¼ã‚¹ã«ã“ã ã‚ã£ãŸã“ã¨ã§ã™ã€‚ã™ãªã‚ã¡ã€ã€Œãƒ†ãƒ¼ãƒ–ãƒ«ã€ã¨ã€ŒSQLã€ã®ç™ºæ˜Žã§ã™ã€‚ RDBã§ã¯ã€ã™ã¹ã¦ã®ãƒ‡ãƒ¼ã‚¿ã‚’ã€Œãƒ†ãƒ¼ãƒ–ãƒ«ã€ã¨ã„ã†ãŸã ä¸€ã¤ã®ãƒ‡ãƒ¼ã‚¿å½¢å¼ã«ã‚ˆã£ã¦è¡¨ç¾ã—ã¾ã™ã€‚ãƒ†ãƒ¼ãƒ–ãƒ«ã¯ã€è¦‹ãŸç›®ãŒã€ŒäºŒæ¬¡å…ƒè¡¨ã€ã«ä¼¼ã¦ã„ã‚‹ãŸã‚*3ã€Microsoft Excelã‚„Google ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆãªã©ã®ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã‚’ä½¿ã„æ…£ã‚ŒãŸäººãŒè¦‹ã‚‹ã¨ã€ãƒ‡ãƒ¼ã‚¿ã‚’æ ¼ç´ã™ã‚‹æ–¹æ³•ãŒç›´è¦³çš„ã«ã‚¤ãƒ¡ãƒ¼ã‚¸ã—ã‚„ã™ã„ã¨ã„ã†åˆ©ç‚¹ãŒã‚ã‚Šã¾ã™ã€‚å®Ÿéš›ã€ã“ã†ã—ãŸäºŒæ¬¡å…ƒè¡¨ã«ã‚ˆã‚‹ãƒ‡ãƒ¼ã‚¿ç®¡ç†ã¯ã€Excelãªã©ã®ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ãŒç™»å ´ã™ã‚‹å‰ã‹ã‚‰ä¸€èˆ¬çš„ãªæ–¹æ³•ã ã£ãŸãŸã‚ã€RDBãŒç™»å ´ã—ãŸå½“æ™‚ã®äººã€…ã«ã¨ã£ã¦ã‚‚å—ã‘å…¥ã‚Œã‚„ã™ã„ã‚‚ã®ã§ã—ãŸã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«ãŒç”»æœŸçš„ã ã£ãŸç‚¹ã¯ã€ã‚‚ã†ä¸€ã¤ã‚ã‚Šã¾ã™ã€‚
Cherenkov 2017/11/28
Ingresåˆã‚ã¦èžã„ãŸ

db

history

database
ãƒªãƒ³ã‚¯
MySQLã‚’å‰²ã¨ä¸€äººã§300å°ç®¡ç†ã™ã‚‹æŠ€è¡“
2017/09/05 db tech showcase Tokyo 2017 http://www.db-tech-showcase.com/dbts/tokyo
Cherenkov 2017/09/06
db

é‹ç”¨

mysql

database
ãƒªãƒ³ã‚¯
GitLab.comãŒæ“ä½œãƒŸã‚¹ã§æœ¬ç•ªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å–ªå¤±ã€‚5ã¤ã‚ã£ãŸã¯ãšã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—æ‰‹æ®µã¯å½¹ç«‹ãŸãšã€é ¼ã¿ã®ç¶±ã¯6æ™‚é–“å‰ã«å¶ç„¶å–ã£ãŸã‚¹ãƒŠãƒƒãƒ—ã‚·ãƒ§ãƒƒãƒˆ ï¼ Publickey
æžœãŸã—ã¦GitLab.comã§ä½•ãŒèµ·ããŸã®ã§ã—ã‚‡ã†ã‹ï¼Ÿ ã“ã‚Œã¾ã§ã®çµŒç·¯ã‚’ã¾ã¨ã‚ã¾ã—ãŸã€‚ ã‚¹ãƒ‘ãƒ ã«ã‚ˆã‚‹ãƒˆãƒ©ãƒ•ã‚£ãƒƒã‚¯ã®ã‚¹ãƒ‘ã‚¤ã‚¯ã‹ã‚‰ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ä¸èª¿ã¸ GitLab.comã¯ä»Šå›žã®ã‚¤ãƒ³ã‚·ãƒ‡ãƒ³ãƒˆã«ã¤ã„ã¦ã®è©³ç´°ãªçµŒéŽã‚’ã€ŒGitLab.com Database Incident - 2017/01/31ã€ã§å…¬é–‹ã—ã¦ã„ã¾ã™ã€‚ã¾ãŸã€ã‚‚ã†å°‘ã—æ•´ç†ã•ã‚ŒãŸæƒ…å ±ãŒãƒ–ãƒã‚°ã€ŒGitLab.com Database Incident | GitLabã€ã«ã‚‚æŽ²è¼‰ã•ã‚Œã¦ã„ã¾ã™ã€‚ ã“ã‚Œã‚‰ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚’è»¸ã«ã€ä¸»ãªã§ãã”ã¨ã‚’æ™‚ç³»åˆ—ã«è¦‹ã¦ã„ãã¾ã—ã‚‡ã†ã€‚ 1æœˆ31æ—¥16æ™‚ï¼ˆä¸–ç•Œå”å®šæ™‚ã€‚æ—¥æœ¬æ™‚é–“2æœˆ1æ—¥åˆå‰8æ™‚ï¼‰ã€YPæ°ï¼ˆYorick Peterseæ°ã¨æ€ã‚ã‚Œã‚‹ï¼‰ã¯PostgreSQLã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’è¨å®šã™ã‚‹ãŸã‚ã«ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã®è«–ç†ã‚¹ãƒŠãƒƒãƒ—ã‚·ãƒ§ãƒƒãƒˆã‚’ä½œæˆã€‚ã“ã‚ŒãŒã‚ã¨ã§å¤±ã‚ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ã‚’æ•‘ã†å¹¸é‹ã«ã¤ãªãŒã‚Šã¾ã™ã€‚ 1æœˆ31æ—¥21æ™‚
Cherenkov 2017/02/02
database

gitlab

DB

PostgreSQL

å¤±æ•—å¦
ãƒªãƒ³ã‚¯
SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã‚´ãƒ«ãƒ• - ãªã‚“ã¨3æ–‡å—ã§èªè¨¼å›žé¿ãŒå¯èƒ½ã«
æ˜¨æ—¥ã®ã‚¨ãƒ³ãƒˆãƒªã€ŒSQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã‚´ãƒ«ãƒ• - èªè¨¼å›žé¿ã®æ”»æ’ƒæ–‡å—åˆ—ã¯ã©ã“ã¾ã§çŸãã§ãã‚‹ã‹?ã€ã«ã¦ã€èªè¨¼å›žé¿ã®æ”»æ’ƒæ–‡å—åˆ—ãŒ5æ–‡å—ã«ã§ãã‚‹ï¼ˆã€Œ'OR'1ã€ï¼‰ã“ã¨ã‚’ç¤ºã—ã¾ã—ãŸãŒã€@masa141421356ã•ã‚“ã¨ã€ã‚„ã¾ã–ãã•ã‚“ï¼ˆãŠäºŒäººã¨ã‚‚æ‹™è‘—ã®ãƒ¬ãƒ“ãƒ¥ã‚¢ãƒ¼ã§ã™ï¼‰ã‹ã‚‰ã€idã¨pwdã«ã¾ãŸãŒã£ãŸæ”»æ’ƒä¾‹ã‚’ç¤ºã—ã¦ã„ãŸã ãã¾ã—ãŸã€‚ã‚„ã¾ã–ãã•ã‚“ã®ä¾‹ã¯ã€MySQLé™å®šãªãŒã‚‰ã€ãªã‚“ã¨3æ–‡å—ã§ã™ã€‚ã“ã‚Œã¯ã™ã”ã„ã€‚ @masa141421356ã•ã‚“ã®æ”»æ’ƒä¾‹ @masa141421356ã•ã‚“ã®ãƒ„ã‚¤ãƒ¼ãƒˆã‚’å¼•ç”¨ã—ã¾ã™ã€‚ @ockeghem å¤§æŠµã®DBã§id=''OR' AND pwd='>' ' ãŒé€šã‚‹ã¨æ€ã„ã¾ã™ï¼ˆidå´ã«ã€Œ'ORã€, pwdå´ã«ã€Œ>' ã€ã§6æ–‡å—ï¼‰ã€‚é•·ã•0ã®æ–‡å—åˆ—ãŒNULLæ‰±ã„ã•ã‚Œãªã„DBãªã‚‰æœ€å¾Œã®ã‚¹ãƒšãƒ¼ã‚¹ã‚’æ¶ˆã—ã¦5æ–‡å—ã§ã™ã€‚ â€” masa141421356 (@masa141421356) June
Cherenkov 2013/06/25
mysql

db

database

security

sql

codegolf

golf
ãƒªãƒ³ã‚¯
æ›¸è©•ï¼šã€Œ7ã¤ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ 7ã¤ã®ä¸–ç•Œã€
è¨³è€…ã€è§’ å¾å…¸æ°ã‚ˆã‚ŠçŒ®æœ¬å¾¡ç¤¼ã€‚ã€Œ7ã¤ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ 7ã¤ã®ä¸–ç•Œã€ã¯ãã®ã‚¿ã‚¤ãƒˆãƒ«ã®é€šã‚Šã€7ç¨®é¡žã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã«ã¤ã„ã¦è§£èª¬ã—ãŸNoSQLã®é“æ¨™ã¨ã‚‚è¨€ã†ã¹ãæ›¸ç±ã§ã‚ã‚‹ã€‚7ç¨®é¡žã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦ç´¹ä»‹ã•ã‚Œã¦ã„ã‚‹ã®ã¯ã€PostgreSQLã€Riakã€HBaseã€Mongo DBã€CouchDBã€Neo4jã€Redisã§ã‚ã‚‹ã€‚æœ¬æ›¸ã¯éžå¸¸ã«ããã‚‹ã‚¿ã‚¤ãƒˆãƒ«ã§ã‚ã‚Šã€ã‚ãã‚ãã—ãªãŒã‚‰ãƒšãƒ¼ã‚¸ã‚’ã‚ãã£ãŸã€‚ã ãŒã€ç¬¬2ç« ã€ŒPostgreSQLã€ã§æœŸå¾…æ„Ÿã¯æ‰“ã¡ç •ã‹ã‚Œã‚‹ã“ã¨ã«ãªã‚‹ã€‚ æ£ç›´ãªã¨ã“ã‚ã€ã“ã®æ›¸ç±ã«ã¤ã„ã¦æ›¸è©•ã‚’æ›¸ãã®ã¯ã©ã†ã—ã‚ˆã†ã‹è¿·ã£ã¦ã—ã¾ã£ãŸã€‚ãªãœãªã‚‰ã°ã€ç¬¬2ç« ã®èª¬æ˜ŽãŒã‹ãªã‚Šé–“é•ã£ã¦ã„ã‚‹ã‹ã‚‰ã§ã‚ã‚‹ã€‚ãã®ãŸã‚ã€æ›¸è©•ã‚’æ›¸ã“ã†ã¨ã™ã‚‹ã¨ã©ã†ã—ã¦ã‚‚è¾›å£ã«ãªã‚‰ã–ã‚‹ã‚’å¾—ãªã‹ã£ãŸã€‚çŒ®æœ¬ã—ã¦é ‚ã„ãŸè§’æ°ã«ãã®æ—¨ã‚’ä¼ãˆãŸã¨ã“ã‚ã€ãã‚Œã§ã‚‚è‰¯ã„ã¨å¿«ãäº†æ‰¿ã—ã¦é ‚ã„ãŸã€‚æœ¬å½“ã«è¾›å£ã«ãªã‚‹ã®ã§ãã®ç‚¹ã¯å®¹èµ¦ã—ã¦é ‚ããŸã„ã€‚ ä½•ãŒå•é¡Œãªã®ã‹
Cherenkov 2013/04/03
database

postgresql

review

book
ãƒªãƒ³ã‚¯
http://labs.cybozu.co.jp/blog/kazuho/archives/2008/06/friends_timeline.php
Cherenkov 2012/07/13
mysql

algorithm

database

Twitter

Performance
ãƒªãƒ³ã‚¯
SQL Fiddle - Online SQL Compiler for learning & practice
During Phase 1, only users who are logged in can access the AI chat feature. SQL Fiddle is free to use and ad-free! Want to help us? It takes 10 seconds Step 1: Like & Share our EFE Bulk Extensions videos Step 2: Like & Share our EFE Bulk Insert videos Thank During Phase 1, only users who are logged in can access the AI Editor feature. SQL Fiddle is free to use and ad-free! Want to help us? It tak
Cherenkov 2012/05/02
SQLç¢ºèª

database

mysql

SQL

generator

webservice

tool

jsFiddle
ãƒªãƒ³ã‚¯
ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŠ€è¡“ï¼»å®Ÿè·µï¼½å…¥é–€ã€ã¯ã€Œã‚µãƒ¼ãƒã‚¤ãƒ³ãƒ•ãƒ©æœ¬ã€ã€Œå¾³ä¸¸æœ¬ã€ã¨ä¸¦ã¶ã‚¦ã‚§ãƒ–ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢å¿…æºã®æ•™ç§‘æ›¸ - As a Futurist...
æŠ€è¡“è©•è«–ç¤¾æ§˜ã‹ã‚‰çŒ®æœ¬ã—ã¦é ‚ãã¾ã—ãŸï¼ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ï¼ï¼æ—¥æœ¬ã‚’ä»£è¡¨ã™ã‚‹ DataBase Administrator(DBA)ã§ã‚ã‚‹æ¾ä¿¡ã•ã‚“ã®æ–°è‘—ã¨ã„ã†ã“ã¨ã§ã€ã‚ãˆã¦åƒ•ã®æ§˜ãªäººé–“ãŒä½•ã‚’ã›ãšã¨ã‚‚ã™ã°ã‚‰ã—ã„æœ¬ã§ã‚ã‚‹ã“ã¨ã¯è‡ªæ˜Žã§ã™ãŒã€çŒ®æœ¬é ‚ã„ãŸã‹ã‚‰ã«ã¯ä½•ã‹æ›¸ã‹ãã°ï¼ Open database life: æ–°è‘—ã€ŒWeb ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ãŸã‚ã® ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŠ€è¡“[å®Ÿè·µ]å…¥é–€ã€ ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒãªã„ã¨ä½•ãŒå›°ã‚‹ã®ã‹ã€ ã“ã‚ŒãŒç¬¬ 1 ç« ã®ã‚¿ã‚¤ãƒˆãƒ«ã§ã™ã€‚ã‚ãã€å…¥ç¤¾å‰ã®è‡ªåˆ†ã«è¨€ã„èžã‹ã›ã¦ã‚„ã‚ŠãŸã„ã€‚åƒ•ã¯ãƒ—ãƒã‚°ãƒ©ãƒ ã‚’è§¦ã‚Šå§‹ã‚ãŸã“ã‚ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’è§¦ã‚ŠãŸããªã„ã¨ã„ã†ç†ç”±ã ã‘ã§ã‚¦ã‚§ãƒ–ã‚¢ãƒ—ãƒªã‚’ä½œã‚‹ã“ã¨ã‚’è«¦ã‚ã€plagger ã‚’ä½¿ã£ã¦è‡ªåˆ†ã§ã¯ãƒ‡ãƒ¼ã‚¿ã‚’ç›´æŽ¥ä¿å˜ã—ãªã„ã“ã¨ã°ã£ã‹ã‚Šã‚„ã£ã¦ã¾ã—ãŸã€‚çµæžœã€SELECTæ–‡ã™ã‚‰æ›¸ã‘ãªã„çŠ¶æ…‹ã§ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ç”Ÿæ´»ã‚’ã‚¹ã‚¿ãƒ¼ãƒˆã—ãŸã‚ã‘ã§ã™ã€‚ ã§ã€å®Ÿéš›ã‚¦ã‚§ãƒ–ã‚¢ãƒ—ãƒªã®ç¾å ´ã‚’ 3 å¹´ã‚„ã£ã¦ãã¦ã€ãƒ‡ãƒ¼ã‚¿
Cherenkov 2012/03/08
ã†ã‚“ã†ã‚“ã€ŒSELECTæ–‡ã™ã‚‰æ›¸ã‘ãªã„çŠ¶æ…‹ã§ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ç”Ÿæ´»ã‚’ã‚¹ã‚¿ãƒ¼ãƒˆã€

database

book

db

mysql
ãƒªãƒ³ã‚¯
11/12/28 ã€é‡è¦ã€‘è¨¼åˆ¸ã‚·ã‚¹ãƒ†ãƒ éšœå®³ã«é–¢ã™ã‚‹é‡è¦ãªãŠçŸ¥ã‚‰ã› ï½œ è¨¼åˆ¸ä¼šç¤¾ãªã‚‰æ¥ç•Œæœ€å®‰å€¤æ°´æº–ã®æ‰‹æ•°æ–™ã§äººæ°—ã®æ ªå¼ä¼šç¤¾ãƒ©ã‚¤ãƒ–ã‚¹ã‚¿ãƒ¼è¨¼åˆ¸
ãƒ©ã‚¤ãƒ–ã‚¹ã‚¿ãƒ¼è¨¼åˆ¸ã¯2021å¹´1æœˆ1æ—¥ã‚’ã‚‚ã£ã¦ã€SBIãƒã‚ªãƒˆãƒ¬ãƒ¼ãƒ‰è¨¼åˆ¸ã¸ã¨å•†å·ã‚’å¤‰æ›´ã„ãŸã—ã¾ã—ãŸã€‚ ä»¥ä¸‹ã®æ—§ãƒ©ã‚¤ãƒ–ã‚¹ã‚¿ãƒ¼è¨¼åˆ¸ãƒ‰ãƒ¡ã‚¤ãƒ³ã¯å»ƒæ¢ã•ã‚Œã¦ãŠã‚Šã¾ã™ã®ã§ã€ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ç‰ã«ã”ç™»éŒ²ã•ã‚Œã¦ã„ã‚‹ãŠå®¢æ§˜ã«ãŠã‹ã‚Œã¾ã—ã¦ã¯ã€æ–°ãƒ‰ãƒ¡ã‚¤ãƒ³ã¸ã”å¤‰æ›´ã‚’ã„ãŸã ãã¾ã™ã‚ˆã†ãŠé¡˜ã„ç”³ã—ä¸Šã’ã¾ã™ã€‚ ã€æ—§ãƒ‰ãƒ¡ã‚¤ãƒ³ã€‘https://www.live-sec.co.jp
Cherenkov 2011/12/28
ã€Œå¤–éƒ¨å§”è¨—æ¥è€…ã«ãŠã‘ã‚‹ä½œæ¥ã«ãŠã„ã¦ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒä¸Šã®å…¨ã¦ã®ãƒ‡ãƒ¼ã‚¿ã‚’äººç‚ºçš„ã«å‰Šé™¤ ãŠå®¢æ§˜ã®æ³¨æ–‡å†…å®¹ã€æ®‹é«˜æƒ…å ±ç‰å£²è²·ã‚’è¡Œã†ãŸã‚ã®åŸºç¤Žãƒ‡ãƒ¼ã‚¿ã‚’æ¶ˆå¤±ã—ã€æ³¨æ–‡ã®å—ç™ºæ³¨å…¨ã¦ã‚’è¡Œã†ã“ã¨ãŒã§ããªããªã‚Šã¾ã—ãŸã€

database

DB

ã‚·ã‚¹ãƒ†ãƒ éšœå®³

éšœå®³äº‹ä¾‹

business

trouble

æ³£ã„ã¡ã‚ƒã†

ã“ã‚Œã¯ã²ã©ã„
ãƒªãƒ³ã‚¯
MySQL5.5.3-m3ã®DATETIMEåž‹ã®ãƒã‚°ã€‚ã‚ã¨MySQLã® DATETIMEåž‹ã¯æœ¬å½“ã«é…ã„ã®ã‹æ¤œè¨¼ã—ã¦ã¿ãŸ - 2010-04-30 - å°é‡Žãƒžãƒˆãƒšã®æ¥å‹™æ—¥èªŒ(ã‚¢ãƒ‹ãƒ¡åˆ¶ä½œã—ã¦ãªã„ç¯‡)
ãƒã‚°ã®è©± è¿‘ã€…ãµãã¼ã£ãŸãƒ¼DBã®InnoDBåŒ–ã‚’ä¼ã¦ã¦ã„ã‚‹ã®ã§ã€ãã‚Œã«ä¼´ã„MySQL5.0.67(Tritonn)ã‹ã‚‰ã€å…ˆæ—¥ãƒªãƒªãƒ¼ã‚¹ã•ã‚ŒãŸã°ã‹ã‚Šã®MySQL5.5.3-m3ã«ä¹—ã‚Šæ›ãˆã¦ã¿ãŸã€‚RC(ãƒªãƒªãƒ¼ã‚¹å€™è£œ)ç‰ˆã¨ã„ã†ã“ã¨ã§ã€GAç‰ˆã¨ã»ã¼å¤‰ã‚ã‚‰ãªã„å“è³ªã¨èžã„ãŸã®ã§ã€å‰²ã¨è»½ã„æ°—æŒã¡ã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸã‚“ã ã‘ã©ã€ã„ããªã‚Šãƒã‚°ã«ãƒãƒžã£ãŸã€‚ ãƒã‚°ã¨ã¯ã€DATETIME, TIMESTAMP, DATE, TIMEåž‹ã¨æ–‡å—åˆ—å®šæ•°ã¨ã®çµåˆã§ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒä½¿ã‚ã‚Œãªã„ã€ã¨ã„ã†ã‚‚ã®ã€‚ ä»¥ä¸‹ã®ã‚ˆã†ãªã€date(DATEåž‹)ã®çµåˆã—ã‹ã—ã¦ã„ãªã„ã‚¯ã‚¨ãƒªã§ã‚‚ã€dateã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒä½¿ã‚ã‚Œãšæ˜‡é †ãƒ•ãƒ«ãƒ†ãƒ¼ãƒ–ãƒ«ã‚¹ã‚ãƒ£ãƒ³ã•ã‚Œã€20ç§’ãã‚‰ã„æŽ›ã‹ã£ãŸã€‚ select date from STATUS force index(date) where date='2010-01-19' limit 10; ã“ã®ç¾è±¡ã¯ã€5.5.3,5
Cherenkov 2011/04/30
DATETIME TIMESTAMP

mysql

database

Performance

Benchmark
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œæˆã™ã‚‹ :: ãƒ¢ãƒ‡ãƒ« :: CakePHPã«ã‚ˆã‚‹é–‹ç™º :: ãƒžãƒ‹ãƒ¥ã‚¢ãƒ« :: 1.3ã‚³ãƒ¬ã‚¯ã‚·ãƒ§ãƒ³
Cherenkov 2011/04/28
DB model table åž‹ ä¸€è¦§ ã¾ã¨ã‚

cakephp

database

MySQL
ãƒªãƒ³ã‚¯
ã€CakePHPã€‘ãŠæ‰‹è»½ä¾¿åˆ©ãªCakeSchema | ECWorks Blog
DBã®ãƒ†ãƒ¼ãƒ–ãƒ«è¨å®šã¯éžå¸¸ã«é¢å€’ãªä½œæ¥ã®ä¸€ã¤ã§ã™ã€‚ ç‰¹ã«ã€é–‹ç™ºæ™‚ã¯ä»•æ§˜å¤‰æ›´ãªã©ã§ãƒ†ãƒ¼ãƒ–ãƒ«å†…ã®ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ãŒé »ç¹ã«å¢—æ¸›ã™ã‚‹ã“ã¨ã‚‚ã‚ã‚‹ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œæˆã—ãŸã‚Šã€æ›´æ–°ã—ãŸã‚Šã™ã‚‹ã®ã«ã€çš†ã•ã‚“ã¯ã©ã®ã‚ˆã†ãªæ‰‹é †ã‚’è¸ã¾ã‚Œã‚‹ã§ã—ã‚‡ã†ã‹ï¼Ÿã¾ãšSQLã‚’æ›¸ã„ã¦ã€ã‚¢ãƒƒãƒ—ãƒãƒ¼ãƒ‰ã—ã¦ã€mysqlã‚„psqlã®ã‚³ãƒ³ã‚½ãƒ¼ãƒ«ã‚’ä½¿ã£ã¦å®Ÿè¡Œã—ã¦ã„ã¾ã™ã§ã—ã‚‡ã†ã‹ï¼Ÿãã‚Œã¨ã‚‚ã€mysqladminã¨ã‹ã®guiãƒ„ãƒ¼ãƒ«ã‚’ä½¿ã£ã¦ã„ã¾ã™ã§ã—ã‚‡ã†ã‹ï¼Ÿ CakePHPã«ã¯ã€schemaã‚·ã‚§ãƒ«ãŒä»˜å±žã•ã‚Œã¦ã„ã¦ã€ã“ã‚Œã‚’ç”¨ã„ã‚‹ã“ã¨ã§ç°¡å˜ã«ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’åˆæœŸåŒ–ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ã‹ã‚‰ã‚³ãƒžãƒ³ãƒ‰ä¸€ç™ºã§(å®Ÿéš›ã«ã¯ç¢ºèªãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ãŒã‚ã‚‹ã®ã§y/né¸æŠžãŒã‚ã‚Šã¾ã™ãŒ)ã€æ›¸ãæ›ã‚ã‚‹ã®ã§å¤§å¤‰ã«ä¾¿åˆ©ã§ã™ã€‚ ãŸã ã€ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚„æƒ…å ±ãŒå…¬é–‹ã•ã‚Œã¦ã„ã‚‹ãƒ–ãƒã‚°ãªã©ãŒå°‘ãªã„ãŸã‚ã€ã©ã®ã‚ˆã†ã«è¨˜è¿°ã—ã¦è‰¯ã„ã‹åˆ†ã‹ã‚‰ãªã„æ–¹ã‚‚å¤šã„ã‹ã¨æ€ã„ã¾ã™ã€‚ãã“ã§ã€ç°¡å˜ã«ä½¿ã„æ–¹ã‚’è§£èª¬ã—ã€
Cherenkov 2011/04/22
migration

cakephp

schema

tutorial

database

DB
ãƒªãƒ³ã‚¯
Google Spreadsheets ã‚’ç°¡æ˜“ SQL DB ã«ï¼ã€ŒGoogle Visualization APIã€ - WebOS Goodies
WebOS Goodies ã¸ã‚ˆã†ã“ãï¼ WebOS ã¯ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆã®æœªæ¥å½¢ã€‚ã‚ã‚‰ã‚†ã‚‹ Web ã‚µã‚¤ãƒˆãŒç¹‹ãŒã‚Šã€å…±æœ‰ã—ã€å”åŠ›ã—ã¦å‰µã‚Šä¸Šã’ã‚‹ã€ã²ã¨ã¤ã®å·¨å¤§ãªæƒ…å ±ã‚·ã‚¹ãƒ†ãƒ ã§ã™ã€‚ãã“ã§ã¯ã€ã‚ã‚‰ã‚†ã‚‹æƒ…å ±ãŒãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ä¸Šã«è“„ç©ã•ã‚Œã€æˆ‘ã€…ã¯ã„ã¤ã§ã‚‚ã€ã©ã“ã‹ã‚‰ã§ã‚‚ã€å¤šå½©ãªãƒ‡ãƒã‚¤ã‚¹ã‚’ä½¿ã£ã¦ãã‚Œã‚‰ã«ã‚¢ã‚¯ã‚»ã‚¹ã§ãã¾ã™ã€‚ WebOS Goodies ã¯ã€ã•ã¾ã–ã¾ãªæƒ…å ±æä¾›ã‚„ãƒ„ãƒ¼ãƒ«é–‹ç™ºã‚’é€šã—ã¦ã€ãã‚“ãªä¸–ç•Œã®å®Ÿç¾ã«å°‘ã—ã§ã‚‚è²¢çŒ®ã™ã‚‹ã¹ãæ´»å‹•ã—ã¦ã„ãã¾ã™ã€‚ çš†ã•ã‚“ã€ Google Docs ã®ã‚¬ã‚¸ã‚§ãƒƒãƒˆæ©Ÿèƒ½ã¯ã‚‚ã†ä½¿ã£ã¦ã¿ã¾ã—ãŸã§ã—ã‚‡ã†ã‹ã€‚ãƒ‡ãƒ¼ã‚¿ã‚’ã•ã¾ã–ã¾ãªæ–¹æ³•ã§å¯è¦–åŒ–ã™ã‚‹ã‚¬ã‚¸ã‚§ãƒƒãƒˆã‚’ã‚·ãƒ¼ãƒˆä¸Šã«é…ç½®ã§ãã‚‹ã¨ã„ã†ã‚‚ã®ã§ã€ã“ã®ã‚¬ã‚¸ã‚§ãƒƒãƒˆã¯è‡ªä½œã™ã‚‹ã“ã¨ã‚‚ã§ãã¾ã™ï¼ˆiGoogle ã‚¬ã‚¸ã‚§ãƒƒãƒˆãƒ™ãƒ¼ã‚¹ï¼‰ã€‚ãã®éš›ã«ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã®æƒ…å ±ã‚’å–å¾—ã™ã‚‹ãŸã‚ã«ä½¿ã‚ã‚Œã‚‹ã®ãŒã€æœ¬æ—¥ã”ç´¹ä»‹ã™ã‚‹ Google Visualization API ã§
Cherenkov 2011/04/18
Google Visualization API / query.setQuery("SELECT * LABEL A 'ç½®æ›å¾Œ'");ç½®æ› GQLã¨ã¯åˆ¥ ã‚¬ã‚¸ã‚§ãƒƒãƒˆãŒQuery Languageã®ç·´ç¿’ã«ä½¿ãˆã‚‹ ä¾¿åˆ© gadget

google

programming

SQL

database

webservice
ãƒªãƒ³ã‚¯
åœ°ç„ã®ã‚ˆã†ã«ã‚ˆãã‚ã‹ã‚‹SQLãƒ†ãƒ¼ãƒ–ãƒ«çµåˆ - ã“ã›ãã®æŠ€è¡“æ—¥è¨˜
ãƒ†ãƒ¼ãƒ–ãƒ«ã®JOINãŒè‹¦æ‰‹ã§ã—ãŸãŒã€ã“ã®ä¾‹ã‚’æ€ã„ã¤ã„ã¦ã‹ã‚‰ã¯ã€ã™ã£ãã‚Šãã£ãã‚Šç†è§£ã§ãã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸã€‚ã‚€ã—ã‚é ã‹ã‚‰é›¢ã‚Œã¾ã›ã‚“â€¦â€¦ã€‚ â€» INNERã€OUTERã¯é£¾ã‚Šã€‚çœç•¥ã§ãã‚‹ã€‚ INNER JOIN â†’ JOIN LEFT OUTER JOIN â†’ LEFT JOIN RIGHT OUTER JOIN â†’ RIGHT JOIN â€» ON ...=... ã‚’ã¾ã¨ã‚ã¦ USING(å±žæ€§) ã¨æ›¸ã‘ã‚‹ã€‚ â€» ä½•ã§çµåˆã™ã‚‹ã‹è¨€ã†ã¾ã§ã‚‚ãªã„æ™‚ã¯ã€NATURALã‚’æŒ‡å®šã™ã‚‹ã¨å‹æ‰‹ã«JOINã—ã¦ãã‚Œã‚‹ã€‚NATURALã«JOINã—ã¦â€¦â€¦ã€‚ â€» WHEREã¯çµåˆã—ãŸçµæžœã«ä½œç”¨ã™ã‚‹ã€‚ â€» ç¾å®Ÿã«ã¯ä¸Šå›³ã®ã‚ˆã†ã«1å¯¾1ã§çµåˆã—ã¾ã›ã‚“ã€‚ â€» ãŠã¾ã‘ã€‚CROSS JOINã€‚ ã“ã‚“ãªã®ä½¿ã„ã¾ã›ã‚“ã€‚ ãƒ–ã‚¯ãƒžç”¨ç”»åƒã€‚
Cherenkov 2011/01/08
SQLå…ˆç”Ÿã®æ€§åˆ¥ãŒæ°—ã«ãªã‚‹ã€‚

SQL

database
ãƒªãƒ³ã‚¯
File: migration.rdoc [Sequel: The Database Toolkit for Ruby]
Migrations This guide is based on guides.rubyonrails.org/migrations.html Overview Migrations make it easy to alter your databaseâ€™s schema in a systematic manner. They make it easier to coordinate with other developers and make sure that all developers are using the same database schema. Migrations are optional, you donâ€™t have to use them. You can always just create the necessary database structure
Cherenkov 2010/07/11
database typeä¸€è¦§ åž‹ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

database

sequel

ruby

Documentation

rdoc
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸