[B! DB] locked_dogã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

locked_dog id:locked_dog

DBã«é–¢ã™ã‚‹locked_dogã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (5)

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

SQLiteå…¥é–€
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã® SQLite ã®ä½¿ã„æ–¹ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚ SQLite ã¯ã‚µãƒ¼ãƒã¨ã—ã¦å‹•ä½œã•ã›ã‚‹ã®ã§ã¯ãªãå˜ç‹¬ã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨ã—ã¦å‹•ä½œã•ã›ã‚‹ã“ã¨ãŒå¯èƒ½ã§ã™ã€‚ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã‚‚ç°¡å˜ãªä¸Šã«éžå¸¸ã«ã‚³ãƒ³ãƒ‘ã‚¯ãƒˆãªãŸã‚ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨ä¸€ç·’ã«é…å¸ƒã™ã‚‹ã¨ã„ã£ãŸåˆ©ç”¨ã‚‚æ•°å¤šãã•ã‚Œã¦ã„ã¾ã™ã€‚ã“ã“ã§ã¯ SQLite ã‚’ä½¿ã£ã¦ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚„ãƒ†ãƒ¼ãƒ–ãƒ«ã®ä½œæˆæ–¹æ³•ã€ãã—ã¦ãƒ‡ãƒ¼ã‚¿ã‚’è¿½åŠ ã—ãŸã‚Šå–å¾—ã—ãŸã‚Šã™ã‚‹æ–¹æ³•ã«ã¤ã„ã¦ä¸€ã¤ä¸€ã¤è§£èª¬ã—ã¦ã„ãã¾ã™ã€‚
locked_dog 2018/11/01
SQL

SQLite

DB
ãƒªãƒ³ã‚¯
ãƒ†ãƒ¼ãƒ–ãƒ«ã®ãƒ‡ãƒ¼ã‚¿ã‚’CSVå½¢å¼ã§ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆ/ã‚¤ãƒ³ãƒãƒ¼ãƒˆ
ãƒ†ãƒ¼ãƒ–ãƒ«ã«æ ¼ç´ã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ã‚’CSVå½¢å¼ã§ãƒ•ã‚¡ã‚¤ãƒ«ã«å‡ºåŠ›ã—ãŸã‚Šã€é€†ã«CSVå½¢å¼ã§æ›¸ã‹ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ã‚’ãƒ†ãƒ¼ãƒ–ãƒ«ã«èªã¿è¾¼ã‚€æ–¹æ³•ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«ã®ãƒ‡ãƒ¼ã‚¿ã‚’ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã™ã‚‹æ–¹æ³•ã‹ã‚‰ç¢ºèªã—ã¾ã™ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æŽ¥ç¶šå¾Œã€ã€ŒFileã€ãƒ¡ãƒ‹ãƒ¥ãƒ¼ã®ä¸ã®ã€ŒExportã€ãƒ¡ãƒ‹ãƒ¥ãƒ¼ã®ä¸ã«ã‚ã‚‹ã€ŒTable as CSV file...ã€ãƒ¡ãƒ‹ãƒ¥ãƒ¼ã‚’ã‚¯ãƒªãƒƒã‚¯ã—ã¦ä¸‹ã•ã„ã€‚ æ¬¡ã®ã‚ˆã†ãªãƒ€ã‚¤ã‚¢ãƒã‚°ãŒè¡¨ç¤ºã•ã‚Œã¾ã™ã€‚ ã€ŒTableã€ã§ã¯å‡ºåŠ›ã—ãŸã„ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’é¸æŠžã—ã¦ä¸‹ã•ã„ã€‚ã€ŒColumn names in first lineã€ã«ãƒã‚§ãƒƒã‚¯ãŒå…¥ã£ã¦ã„ã‚‹ã¨ã€å‡ºåŠ›ã•ã‚Œã‚‹ãƒ•ã‚¡ã‚¤ãƒ«ã®1è¡Œç›®ã«ã‚«ãƒ©ãƒ åã‚’å‡ºåŠ›ã—ã¾ã™ã€‚ ã€ŒField separatorã€ã¯åŒã˜è¡Œã®ä¸ã®ãƒ‡ãƒ¼ã‚¿ã¨ãƒ‡ãƒ¼ã‚¿ã‚’åŒºåˆ‡ã‚‹æ–‡å—ã‚’æŒ‡å®šã—ã¾ã™ã€‚ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã¯ã€Œ,ã€ã§ã™ãŒã€Œ;ã€ã€ŒTABã€ã€Œ|ã€ã€ŒOtherã€ã‹ã‚‰é¸æŠžã§ãã¾ã™ã€‚(Otherã‚’é¸æŠžã™ã‚‹ã¨ä»»æ„ã®æ–‡å—ã‚’æŒ‡å®šã§ãã¾ã™)ã€‚ ã€ŒQ
locked_dog 2018/11/01
SQL

