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

kanno_kanno id:kanno_kanno

dbã«é–¢ã™ã‚‹kanno_kannoã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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}}

SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³å¯¾ç–ã«æ£è§£ã¯ãªã„
æœ€è¿‘ã€SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã®ãƒã‚¿ãŒç››ã‚Šä¸ŠãŒã£ã¦ã‚‹ã‚ˆã†ã ã€‚ä¸‹è¨˜ã®Togetterã¾ã¨ã‚ã‚ãŸã‚ŠãŒéœ‡æºåœ°ã ã‚ã†ã‹ã€‚ ã€Œãƒ—ãƒªãƒšã‚¢ãƒ¼ãƒ‰ã‚¯ã‚¨ãƒªãŒåŸºæœ¬ã ã‘ã©ã€å‹•çš„ã« SQL ã‚’çµ„ã¿ç«‹ã¦ã‚‹å ´åˆã‚‚ã‚ã‚‹ã‹ã‚‰ã€ãã†ã„ã†å ´åˆã«å‚™ãˆã¦ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ã‚‚çŸ¥ã£ã¦ãŠã„ãŸã»ã†ãŒã„ã„ã‹ã‚‚ã€ - Togetterã¾ã¨ã‚ ã¾ã¨ã‚ã‚’èªã‚“ã æ„Ÿæƒ³ã¨ã—ã¦ã¯ã€ã€Œã©ã¡ã‚‰ã®æ„è¦‹ã‚‚é–“é•ã£ã¦ã¯ã„ãªã„ã€ã¨ã„ã†ã‚‚ã®ã ã€‚å‰æã‚ã‚‹ã„ã¯è¦‹æ–¹ãŒç•°ãªã‚‹ãŸã‚ã«ã€è¦‹è§£ã®ç›¸é•ãŒç”Ÿã˜ã¦ã„ã‚‹ã ã‘ã®ã‚ˆã†ã«æ€ã†ã€‚SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã«ã¤ã„ã¦ã¯ç§ã‚‚è‹¥å¹²æ€ã†ã¨ã“ã‚ãŒã‚ã‚‹ã®ã§æ„è¦‹ã‚’æ›¸ã„ã¦ãŠã“ã†ã¨æ€ã†ã€‚ æ”»æ’ƒã‚’é˜²ãã®ã¯é›£ã—ã„SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã‚’ã¯ã˜ã‚ã¨ã™ã‚‹ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£å¯¾ç–ãŒé›£ã—ã„ã®ã¯ã€ã²ã¨ã¤ã§ã‚‚ç©´ãŒã‚ã‚‹ã¨è‡´å‘½çš„ãªãƒ€ãƒ¡ãƒ¼ã‚¸ã‚’å—ã‘å¾—ã‚‹ã¨ã„ã†ã“ã¨ã ã€‚ã€Œã©ã†ã‚„ã£ã¦åŠ¹çŽ‡ã‚ˆãã‚³ãƒ¼ãƒ‰ã‚’æ›¸ãã‹ã€ã¨ã‹ã€Œã‚³ãƒ¼ãƒ‰ã®ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹æ€§ã‚’é«˜ã‚ã‚‹ã«ã¯ã©ã†æ›¸ãã¹ãã‹ã€ã¿ãŸã„ãªè°è«–ã¨ã¯å…¨ãè³ªãŒç•°ãªã‚‹è°è«–ãŒå¿…è¦ã«ãªã£
kanno_kanno 2014/03/09
â€œSQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã«ã¤ã„ã¦ã‚‚åŒæ§˜ã«ãƒ†ã‚¹ãƒˆãŒé‡è¦â€

SQL