DB
ãƒªãƒ³ã‚¯
ã€Google Fusion Tablesã€‘èª°ã§ã‚‚ç°¡å˜ã«ã§ãã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ä½œã‚Š - ã‚‚ã†ä¸€äººã®Yå›
Last modifiedï¼š2019.01.10 æ³¨æ„ Google Fusion Tables ã¯2019å¹´æœ«ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã—ã¾ã™. è«¸ã€…ã®å®Ÿè£…ã¯çµ‚äº†å‰ã®2019å¹´8æœˆä¸ã«ã¯ã‚¨ãƒ©ãƒ¼è¡¨ç¤ºã¨ãªã‚Š, åˆ©ç”¨ã§ããªããªã‚‹ãã†ã§ã™. ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®é¡žã‚’è€ƒãˆã¦ãŠã‚‰ã‚Œã‚‹æ–¹ã¯ä»–ã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’æ¤œè¨Žãã ã•ã„. [Search]iPhone URLã‚¹ã‚ãƒ¼ãƒ -The theoryã®æˆ¯è¨€ iPhoneã®URLã‚¹ã‚ãƒ¼ãƒ ã‚’æ¤œç´¢ã—ã¦ä¸€è¦§è¡¨ç¤ºã§ãã¾ã™. ãƒªã‚¯ã‚¨ã‚¹ãƒˆã¯å†…å®¹ã«å¿œã˜ã¦ãŠç”ãˆã—ã¾ã™. æ˜¨å¹´ã‹ã‚‰URLã‚¹ã‚ãƒ¼ãƒ ã®ã‚µã‚¤ãƒˆã‚’ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åŒ–ã—, æ¤œç´¢ã™ã‚‹ã‚¹ã‚¿ã‚¤ãƒ«ã«å¤‰æ›´ã—ã¾ã—ãŸãŒ, ãã®è¾ºã®ãã£ã‹ã‘ã‚’ä½œã£ã¦ãã ã•ã£ãŸã®ã¯ã¾ã é«˜æ ¡ã«å…¥å¦ã—ãŸã°ã‹ã‚Šã®ã¨ã‚ã‚‹æ–¹ã§ã—ãŸ. ã‚¸ã‚§ãƒãƒ³ãƒ‹ãŒä¸€æ™©ã§ã‚„ã£ã¦ãã‚Œã¾ã—ãŸã®å¦‚ãã‚ã£ã•ã‚Šä½œã£ã¦ãã ã•ã£ãŸã®ã§ã¾ã html+cssã§ç²¾ä¸€æ¯ã®åƒ•ã«ã¯ãƒãƒ³ãƒ—ãƒ³ã‚«ãƒ³ãƒ—ãƒ³ã ã£ãŸã‚ã‘ã§ã™ãŒ(ä»Šã‚‚ãã†ã§ã™ã‘ã©ã), ã
locked_dog 2017/06/13
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

DB

google
ãƒªãƒ³ã‚¯
ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸–ç•Œ
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
locked_dog 2016/10/06
sql

DB

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°
ãƒªãƒ³ã‚¯
CSEã¨ã¯ ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿ã®äººæ°—ãƒ»æœ€æ–°è¨˜äº‹ã‚’é›†ã‚ã¾ã—ãŸ - ã¯ã¦ãª
Common Subexpression Elimination. å…±é€šéƒ¨åˆ†å¼å‰Šé™¤ï¼Ž ã‚³ãƒ³ãƒ‘ã‚¤ãƒ©ã®æœ€é©åŒ–æŠ€æ³•ã®ã²ã¨ã¤ï¼Žä¾‹ãˆã° v = sin(2*a+1) + cos(2*a+1);ã¨ã„ã†ã‚³ãƒ¼ãƒ‰ã‚’ä»¥ä¸‹ã®ã‚ˆã†ã«å®Ÿè¡Œã™ã‚‹ï¼Ž tmp = 2*a+1; v = sin(tmp) + cos(tmp);DAGã‚’ä½¿ã£ã¦å®Ÿè£…ã§ãã‚‹ãŒï¼Œå¤§è¦æ¨¡ã«ã‚„ã‚‹ã«ã¯ï¼Œé–¢æ•°ã®å‰¯ä½œç”¨ãªã©ã‚’è€ƒæ…®ã—ãªã‘ã‚Œã°ãªã‚‰ãªã„ï¼Ž Common SQL Environment ã€Œã¤ã¿ãã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã€ãŒæä¾›ã—ã¦ã„ã‚‹éžå¸¸ã«ä¾¿åˆ©ãªSQLé–‹ç™ºç’°å¢ƒã‚½ãƒ•ãƒˆã€‚Windowsç”¨ã€‚ Webã‚µã‚¤ãƒˆã®ç´¹ä»‹æ–‡ã‚ˆã‚Š ã€ŒCommon SQL Environment ver1.59ã€ã¯SQLé–‹ç™ºç’°å¢ƒã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã™ã€‚ ãƒ»SQLã®ç·¨é›†ãƒ»å®Ÿè¡Œ ãƒ»ãƒ¬ã‚³ãƒ¼ãƒ‰ã®æ–°è¦ä½œæˆãƒ»æ›´æ–°ãƒ»å‰Šé™¤ ãƒ»DBã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã®ãƒ–ãƒ©ã‚¦ã‚º ãƒ»ãƒ†ãƒ¼ãƒ–ãƒ«å†…ãƒ¬ã‚³ãƒ¼ãƒ‰ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãƒ»ãƒãƒ¼ãƒ‰ ãƒ»å®šç¾©æ›¸ã®Excelå‡ºåŠ›
locked_dog 2013/02/18
Excel

CSE

SQL

DB

é–‹ç™º

Webé–‹ç™º
ãƒªãƒ³ã‚¯
1