db
ãƒªãƒ³ã‚¯
naoyaã®ã¯ã¦ãªãƒ€ã‚¤ã‚¢ãƒªãƒ¼ - ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°ã®è©±
ã‹ãªã‚ŠãªãŒãƒ¼ã„ã‚¨ãƒ³ãƒˆãƒªã«ãªã‚‹äºˆå®šãªã®ã§,çµè«–ã ã‘æœ€åˆã«æ›¸ãã¨ã“ã‚“ãªæ„Ÿã˜. ã“ã®è©±é¡Œã«ã¤ã„ã¦ã¯è‡ªåˆ†ã‚‚ ã‚ã¨ã§æ›¸ã ã¨è¨€ã£ã¦æ›¸ã„ã¦ãªã‹ã£ãŸã®ã§æ›¸ã„ã¦ã¿ã¾ã™ã‚ˆã€‚2006å¹´ã®ä¸‹æœŸã«ã‚‚ãªã£ã¦ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°ã‹ã‚ˆã¨ã„ã†ãƒ„ãƒƒã‚³ãƒŸã‚‚ã‚ã‚Šãã†ã§ã™ãŒã€ã‚ã¨ã§æ›¸ãã¨ã„ã£ãŸã‚‰æ›¸ãã®ã€‚ã‚ã¨ã§èªã‚€ã¨ã„ã£ãŸã‚‰èªã‚€ã€‚ æ™®é€šã€Œã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°ã€ã¨è¨€ã£ãŸã‚‰ã€ä¸»ã«äºŒã¤ã®å½¹å‰²ãŒã‚ã‚‹ã¨æ€ã„ã¾ã™ã€‚è©±ã‚’ç°¡å˜ã«ã™ã‚‹ãŸã‚ã«ã‚¦ã‚§ãƒ–ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«é™å®šã—ã¦è¨€åŠã—ã¾ã™ã€‚ ã‚¦ã‚§ãƒ–ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‹ã‚‰ DB ã¸ã®æŽ¥ç¶šã‚’é–‹ã‘ã£æ”¾ã—ã«ã—ã¦ã€æŽ¥ç¶šã«å¿…è¦ã¨ã•ã‚Œã‚‹ã‚ªãƒ¼ãƒãƒ¼ãƒ˜ãƒƒãƒ‰ã‚’ã‚«ãƒƒãƒˆã—ã¦åŒæ–¹ã®è² è·ã‚’ä¸‹ã’ã‚‹ã€‚ ã‚¦ã‚§ãƒ–ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨ DB ã¸ã®æŽ¥ç¶šã‚’ã€Œä½¿ã„ã¾ã‚ã™ã€ã“ã¨ã§ã€åŒæ™‚æŽ¥ç¶šæœ¬æ•°ã‚’ç¯€ç´„ã™ã‚‹ã€‚ ã¨ã„ã†ã‚‚ã®ã€‚ mod_perl ã§ DB ã¨æŽ¥ç¶šç¶æŒã™ã‚‹ã¨ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³æ•°å¢—ãˆã¦äº‘ã€…ã¨ã„ã†è©±ã¯ä¸»ã«å‰è€…ã®ã¿ã«ã¤ã„ã¦ã®è©±ã«ãªã‚Šã¾ã™ã€‚Apache::DB
kanno_kanno 2013/09/05
db
ãƒªãƒ³ã‚¯
RDBMSã§ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒ«ãŒå¿…è¦ãªç†ç”±ã€ã‚ã‹ã‚‰ãªã„ã€‚
Takayuki Shimizukawa @shimizukawa @masa_edw ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒ«ãŒç„¡ã„å ´åˆã€ä½¿ã„çµ‚ã‚ã£ãŸã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãŒå³è§£æ”¾ã•ã‚Œãªã„ï¼ˆè§£æ”¾ã¾ã§å¤šå°‘é…å»¶ã™ã‚‹ï¼‰ã®ã§å®Ÿéš›ã«ä½¿ã£ã¦ã„ã‚‹ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ã®æ•°ã‚ˆã‚Šå¤šãå˜åœ¨ã™ã‚‹ã€‚ãã®åˆ†ãƒ¡ãƒ¢ãƒªã‚’åœ§è¿«ã—ã¦åŠ¹çŽ‡ãŒæ‚ªã„ã€‚ã£ã¦ã„ã†è©±ã¯èžã„ãŸã“ã¨ãŒã‚ã‚‹ã‚ˆï¼ˆè¦å‡ºå…¸ 2013-09-04 09:27:28 ãƒã‚¤ãƒ‘ãƒ¼ã‚€ã¨ã† @masa_edw @voluntas ç¾çŠ¶ã§å¿…è¦ãªçŠ¶æ³ã¯ç†è§£ã—ã¦ã„ã¾ã™ãŒã€ãªãœãã†ãªã‚‹ã®ã‹ç†è§£ã—ã¦ã„ãªã„ã¨ã„ã†ã“ã¨ã§ã™ã€‚ä»–ã«ã‚‚ãŸã¨ãˆã°ã€bitlyã®å‘¼ã³å‡ºã—ã¯ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒ«ã‚’ä½¿ã†ã¹ãã‹ï¼Ÿãªãœ(ã¹ãã€ã¹ãã§ãªã„)ã®ã‹ï¼Ÿã©ã†ã„ã†è¦è«‹ã§ãã†ãªã®ã‹ï¼Ÿã¨è¨€ã†å•ã„ã«åƒ•ã¯ç”ãˆã‚‰ã‚Œã¾ã›ã‚“ã€‚ 2013-09-04 09:31:22
kanno_kanno 2013/09/05
db
ãƒªãƒ³ã‚¯
ãªãœBTreeãŒIndexã«ä½¿ã‚ã‚Œã¦ã„ã‚‹ã®ã‹ - maru source
â€»ã“ã®å†…å®¹ã¯å€‹äººçš„ãªè€ƒå¯Ÿãªã®ã§ã€é–“é•ã£ã¦ã„ã‚‹ç®‡æ‰€ã‚‚ã‚ã‚‹ã¨æ€ã„ã¾ã™ã€‚ãã†ã„ã†éƒ¨åˆ†ã‚’è¦‹ã¤ã‘ãŸéš›ã¯ãœã²æ•™ãˆã¦ä¸‹ã•ã„ã€‚ RDBMSã®æ¤œç´¢ã‚’æ—©ãã™ã‚‹ãŸã‚ã«Indexã£ã¦ä½¿ã„ã¾ã™ã‚ˆãã€‚ä¾‹ãˆã°ã“ã‚“ãªãƒ†ãƒ¼ãƒ–ãƒ« CREATE TABLE user ( id INT UNSIGNED NOT NULL, name VARCHAR(255) NOT NULL, UNIQUE INDEX (id) ); idã‚«ãƒ©ãƒ ã«Indexã‚’å¼µã£ã¦ã„ã¾ã™ã€‚ã“ã‚Œã¯idã§ã®æ¤œç´¢ã‚’é«˜é€Ÿã«ã™ã‚‹ãŸã‚ã§ã™ã€‚ã“ã“ã§idã‚«ãƒ©ãƒ ã«IndexãŒè²¼ã£ã¦ã„ãªã„å ´åˆã¨æ¯”ã¹ã‚‹ã¨æ¤œç´¢æ™‚é–“ãŒå¤§å¹…ã«å¤‰ã‚ã£ã¦ãã¦ã—ã¾ã„ã¾ã™ï¼ˆç‰¹ã«ãƒ¬ã‚³ãƒ¼ãƒ‰ãŒå¤šããªã£ãŸæ™‚) ã§ã¯ãªãœIndexã‚’è²¼ã‚‹ã¨æ¤œç´¢ãŒæ—©ããªã‚‹ã‚“ã§ã—ã‚‡ã†ï¼Ÿï¼Ÿ Indexã¨ã¯ãã®åã®é€šã‚Šç´¢å¼•ã‚’æ„å‘³ã—ã¾ã™ã€‚ç‰¹å®šã®ã‚«ãƒ©ãƒ ã®ç´¢å¼•ã‚’ä½œæˆã—ã¦ãŠãã“ã¨ã§æ¤œç´¢ã‚’é«˜é€ŸåŒ–ã—ã¾ã™ã€‚ (æœ¬ã®æœ€å¾Œã«ã‚ˆã¿ãŒãªé †ã§å˜èªžãŒä¸¦ã¹ã‚‰ã‚ŒãŸã‚Šã—ã¦ã„ã¾ã™
kanno_kanno 2013/05/07
ã‚¢ãƒ«ã‚´ãƒªã‚ºãƒ

DB

index
ãƒªãƒ³ã‚¯
ãƒ—ãƒãƒ•ã‚¡ã‚¤ãƒªãƒ³ã‚°ã§å¿«é©MySQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ç”Ÿæ´»
MySQL 5.1ã‹ã‚‰ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§æœ‰åŠ¹ã«ãªã£ã¦ã„ã‚‹ä¾¿åˆ©ãªæ©Ÿèƒ½ã¨ã—ã¦ãƒ—ãƒãƒ•ã‚¡ã‚¤ãƒªãƒ³ã‚°ã¨ã„ã†ã‚‚ã®ãŒã‚ã‚‹ã€‚MySQL 5.0ã§ã‚‚åˆ©ç”¨å‡ºæ¥ãŸã®ã ãŒã€å®Ÿé¨“çš„ãªæ©Ÿèƒ½ã¨ã„ã†ä½ç½®ã¥ã‘ã§ã‚ã‚Šã€æè¼‰ã•ã‚Œã¦ã„ãŸã®ã¯GPLç‰ˆã®MySQL Community Serveré™å®šã ã£ãŸã€‚MySQL 5.1ã‹ã‚‰ã¯å…¨ã¦ã®ã‚¨ãƒ‡ã‚£ã‚·ãƒ§ãƒ³ã§ãƒ—ãƒãƒ•ã‚¡ã‚¤ãƒªãƒ³ã‚°ã‚’åˆ©ç”¨ã™ã‚‹ã“ã¨ãŒã§ãã‚‹ã€‚ ãƒ—ãƒãƒ•ã‚¡ã‚¤ãƒªãƒ³ã‚°æ©Ÿèƒ½ã‚’åˆ©ç”¨ã™ã‚‹ã¨ã€ã‚¯ã‚¨ãƒªã®çŠ¶æ…‹ï¼ˆç‰¹ã«çŠ¶æ…‹é·ç§»ã‚„ãƒªã‚½ãƒ¼ã‚¹ã®æ¶ˆè²»çŠ¶æ³ï¼‰ã‚’è©³ç´°ã«åˆ†æžã§ãã‚‹ã®ã§ã¨ã¦ã‚‚ä¾¿åˆ©ã ã€‚MySQL ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢å¿…æºã®æ©Ÿèƒ½ã¨ã„ã£ã¦è‰¯ã„ã ã‚ã†ã€‚ã¨ã„ã†ã‚ã‘ã§ãƒ—ãƒãƒ•ã‚¡ã‚¤ãƒªãƒ³ã‚°æ©Ÿèƒ½ã®ä½¿ã„æ–¹ã‚’èª¬æ˜Žã—ã‚ˆã†ã€‚ MySQLã‚µãƒ¼ãƒã«ãƒã‚°ã‚¤ãƒ³ã—ãŸã‚‰ã€ã¾ãšã¯æ¬¡ã®ã‚ˆã†ã«ã—ã¦ãƒ—ãƒãƒ•ã‚¡ã‚¤ãƒªãƒ³ã‚°ã‚’æœ‰åŠ¹ã«ã™ã‚‹ã€‚ mysql> SET profiling=1; ã™ã‚‹ã¨ã€ã‚¯ã‚¨ãƒªã®æƒ…å ±ãŒè¨˜éŒ²ã•ã‚Œã‚‹ã‚ˆã†ã«ãªã‚‹ã€‚æ¬¡ã«ã€åˆ†æžã—ãŸã„ã‚¯ã‚¨ãƒªã‚’å®Ÿè¡Œã™ã‚‹ã€‚ã‚¯ã‚¨ãƒªã¯ãªã‚“ã§ã‚‚ã„ã„
kanno_kanno 2012/07/23
mysql

db
ãƒªãƒ³ã‚¯
The SQL Injection Knowledge Base
Examples: SELECT * FROM Articles WHERE id = '1'''; SELECT 1 FROM dual WHERE 1 = '1'''''''''''''UNION SELECT '2'; Notes: You can use as many apostrophes and quotations as you want as long as they pair up. It is also possible to continue the statement after the chain of quotes. Quotes escape quotes.
kanno_kanno 2012/07/07
SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³

db

ã‚ã¨ã§èªã‚€
ãƒªãƒ³ã‚¯
ã“ã‚Œã ã‘è¦‹ã‚Œã°å¤§ä¸ˆå¤«ï¼ãƒ¼MySQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ç›£è¦–ã®ãƒ„ãƒœï¼ˆã‚¯ã‚¨ãƒªç·¨ï¼‰ï½œæŠ€è¡“ãƒ–ãƒã‚°ï½œåŒ—æµ·é“æœå¹Œå¸‚ãƒ»å®®åŸŽçœŒä»™å°å¸‚ã®VRãƒ»ã‚²ãƒ¼ãƒ ãƒ»ã‚·ã‚¹ãƒ†ãƒ é–‹ç™º ã‚¤ãƒ³ãƒ•ã‚£ãƒ‹ãƒƒãƒˆãƒ«ãƒ¼ãƒ—
ã“ã‚Œã ã‘è¦‹ã‚Œã°å¤§ä¸ˆå¤«ï¼ãƒ¼MySQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ç›£è¦–ã®ãƒ„ãƒœï¼ˆã‚¯ã‚¨ãƒªç·¨ï¼‰ ã“ã‚“ã«ã¡ã¯ã€ã‚¤ãƒ³ãƒ•ãƒ©æ‹…å½“æ–°äººã® nob ã§ã™ã€‚ ã‚µãƒ¼ãƒãƒ¼ç›£è¦–ãƒ„ãƒ¼ãƒ«ã§ MySQL ã‚’ç›£è¦–ã—ã¦ã„ã‚‹ã®ã«ãƒ‡ãƒ¼ã‚¿ãŒå¤šã™ãŽã¦æ´»ç”¨ã—ã¦ã„ãªã„ã€‚ã¨ã„ã†æ–¹ã¯ã„ã¾ã›ã‚“ã‹ï¼Ÿãã®è±Šå¯Œãªãƒ‡ãƒ¼ã‚¿ã‚’ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒ»ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«æ´»ç”¨ã—ãªã„æ‰‹ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ä»Šå›žã¯ã‚µãƒ¼ãƒãƒ¼ç›£è¦–ãƒ„ãƒ¼ãƒ«ã®ã‚°ãƒ©ãƒ•ã‚’èªã¿è§£ã„ãŸå®Ÿæˆ¦çµŒé¨“ã‚’å…ƒã«ã€ã€Œã“ã‚Œã ã‘è¦‹ã‚Œã°å¤§ä¸ˆå¤«ã€ã¨ã„ã†ãƒ„ãƒœã‚’ã¾ã¨ã‚ã¦ã¿ã¾ã—ãŸã€‚ ã“ã‚Œã ã‘è¦‹ã‚Œã°å¤§ä¸ˆå¤«ï¼ã€€ã‚¯ã‚¨ãƒªç·¨ã€€ï¼“ã¤ã®ã¤ã¼ã¨ï¼•ã¤ã®ã‚°ãƒ©ãƒ• ï¼ˆãã®ï¼‘ï¼‰ç›£è¦–ãƒ„ãƒ¼ãƒ«ãŒä½•ã‚’è¦‹ã¦ã„ã‚‹ã®ã‹çŸ¥ã‚‹ ï¼ˆãã®ï¼’ï¼‰ç›£è¦–ã®ã‚ãƒ¢ã€ã‚°ãƒ©ãƒ•ï¼“ç‚¹ã‚»ãƒƒãƒˆ (Questions, Lock Waits ã¨ Transaction Handler) ï¼ˆãã®ï¼“ï¼‰ã‚°ãƒ©ãƒ•ã§ãƒã‚§ãƒƒã‚¯ã™ã‚‹ SQL ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° ( Select Type ã¨ Handler) ã‚·ãƒ³ãƒ—ãƒ«ã§ãŠå‹§ã‚ã€ã‚µãƒ¼ãƒãƒ¼ç›£è¦–ã‚°ãƒ©ãƒ•åŒ–ãƒ„ãƒ¼ãƒ«
kanno_kanno 2012/03/10
ãƒ„ãƒ¼ãƒ«

mysql

db

ã‚ã¨ã§èªã‚€
ãƒªãƒ³ã‚¯
åŸºç¤Žã‹ã‚‰ç†è§£ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã—ãã¿ï¼ˆ4ï¼‰
å›³4â—ãƒã‚¹ãƒˆãƒ»ãƒ«ãƒ¼ãƒ—çµåˆã‚¢ãƒ«ã‚´ãƒªã‚ºãƒ ã€‚ãƒ†ãƒ¼ãƒ–ãƒ«Aã®å„ãƒ¬ã‚³ãƒ¼ãƒ‰ã«ã¤ã„ã¦ãƒ†ãƒ¼ãƒ–ãƒ«Bã®ã™ã¹ã¦ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã¨æ¯”è¼ƒã—ã¾ã™ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®çµ±è¨ˆæƒ…å ±ã¯å®šæœŸçš„ã«æ›´æ–°ã™ã‚‹ åŸºæœ¬çš„ã«ã¯ï¼Œã»ã¨ã‚“ã©ã®å ´åˆã«ã‚³ã‚¹ãƒˆãƒ»ãƒ™ãƒ¼ã‚¹ãƒ»ã‚¢ãƒ—ãƒãƒ¼ãƒã«åŸºã¥ãã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶ã¯æœ€é©ãªå®Ÿè¡Œè¨ˆç”»ã‚’é¸æŠžã—ã¦ãã‚Œã‚‹ã¨è€ƒãˆã¦ã•ã»ã©å•é¡Œã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ãŸã ï¼Œã‚³ã‚¹ãƒˆãƒ»ãƒ™ãƒ¼ã‚¹ã®åŸºã«ãªã‚‹ã‚³ã‚¹ãƒˆã®è¨ˆç®—ã¯ï¼Œãƒ†ãƒ¼ãƒ–ãƒ«ã®ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã®å€¤ãŒå‡ç‰ã«åˆ†å¸ƒã—ã¦ã„ã‚‹ã¨ä»®å®šã—ã¦è¡Œã„ã¾ã™ã€‚ãã®ãŸã‚ï¼Œãƒ‡ãƒ¼ã‚¿ã®åˆ†å¸ƒã«æ¥µç«¯ãªåã‚ŠãŒã‚ã‚‹å ´åˆãªã©ã¯ï¼Œå®Ÿéš›ã«ã¯å…¨ä»¶èµ°æŸ»ã®ã»ã†ãŒå‡¦ç†ã¯æ—©ãçµ‚ã‚ã‚‹ã®ã«ï¼Œã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹æ¤œç´¢ã‚’é¸æŠžã—ã¦ã—ã¾ã†ã‚ˆã†ãªå ´åˆã‚‚ã‚ã‚Šå¾—ã¾ã™ã€‚ ã‚³ã‚¹ãƒˆãƒ»ãƒ™ãƒ¼ã‚¹ãƒ»ã‚¢ãƒ—ãƒãƒ¼ãƒã‚’ä½¿ã£ã¦åŠ¹çŽ‡ã®è‰¯ã„å®Ÿè¡Œè¨ˆç”»ã‚’ç«‹ã¦ã‚‹ã«ã¯ï¼Œå®šæœŸçš„ã«çµ±è¨ˆæƒ…å ±ã‚’æ›´æ–°ã™ã‚‹ã“ã¨ãŒé‡è¦ãªãƒã‚¤ãƒ³ãƒˆã¨ãªã‚Šã¾ã™ã€‚çµ±è¨ˆæƒ…å ±ã¯ï¼Œã‚ãã¾ã§ã‚‚ãã‚Œã‚’ä½œæˆã—ãŸã¨ãã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®çŠ¶æ…‹ã‚’åæ˜ ã—ã¦ã„ã¾ã™ã€‚ã—ãŸãŒã£ã¦ï¼Œçµ±è¨ˆæƒ…å ±ã‚’ä½œæˆã—ãŸå¾Œã«ãƒ‡ãƒ¼ã‚¿
kanno_kanno 2012/03/09
db

SQL
ãƒªãƒ³ã‚¯
Big Sky :: Vimã§DBãŒæ“ä½œã§ãã‚‹ vdbi-vim ä½œã£ãŸã€‚
DBæ“ä½œãƒ„ãƒ¼ãƒ« Emacs DBI ã‚’ä½œã£ã¦ã¿ãŸ - æŠ€è¡“æ—¥è¨˜ï¼ kiwanami ã“ã®ãƒ„ãƒ¼ãƒ«ã®ç›®çš„ã¯ã€ã‚¯ãƒã‚¹ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ ã§ä¾¿åˆ©ãªDBæ“ä½œç’°å¢ƒã‚’å®Ÿç¾ã™ã‚‹ã“ã¨ã§ã™ã€‚ pgAdmin ã‚„ MySQL Query Browser ã®ã‚ˆã†ãªGUIã®è‰¯ã•ã‚’CUIã§å®Ÿç¾ã—ã¦ã¿ã‚ˆã†ã¨ã—ã¦ã¿ã¾ã—ãŸã€‚ã™ãªã‚ã¡ã€ã¼ãã®ã‹ã‚“ãŒãˆãŸã•ã„ãã‚‡ã†ã®DBãƒ„ãƒ¼ãƒ«ã§ã™ã€‚ã¡ãªã¿ã«ã€ã“ã®ãƒ„ãƒ¼ãƒ«ã«ã¨ã£ã¦Emacsã¯ãŸã ã®å®Ÿè¡Œç’°å¢ƒã§ã™ã€‚Emacsä½¿ã‚ãªã„äººã§ã‚‚ä½¿ã†ã¨ä¾¿åˆ©ã ã¨æ€ã„ã¾ã™ã€‚ http://d.hatena.ne.jp/kiwanami/20120305/1330939440 Vimã‚‚ãƒ¼Vimã‚‚ãƒ¼ï¼ ã£ã¦äº‹ã§ä½œã‚Šã¾ã—ãŸã€‚ mattn/vdbi-vim - GitHub Database client for Vim https://github.com/mattn/vdbi-vim Emacsç‰ˆã¯epcã¨ã„ã†RPCãƒ—ãƒãƒˆ
kanno_kanno 2012/03/07
ã“ã®ãƒ¬ãƒ™ãƒ«ã¾ã§ã„ãã¨Vimã„ã˜ã‚ŠãŒãƒ›ãƒ³ãƒˆæ¥½ã—ãã†ã€‚ã™ã”ã„

vim

db
ãƒªãƒ³ã‚¯
ã¯ã¦ãªãƒ–ãƒã‚° | ç„¡æ–™ãƒ–ãƒã‚°ã‚’ä½œæˆã—ã‚ˆã†
2024å¹´ã«è¦³ãŸæ˜ ç”»ãƒ»ãƒ‰ãƒ©ãƒžãµã‚Šã‹ãˆã‚Š å‰å›žè¨˜äº‹ã§2024å¹´ã®ã‚²ãƒ¼ãƒ ãµã‚Šã‹ãˆã‚Šã‚’æ›¸ã„ãŸã®ã§ã€ä»Šå›žã¯2024å¹´ã«è¦³ãŸæ˜ ç”»ãƒ»ãƒ‰ãƒ©ãƒžã‚’æŒ¯ã‚Šè¿”ã‚‹ã€‚ãªãŠä»Šå¹´â€è¦³ãŸâ€ãªã®ã§å…¬é–‹å¹´ãŒéŽåŽ»ã®ä½œå“ã‚‚å«ã¾ã‚Œã‚‹ã€‚ æ˜ ç”» ãƒ–ãƒ©ãƒƒã‚¯ãƒ™ãƒªãƒ¼ ä»Šå¹´â€è¦³ãŸâ€ãªã‹ã§ä¸€ç•ªå¥½ãã€‚ã€Œå¦¥å”ã—ã¦ãªã«ã‹ä½œã£ã¦å¤±æ•—ã—ãŸã“ã¨ãŒã‚ã‚‹äººã€ã«ã¨ã£ã¦ã€ãƒ©ã‚¹ãƒˆæ•°â€¦
kanno_kanno 2012/03/01
db

sql
ãƒªãƒ³ã‚¯
ã€21ç¤¾ã‹ã‚‰5ç¤¾ã‚’SNSã®è©•åˆ¤ã‹ã‚‰åŽ³é¸ã€‘ãŠã™ã™ã‚ã®å‡ºä¼šã„ç³»ã‚¢ãƒ—ãƒªï¼†å¤±æ•—ã—ãªã„é¸ã³æ–¹ï½œãƒžãƒƒãƒãƒ³ã‚°ã‚¢ãƒ—ãƒªæ¼‚æµæ•™å®¤ â€“ ãƒžãƒƒãƒãƒ³ã‚°ã‚¢ãƒ—ãƒªã®æ„Ÿæƒ³ã‚’SNSã®æ„è¦‹ã‚’å‚è€ƒã«ç´¹ä»‹
kanno_kanno 2011/12/31
db

æ›¸ç±
ãƒªãƒ³ã‚¯
åŒã˜ï¼³ï¼¥ï¼¬ï¼¥ï¼£ï¼´æ–‡åŒå£«ã§ã®ãƒ‡ãƒƒãƒ‰ãƒãƒƒã‚¯ãŒç™ºç”Ÿ
ï¼žï¼’ã¤ã®å‡¦ç†ãŒãƒãƒƒã‚¯ã—ã¦ã—ã¾ã†ã€ã¨ã„ã†ã‚ˆã†ã«èžã“ãˆã¾ã™ãŒ ï¼žã“ã†ã„ã†ã“ã¨ã¯ã‚ã‚‹ã‚“ã§ã—ã‚‡ã†ã‹ï¼Ÿ ã‚ã‚‹ã‚“ã§ã™ã€‚ï¼¡ã®ãƒ—ãƒã‚»ã‚¹ã‚‚ã€ï¼¢ã®ãƒ—ãƒã‚»ã‚¹ã‚‚ã€Œèª°ã‚‚ãƒãƒƒã‚¯ã—ã¦ãªã„ã€ã£ã¦æ€ã£ã¦ã¾ã™ã‹ã‚‰ã€‚ ï¼¡ãŒãƒãƒƒã‚¯ã‚’æŽ›ã‘ãŸç›´å¾Œã«ã€ï¼¢ã¯ã€Œã•ã£ãèª¿ã¹ãŸæ™‚ã¯èª°ã‚‚ãƒãƒƒã‚¯ã—ã¦ãªã‹ã£ãŸã‹ã‚‰ã€ãƒãƒƒã‚¯ã—ã‚ˆã†ã€ã¨ã€Œä¸Šæ›¸ããƒãƒƒã‚¯ã€ã‚’ã—ã¦ã—ã¾ã„ã¾ã™ã€‚ é€šå¸¸ã¯ï¼‘ã¨ï¼“ã®é–“ã«ï¼’ãŒå‰²ã‚Šè¾¼ã¾ãšã€ï¼’ãŒå¾Œå›žã—ã«ãªã‚‹ç‚ºã€ä»¥ä¸‹ã®ã‚ˆã†ã«ï¼¡ã‚‚ï¼¢ã‚‚æ£å¸¸çµ‚äº†ã—ã¾ã™ã€‚ ï¼‘ï¼Žï¼¡ãŒãƒ¬ã‚³ãƒ¼ãƒ‰ã®ãƒãƒƒã‚¯çŠ¶æ…‹ã‚’æ¤œæŸ»ã€‚ãƒãƒƒã‚¯ç„¡ã—ã¨åˆ¤å®š ï¼“ï¼Žï¼¡ãŒãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’ãƒãƒƒã‚¯ ï¼’ï¼Žï¼¢ãŒãƒ¬ã‚³ãƒ¼ãƒ‰ã®ãƒãƒƒã‚¯çŠ¶æ…‹ã‚’æ¤œæŸ»ã€‚ãƒãƒƒã‚¯æœ‰ã‚Šã¨åˆ¤å®š ï¼”ï¼Žï¼¢ã¯ãƒ¬ã‚³ãƒ¼ãƒ‰ã®ãƒãƒƒã‚¯ãŒè§£é™¤ã•ã‚Œã‚‹ã¾ã§å¾…ã¡åˆã‚ã› ï¼ˆä»¥ä¸‹ç•¥ï¼‰ ãƒ‡ãƒƒãƒˆãƒãƒƒã‚¯ã®ç›´æŽ¥ã®åŽŸå› ã¯ã€Œé–“ã«å‰²ã‚Šè¾¼ã¿ãŒå…¥ã‚‰ãšä¸€é€£ã®å‹•ä½œã¨ã—ã¦å‡¦ç†ã—ãªã‘ã‚Œã°ãªã‚‰ãªã„ã€ãƒãƒƒã‚¯çŠ¶æ…‹ã®æ¤œæŸ»ã¨ãƒãƒƒã‚¯è¨å®šã®é–“ã«ã€åˆ¥ãƒ—ãƒã‚»ã‚¹ãŒå‰²ã‚Šè¾¼ã‚€ãŸã‚ã€ã§ã™ã€‚ ã“ã†ã„ã†ã‚±ãƒ¼ã‚¹ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒã‚µãƒ¼ãƒãƒ¼ä¸Šã«
kanno_kanno 2011/10/19
db
ãƒªãƒ³ã‚¯
1