[B! sql] kei-sã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

kei-s id:kei-s

sqlã«é–¢ã™ã‚‹kei-sã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (19)

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

ã€YQL é€Ÿæ”»ãƒ¬ãƒ“ãƒ¥ãƒ¼ã€‘ç±³ Yahoo! ãŒ SQL ã£ã½ãè‰²ã‚“ãªãƒ‡ãƒ¼ã‚¿ã‚’å–ã£ã¦ã“ã‚Œã‚‹APIã‚’å‡ºã—ãŸ - ã¦ã£ãç…®ãƒ–ãƒã‚°
ç±³ Yahoo! ãŒ Yahoo! Pipes ã¿ãŸã„ã«è‡ªç”±åº¦ãŒé«˜ãã¦ã€ã¾ãŸã¡ã‚‡ã£ã¨æ¯›è‰²ãŒé•ã†ã‚µãƒ¼ãƒ“ã‚¹ãŒå‡ºã¦ããŸã€‚é¡Œã—ã¦ã€Yahoo! Query Languageã€‚YQL ã¨å‘¼ã¶ã‚ˆã†ã ã€‚SQL é¢¨ã®è¨€èªžã‚’ REST ã§æŠ•ã’ã¦ã€çµæžœã‚’ XML ã‚„ JSON ã§å—ã‘å–ã‚‹ã“ã¨ãŒã§ãã‚‹ã€‚å…·ä½“çš„ã«ã‚„ã£ã¦ã¿ãªã„ã¨åˆ†ã‹ã‚Šã«ãã„ã®ã§ã€ã¨ã‚Šã‚ãˆãšè©¦ã—ã¦ã¿ãŸã€‚RSS ã‹ã‚‰ãƒ‡ãƒ¼ã‚¿å–å¾—YQL ã‚’ä½¿ã£ã¦ RSS ã‹ã‚‰æœ€æ–°ã®ã‚¿ã‚¤ãƒˆãƒ«10å€‹ã‚’å–ã£ã¦ãã¦ã¿ã‚‹ã€‚ã“ã‚“ãª YQL ã«ãªã‚‹ã‚‰ã—ã„ã€‚ select title from rss where url='http://d.hatena.ne.jp/nitoyon/rss' rss ãƒ†ãƒ¼ãƒ–ãƒ«ã«å¯¾ã—ã¦ select ã‚’ç™ºè¡Œã—ã¦ã„ã‚‹ã€‚å®Ÿéš›ã«ã“ã® YQL ã‚’è©¦ã™ã«ã¯ YQL ç”¨ã® console ã‚’åˆ©ç”¨ã™ã‚‹ã¨ã‚ˆã„ã€‚ï¼ˆâ€»è¦ãƒã‚°ã‚¤ãƒ³ï¼‰console ã®å·¦ä¸Šã« YQL ã‚’å…¥åŠ›ã—ã¦
kei-s 2008/12/15
api

json

rss

sql

yahoo

xpath
ãƒªãƒ³ã‚¯
SQL Server Expressã‚’ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã™ã‚‹æ–¹æ³• - Tech<3 by æ¦Šç¥ä»‹ - s21g
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 ã€ŒSQL Server Expressã€ã‚’ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã™ã‚‹ã®ã¯ã€é¢å€’ã€‚ ç®¡ç†ç”»é¢ã€ŒSQL Server Management Studioã€ä¸Šã‹ã‚‰GUIæ“ä½œã§ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¯ã§ãã‚‹ãŒã€ã‚¹ã‚±ã‚¸ãƒ¥ãƒ¼ãƒªãƒ³ã‚°ã—ã¦æ¯Žæ—¥ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã€ã¨ã„ã†ã‚ˆã†ãªã“ã¨ãŒã§ããªã„ã€‚ä»¥ä¸‹ã®ã‚ˆã†ã«ã™ã‚‹ã¨å®Ÿç¾ã§ãã‚‹ã€‚ æ¦‚è¦ã€ŒSQL Server Expressã€ã‚’ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ã‹ã‚‰æ“ä½œã§ãã‚‹ã‚ˆã†ã«ã—ã¦ã€ãƒãƒƒãƒå‡¦ç†ã®ã‚¿ã‚¹ã‚¯ã«ã™ã‚‹ã€‚ æº–å‚™ ã€ŒSQL Server Expressã€ã‚’ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³æ“ä½œã™ã‚‹ãƒ„ãƒ¼ãƒ«ã¯sqlcmdã§ã“ã‚Œã¯microsoftã‹ã‚‰ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã§ãã‚‹ã€‚å…ˆã«ã€åŒã˜URLã‹ã‚‰ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã§ãã‚‹ã€Œsql native clientã€ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ãŒå¿…è¦
kei-s 2008/10/22
sql

tips

sqlserver
ãƒªãƒ³ã‚¯
SQL Injection Cheat Sheet
Examples; (MS) means : MySQL and SQL Server etc. (M*S) means : Only in some versions of MySQL or special conditions see related note and SQL Server Table Of Contents About SQL Injection Cheat Sheet Syntax Reference, Sample Attacks and Dirty SQL Injection Tricks Line Comments SQL Injection Attack Samples Inline Comments Classical Inline Comment SQL Injection Attack Samples MySQL Vers
kei-s 2007/03/22
db

sql

security

tips
ãƒªãƒ³ã‚¯
Installing PostgreSQL 8 for Windows
PostgreSQL 8 Windowsç‰ˆã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ–¹æ³• PostgreSQLã¯ï¼Œã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆæŒ‡å‘ã®æ©Ÿèƒ½ã‚’ä¸€éƒ¨å–ã‚Šå…¥ã‚ŒãŸæ‹¡å¼µåž‹ã®ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚·ã‚¹ãƒ†ãƒ ã§ã™ã€‚ãƒãƒ¼ã‚¸ãƒ§ãƒ³8ã‹ã‚‰ã¯ï¼ŒWindowsç‰ˆã‚‚æ£å¼ã«ãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã¾ã—ãŸã€‚ ã“ã“ã§ã¯ï¼ŒPostgreSQL 8 Windowsç‰ˆã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦ï¼Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½œæˆã—ï¼ŒSQLã‚³ãƒžãƒ³ãƒ‰ï¼ˆCREATE TABLEæ–‡ï¼ŒINSERTæ–‡ï¼ŒSELECTæ–‡ç‰ï¼‰ãŒä½¿ç”¨ã§ãã‚‹ã‚ˆã†ã«ãªã‚‹ã¾ã§ã®æ‰‹é †ã¨æ–¹æ³•ã‚’èª¬æ˜Žã—ã¾ã™ã€‚ ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã®å…¥æ‰‹ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« ã‚µãƒ¼ãƒã®èµ·å‹•ãƒ»åœæ¢ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä½œæˆ è£œè¶³äº‹é … 0. æ³¨æ„ æœ¬æ–‡ã®ç„¡æ–è¤‡è£½ã¯ãŠæ–ã‚Šã—ã¾ã™ã€‚ æœ¬æ–‡ã®å†…å®¹ã«ã¤ã„ã¦ï¼Œé–“é•ã„ã‚„æ›¸ãè¶³ã‚‰ãªã„ç‚¹ãŒã‚ã‚Šã¾ã—ãŸã‚‰ï¼Œè‘—è€…ã¾ã§ãƒ¡ãƒ¼ãƒ«ã§ãŠçŸ¥ã‚‰ã›ãã ã•ã„ã€‚ æœ¬æ–‡ã«è¨˜è¼‰ã•ã‚ŒãŸURLã‚„ãƒ•ã‚¡ã‚¤ãƒ«åã¯ï¼Œã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ç‰ã«ã‚ˆã‚Šå¤‰æ›´ã«ãªã£ã¦ã„ã‚‹å¯èƒ½æ€§ãŒã‚ã‚Šã¾ã™ã€‚
kei-s 2007/03/07
ã€Žã‚¢ã‚«ã‚¦ãƒ³ãƒˆã€Œpostgresã€ã¯æ®‹ã£ã¦ã„ã¦ã‚‚ç‰¹ã«å•é¡Œã¯ã‚ã‚Šã¾ã›ã‚“ãŒï¼Œå†ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ç‰ã®ãŸã‚ã«å‰Šé™¤ãŒå¿…è¦ã«ãªã£ãŸå ´åˆã¯ï¼Œä»¥ä¸‹ã®ã‚ˆã†ã«ã‚³ãƒžãƒ³ãƒ‰ãƒ—ãƒãƒ³ãƒ—ãƒˆã§net userã‚³ãƒžãƒ³ãƒ‰ã‚’ä½¿ç”¨ã—ã¦ãã ã•ã„ã€‚ã€

db

sql

tips
ãƒªãƒ³ã‚¯
PostgreSQLã®ãƒˆãƒ©ãƒ–ãƒ«ã‚·ãƒ¥ãƒ¼ãƒ†ã‚£ãƒ³ã‚°ã€€[ã‚»ãƒ³ã‚µãƒ¼ãƒãƒƒãƒˆãƒ»ã‚†ã³ããŸã™å¤§å¦]
ãƒˆãƒ©ãƒ–ãƒ«ã‚·ãƒ¥ãƒ¼ãƒ†ã‚£ãƒ³ã‚°ã€€Moteview : ERROR[08001] or psql : Connection refused (0x0000274D/10061) ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã¯æ£å¸¸ã«çµ‚äº†ã—ãŸã¯ãšãªã®ã«ã€ï¼ˆã‚‚ã—ãã¯ã€Mote Viewã¯ã—ã°ã‚‰ãæ£å¸¸ã«å‹•ä½œã—ã¦ã„ãŸã®ã«ã€æ°—ã¥ã„ãŸã‚‰ãƒ»ãƒ»ã€ï¼‰å‹•ã‹ãªããªã£ã¦ã„ãŸã€‚ãã‚‚ãã‚‚ã€PostgreSQLãŒèµ·å‹•ã—ãªããªã£ãŸãƒ»ãƒ»ãƒ»ã¨ã„ã†æ™‚ã®å¯¾å¿œã€‚ Moteview ã‚¨ãƒ©ãƒ¼ã‚³ãƒ¼ãƒ‰ã€€ERROR[08001]; psql ã‚¨ãƒ©ãƒ¼ã‚³ãƒ¼ãƒ‰ã€€psql: could not connect to server: Connection refused (0x0000274D/10061) Mote-Viewã‚’èµ·å‹•ã—ã¦ã‚‚DBã«ã¤ãªãŒã‚‰ãªã„ã€‚ã‚¨ãƒ©ãƒ¼ã‚’è¦‹ã‚‹ã¨"Could not connect to the server;"ã¨ãªã£ã¦ã„ã‚‹ã€‚ ã‚¿ã‚¹ã‚¯ãƒžãƒãƒ¼ã‚¸ãƒ£ã§ãƒ—ãƒã‚»ã‚¹ã‚’è¦‹ã¦ã¿ã‚‹ã¨ã€€
kei-s 2007/02/20
db

sql

tips
ãƒªãƒ³ã‚¯
naoyaã®ã¯ã¦ãªãƒ€ã‚¤ã‚¢ãƒªãƒ¼ - MySQL ã®è² è·åˆ†æ•£ã« LVS + keepalived ã‚’ä½¿ã†
ã‚ã¨ã§æ›¸ãã€ã¨è¨€ã£ãŸæ‰‹å‰ãªã®ã§æ›¸ãã¨ã—ã¾ã™ã€‚ DSASã®ä¸ã®äººãŒã™ã”ã„å‹¢ã„ã§ LVS ã®è©±ã‚’æ›¸ã„ã¦ãã‚Œã¦ã¾ã™ã€‚ã“ã®è¾ºã€‚LVS ã‚’ä½¿ã†ã¨ Linux ã¨ç®±ã§ãƒãƒ¼ãƒ‰ãƒãƒ©ãƒ³ã‚µãŒä½œã‚Œã¡ã‚ƒã„ã¾ã™ã€‚æ™®é€šã«è²·ã£ãŸã‚‰æ•°ç™¾ä¸‡ã¨ã‹ã—ã¡ã‚ƒã†ã‚„ã¤ã€‚ DSAS ã®ä¸ã®ã²ã¨ã«æ„Ÿè¬ã—ã¤ã¤ã€ã„ã„æ©Ÿä¼šãªã®ã§ã‚„ã£ã¦ã¿ã‚ˆã†! ã¨æ€ã£ã¦ã„ã‚ã„ã‚è©¦ã—ã¦æ˜¨æ—¥ã‚ãŸã‚Šã‹ã‚‰ã¯ã¦ãªã®ä¸ã§ã‚‚ LVS + keepalived ã§å‹•ã‹ã—ã¯ã˜ã‚ã¦ã¾ã™ã€‚ã„ã¾ã®ã¨ã“ã‚å•é¡Œãªã—ã€‚ ãã®ãƒãƒ¼ãƒ‰ãƒãƒ©ãƒ³ã‚µã‚’ã©ã“ã«ä½¿ã£ã¦ã‚‹ã‹ã§ã™ãŒã€æ™®é€šãƒãƒ¼ãƒ‰ãƒãƒ©ãƒ³ã‚µã¨ã„ã†ã¨ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆã‹ã‚‰ã®å…¥ã‚Šå£ã®ã¨ã“ã‚ã«ç½®ã„ã¦ã‚¦ã‚§ãƒ–ã‚µãƒ¼ãƒãƒ¼ã®è² è·åˆ†æ•£ã«ä½¿ã†ã‚¤ãƒ¡ãƒ¼ã‚¸ãŒã‚ã‚Šã¾ã™ã€‚ãŒã€ä»Šå›žã¯ã¯ã¦ãªã§ã¯ MySQL ã®ã‚¹ãƒ¬ãƒ¼ãƒ–ã®æ‰‹å‰ã«ç½®ãã¨ã„ã†å½¹å‰²ã§ã¨ã‚Šã‚ãˆãšä½¿ã„ã¯ã˜ã‚ã¾ã—ãŸã€‚ +-----------+ +-----------+ | mod_perl | | mod_perl | +----
kei-s 2007/01/16
db

linux

server

sql

tips
ãƒªãƒ³ã‚¯
pgpool-II page
kei-s 2006/12/26
db

sql
ãƒªãƒ³ã‚¯
ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¨ãƒªã‚¹ãƒˆã‚¢
ç›®æ¬¡23.1. SQLã«ã‚ˆã‚‹ãƒ€ãƒ³ãƒ—23.1.1. ãƒ€ãƒ³ãƒ—ã®ãƒªã‚¹ãƒˆã‚¢23.1.2. pg_dumpallã®ä½¿ç”¨23.1.3. å¤§è¦æ¨¡ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ‰±ã„23.2. ãƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†ãƒ ãƒ¬ãƒ™ãƒ«ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—23.3. ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¨ãƒã‚¤ãƒ³ãƒˆã‚¤ãƒ³ã‚¿ã‚¤ãƒ ãƒªã‚«ãƒãƒªï¼ˆPITRï¼‰23.3.1. WALä¿ç®¡ã®è¨å®š23.3.2. ãƒ™ãƒ¼ã‚¹ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã®ä½œæˆ23.3.3. ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’ä½¿ç”¨ã—ãŸå¾©æ—§23.3.4. æ™‚ç³»åˆ—23.3.5. è¦å‘Š23.4. ãƒªãƒªãƒ¼ã‚¹é–“ã®ç§»è¡Œ è²´é‡ãªãƒ‡ãƒ¼ã‚¿ã‚’å…¨ã¦ä¿å˜ã—ã¦ã„ã‚‹ãŸã‚ã€PostgreSQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯å®šæœŸçš„ã«ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã•ã‚Œãªã‘ã‚Œã°ãªã‚Šã¾ã›ã‚“ã€‚ ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã®æ‰‹é †ã¯åŸºæœ¬çš„ã«ç°¡å˜ã§ã™ãŒã€ä½¿ç”¨ã•ã‚Œã¦ã„ã‚‹æŠ€è¡“ã¨ã„ãã¤ã‹ã®ä»®å®šã¨ãªã‚‹æ¡ä»¶ã®åŸºæœ¬çš„ç†è§£ã¯é‡è¦ã§ã™ã€‚ PostgreSQLã®ãƒ‡ãƒ¼ã‚¿ã‚’ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã™ã‚‹å ´åˆã€3ã¤ã®ç•°ãªã‚‹æ‰‹æ³•ãŒã‚ã‚Šã¾ã™ã€‚ SQLã«ã‚ˆã‚‹ãƒ€ãƒ³ãƒ—ãƒ•ã‚¡ã‚¤ãƒ«
kei-s 2006/09/24
sql

db
ãƒªãƒ³ã‚¯
Eclipseã«SQLã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆæ©Ÿèƒ½ã‚’è¿½åŠ ã™ã‚‹ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã€ŽEclipse SQL Explorerã€:phpspoté–‹ç™ºæ—¥èªŒ
Eclipseã«SQLã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆæ©Ÿèƒ½ã‚’è¿½åŠ ã™ã‚‹ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã€ŽEclipse SQL Explorerã€ 2006å¹´09æœˆ05æ—¥- Eclipse SQL Explorer Eclipse SQL Explorer is a thin SQL client that allows you to query and browse any JDBC compliant database. It supports plugins with specialized functionality for individual databases (Oracle, DB2 and MySQL) and can be extended to include specialized support for other databases.Eclipseã«SQLã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆæ©Ÿèƒ½ã‚’è¿½åŠ ã™ã‚‹ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã€ŽEclips
kei-s 2006/09/06
PostgreSQLã¯ç„¡ã„ã¿ãŸã„ï¼Ÿ

db

java

tool

plugin

sql
ãƒªãƒ³ã‚¯
é€†å¼•ãSQLæ¯”è¼ƒ
Works > é€†å¼•ãSQLæ¯”è¼ƒ é€†å¼•ãSQLæ¯”è¼ƒ [Â å…±é€šäº‹é …Â ]Â [Â ORACLEÂ ]Â [Â MSSQLÂ ]Â [Â SSAÂ ]Â [Â PostgresÂ ]Â [Â MySQLÂ ]Â [Â JetÂ ]Â Last Updated. 14-May-2006 Since 08-May-2001 â– ã¯ã˜ã‚ã« è¤‡æ•°ã® RDBMS ã‚’ä½¿ã£ãŸçµŒé¨“ãŒã‚ã‚‹äººãªã‚‰ã€ãŠã‚ã‹ã‚Šã‹ã¨æ€ã„ã¾ã™ãŒã€SQL ã¯ RDBMS ã«ã‚ˆã£ã¦ç•°ãªã‚‹éƒ¨åˆ†ãŒçµæ§‹ã‚ã‚Šã¾ã™ã€‚ ã“ã®ãƒšãƒ¼ã‚¸ã¯å„ RDBMS ã«ãŠã‘ã‚‹ åŸºæœ¬çš„ãªæ©Ÿèƒ½ï¼ˆä¸»ã«SQLã«ã¤ã„ã¦ï¼‰ã®æ¦‚è¦ã‚’ã€é€†å¼•ãã§ã€ã‹ã¤å¹³æ˜“ãªè¨€è‘‰ã§é–²è¦§ ã™ã‚‹äº‹ã‚’ç›®çš„ã«ä½œã£ãŸãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã§ã™ã€‚ ç‰¹å®šã® RDBMS ã‚’æŒã¡ä¸Šã’ãŸã‚Šã€è²¶ã‚ãŸã‚Šã™ã‚‹ã®ãŒç›®çš„ã§ã¯ãªã„ã®ã§èª¤è§£ãªãã‚ˆã†ã€‚ ã¾ãŸã€é–“é•ã„ã«ã¤ã„ã¦ã®ã”æŒ‡æ‘˜ã‚„ã€Žã“ã†ã—ãŸæ–¹ãŒåŠ¹çŽ‡çš„ã ã€ãªã©ã®ã”æ„è¦‹ã‚‚å¤§æ“è¿Žã§ã™ã€‚ å¯¾è±¡ã¨ã—ã¦ã„ã‚‹ã®ã¯ä»¥ä¸‹ã® RDBMSã§
kei-s 2006/06/23
sql

db

tips
ãƒªãƒ³ã‚¯
ã¯ã¦ãªãƒ–ãƒã‚° | ç„¡æ–™ãƒ–ãƒã‚°ã‚’ä½œæˆã—ã‚ˆã†
çµµã®è¶…åˆå¿ƒè€…ãƒ‰ä¸‹æ‰‹ããäººé–“ãŒã€20æ—¥é–“çµµã‚’æã„ã¦æ„Ÿã˜ãŸã“ã¨ ã‚ãŸã—ã¯ã€ã€Œæ–‡ã®äººã€ã ã€‚çµµã‚’æãã®ã¯å¤§ã®è‹¦æ‰‹ã€‚ ãã‚“ãªã‚ãŸã—ãŒã€ã²ã‚‡ã‚“ãªã“ã¨ã‹ã‚‰çµµã‚’æãå§‹ã‚ãŸã€‚ ãã†ã—ãŸã‚‰ãŠã‚‚ã—ã‚ããªã£ã¦ç´„20æ—¥é–“ã€ãªã«ãŒã—ã‹ã‚’æãã¤ã¥ã‘ã¦ã„ã‚‹ã€‚ æœªçŸ¥ã®é ˜åŸŸã§ã®æŒ‘æˆ¦ã¯ã€ç™ºè¦‹ãŒå¤šã„ã€‚ ã¾ãŸã€ã“ã“ã¾ã§çµµã‚’æã‘ãªã„äººé–“ã®æŒ‘æˆ¦ã¯ã€ã‚ã¾ã‚Šãƒãƒƒâ€¦
kei-s 2006/05/26
rails

db

sql

tips
ãƒªãƒ³ã‚¯
mysql:12071ã€€éšŽå±¤åŒ–ã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ã‚’MySQLã§æ‰±ã†
From: zen kishimoto <zen kishimoto <zen@xxxxxxxxxx>> Date: Sat, 03 Sep 2005 09:24:15 -0700 Subject: [mysql 12071] éšŽå±¤åŒ–ã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ã‚’MySQLã§æ‰±ã†ã€€ï¼ˆManaging Hierarchical Data in MySQLï¼‰ http://dev.mysql.com/tech-resources/articles/hierarchical-data.html ï¼ˆå›³ã¯ã“ã®ã‚µã‚¤ãƒˆã‚’å‚ç…§ã®ã“ã¨ï¼‰ Mike Hillyerè‘— åˆã‚ã« å¤šãã®ãƒ¦ãƒ¼ã‚¶ãƒ¼ã¯ä¸€å›žãã‚‰ã„ã¯SQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å†…ã§ã€éšŽå±¤åŒ–ã—ãŸãƒ‡ãƒ¼ã‚¿ã‚’ æ‰±ã£ãŸã“ã¨ãŒã‚ã‚‹ã¨æ€ã„ã¾ã™ã€‚ãã®ã¨ãã¯ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ« ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯éšŽå±¤åŒ–ã—ãŸãƒ‡ãƒ¼ã‚¿ç”¨ã«é–‹ç™ºã•ã‚Œãªã‹ã£ãŸã¨è€ƒãˆãŸã¨æ€ã„ã¾ã™ã€‚ ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã¯éšŽå±¤åŒ–ã•ã‚Œã¦ãŠã‚‰ãš
kei-s 2006/04/07
db

sql

tips
ãƒªãƒ³ã‚¯
1ã¤ã®SQLæ–‡ã§è¤‡æ•°ã®è¡¨ã«INSERTã™ã‚‹çµ¶å“ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ï¼ˆ1/2ï¼‰ â€• ï¼ IT
æœ¬é€£è¼‰ã¯SQLã®å¿œç”¨åŠ›ã‚’èº«ã«ä»˜ã‘ãŸã„ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢å‘ã‘ã«ã€ã•ã¾ã–ã¾ãªãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã‚’ç´¹ä»‹ã™ã‚‹ã€‚SQLã®åŸºæœ¬æ§‹æ–‡ã¯å¹³æ˜“ãªã‚‚ã®ã ãŒã€å®Ÿå‹™ã§æ´»ç”¨ã™ã‚‹ã«ã¯æ•™ç§‘æ›¸çš„ãªè¨˜è¿°ã‚’ç†è§£ã™ã‚‹ã ã‘ã§ã¯ä¸ååˆ†ã ã€‚æœ¬é€£è¼‰ã¯ã€è‘—åãªãƒ¡ãƒ¼ãƒ«ãƒžã‚¬ã‚¸ãƒ³ã€ŒãŠã‚‰ï¼ã‚ªãƒ©ï¼ Oracle - ã©ã£ã·ã‚Šæ¤œè¨¼ç”Ÿæ´»ã€ã‚’ç™ºè¡Œã™ã‚‹ã‚¤ãƒ³ã‚µã‚¤ãƒˆãƒ†ã‚¯ãƒŽãƒã‚¸ãƒ¼ã®ã‚³ãƒ³ã‚µãƒ«ã‚¿ãƒ³ãƒˆã‚’åŸ·ç†é™£ã«è¿Žãˆã€SQLã®ã‚»ãƒ³ã‚¹å‘ä¸Šã«å½¹ç«‹ã¤å¤§æŠ€å°æŠ€ã‚’ç´¹ä»‹ã—ã¦ã„ãã€‚ï¼ˆç·¨é›†å±€ï¼‰ FOR...LOOPæ–‡ã‚’ä½¿ã£ã¦ã€ã„ãã¤ã‚‚ã®SQLæ–‡ã§ãƒ‡ãƒ¼ã‚¿ã‚’INSERTã—ã¦ã„ã‚‹PL/SQLãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã‚„ãƒ—ãƒã‚°ãƒ©ãƒ ã‚’ã‚ˆãè¦‹æŽ›ã‘ã¾ã™ãŒã€å®Ÿã¯1åº¦ã«ãƒ‡ãƒ¼ã‚¿ã‚’INSERTã™ã‚‹æ–¹æ³•ã‚‚ã‚ã‚‹ã‚“ã§ã™ã€‚ãƒžãƒ«ãƒãƒ†ãƒ¼ãƒ–ãƒ«ãƒ»ã‚¤ãƒ³ã‚µãƒ¼ãƒˆï¼ˆMultitable Insertï¼‰ã¨ã¯ãã®åã®ã¨ãŠã‚Šã€1ã¤ã®SQLæ–‡ã§è¤‡æ•°ã®è¡¨ã«INSERTãŒå¯èƒ½ã«ãªã‚Šã¾ã™ã€‚ã“ã®æœ€å¤§ã®ãƒ¡ãƒªãƒƒãƒˆã¯ã€ã‚„ã¯ã‚Šãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã§ã™ã€‚ã§ã¯æ—©é€Ÿã”ç´¹ä»‹ã—ã¾ã™ã€‚ ãƒžãƒ«ãƒãƒ†ãƒ¼ãƒ–
kei-s 2006/03/01
sql
ãƒªãƒ³ã‚¯
ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸–ç•Œ
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
kei-s 2006/02/21
programming

sql
ãƒªãƒ³ã‚¯
åŸºç¤Žã‹ã‚‰ç†è§£ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã—ãã¿ï¼ˆ5ï¼‰ï¼šITpro
SQLæ–‡ã‚’å®Ÿè¡Œã™ã‚‹éš›ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«å¤§ããªå½±éŸ¿ã‚’åŠã¼ã™ã‚‚ã®ã¨ã—ã¦ï¼Œã‚‚ã†ä¸€ã¤ï¼Œã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒã‚ã‚Šã¾ã™ã€‚ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã¤ã„ã¦ã¯ï¼Œã©ã†å®šç¾©ã™ã¹ãã‹ã¨ã„ã†ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆä¸Šã®å•é¡Œã¨ï¼Œã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’æœ‰åŠ¹ã«ä½¿ã†ãŸã‚ã®SQLæ–‡ã‚’ã©ã†æ›¸ãã¹ãã‹ã¨ã„ã†ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ä¸Šã®å•é¡ŒãŒã‚ã‚Šã¾ã™ã€‚ ã“ã“ã§ã¯ãƒ†ãƒ¼ãƒ–ãƒ«è¨è¨ˆä¸Šã®å•é¡Œã‚’ä¸»ã«å–ã‚Šä¸Šã’ã¾ã™ã€‚SQLæ–‡ã®ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã«ã¤ã„ã¦ã¯å›²ã¿è¨˜äº‹ã€ŒSQLæ–‡ã‚’æœ€é€Ÿã«ã™ã‚‹11ã®ãƒã‚¤ãƒ³ãƒˆã€ã‚’å‚ç…§ã—ã¦ãã ã•ã„ã€‚ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯ï¼Œãƒ†ãƒ¼ãƒ–ãƒ«ã®æ¤œç´¢é€Ÿåº¦ã‚’å‘ä¸Šã•ã›ã‚‹ãŸã‚ã®ã‚‚ã®ã§ã™ã€‚ãã‚Œãžã‚Œã®SQLæ–‡ã«å¯¾ã—ã¦æœ€é©ãªã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’å®šç¾©ã™ã‚‹ã®ãŒç†æƒ³çš„ã§ã™ãŒï¼Œå®Ÿéš›ã«ã¯ã‚ã‚‹ç¨‹åº¦é™ã‚‰ã‚ŒãŸã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã§ï¼Œå¿…è¦ãªãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è¦ä»¶ã‚’æº€ãŸã™ã‚ˆã†ã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’å®šç¾©ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚åŠ ãˆã¦ï¼Œã©ã‚“ãªSQLæ–‡ãŒå®Ÿéš›ã«ç™ºè¡Œã•ã‚Œã‚‹ã®ã‹ãŒã‚ã‚‰ã‹ã˜ã‚ã‚ã‹ã£ã¦ã„ãªã„å ´åˆã¯ï¼Œé©å½“ãªæƒ³å®šã«åŸºã¥ã„ã¦ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’å®šç¾©ã—ã¦ãŠã‹ãªãã¦ã¯
kei-s 2006/01/23
sql

tips
ãƒªãƒ³ã‚¯
SQL -TECHSCORE-
ã“ã“ã§ã¯ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«åž‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ“ä½œã™ã‚‹ãŸã‚ã«å¿…é ˆã¨ãªã‚‹ä¸–ç•Œæ¨™æº–è¨€èªž SQL ã«ã¤ã„ã¦ã€åŸºç¤Žã‹ã‚‰å¿œç”¨ã¾ã§è©³ã—ãèª¬æ˜Žã—ã¦ã„ã¾ã™ã€‚ ã¾ãŸã€SQL ã®ã¿ã«ã¨ã©ã¾ã‚‰ãšã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒžãƒãƒ¼ã‚¸ãƒ¡ãƒ³ãƒˆã‚·ã‚¹ãƒ†ãƒ (RDBMS) ã®æŒã¤æ§˜ã€…ãªæ©Ÿèƒ½ã«ã¤ã„ã¦è©³ã—ãèª¬æ˜Žã—ã¦ã„ã¾ã™ã€‚ æœ€å¾Œã«ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®è¨è¨ˆã«é–¢ã™ã‚‹éžå¸¸ã«é‡è¦ãªè€ƒãˆæ–¹ã«ã¤ã„ã¦ã‚‚è§¦ã‚Œã¦ã„ã¾ã™ã®ã§ã€ã“ã‚Œã‚‰ã‚’å…¨ã¦å¦ç¿’ã™ã‚‹ã¨ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ“ä½œã‹ã‚‰è¨è¨ˆã¾ã§å¹…åºƒã„çŸ¥è˜ã‚’èº«ã«ã¤ã‘ã‚‹ã“ã¨ãŒã§ãã‚‹ã§ã—ã‚‡ã†ã€‚ SQL INDEX 1. ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ¦‚è¦ 1.1. ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã¯ 1.2. ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚·ã‚¹ãƒ†ãƒ ã®ç‰¹å¾´ 1.3. ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ãƒ•ã‚¡ã‚¤ãƒ«ã®é•ã„ 1.4. ä»£è¡¨çš„ãªãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ« 1.5. ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«åž‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ 1.6. ã¾ã¨ã‚ 2. SQL 2.1. SQL ã®æ´å² 2.2. SQL ã¨ã¯ 2.3. SQL ã®æ©Ÿèƒ½ 2.
kei-s 2005/12/08
sql
ãƒªãƒ³ã‚¯
rails install
ç›®æ¬¡ 2005å¹´11æœˆ30æ—¥ - åŽŸç¨¿å‡ºã— / 2005å¹´11æœˆ29æ—¥ - ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã‚·ã‚¹ãƒ†ãƒ ã€ãƒ†ã‚¯ãƒŽãƒã‚¸ãƒ¼ã€ãƒ—ãƒ©ã‚¯ãƒ†ã‚£ã‚¹ã‚’åˆ†æžãƒ»è©•ä¾¡ã™ã‚‹5ã¤ã®ã‚¹ãƒ†ãƒƒãƒ— / ä»•äº‹ / ã€Žæš—å·æŠ€è¡“å…¥é–€ â€”â€” ç§˜å¯†ã®å›½ã®ã‚¢ãƒªã‚¹ã€å¢—åˆ· / 2005å¹´11æœˆ26æ—¥ - é«˜æ©‹ãƒ¡ã‚½ãƒƒãƒ‰ã®ãƒ—ãƒ¬ã‚¼ãƒ³ãƒ†ãƒ¼ã‚·ãƒ§ãƒ³ã‚’flashã®ãƒãƒ¼ã‚«ãƒ«ãƒ•ã‚¡ã‚¤ãƒ«ã¨ã—ã¦ä½œã‚‹ã«ã¯ï¼Ÿ / 2005å¹´11æœˆ25æ—¥ - æ—¥è¨˜ãƒ€ã‚¤ã‚¸ã‚§ã‚¹ãƒˆæ›´æ–° / 2005å¹´11æœˆ23æ—¥ - ã‚ˆã‹ã£ãŸæŽ¢ã—ãƒªãƒ¼ã‚¹ / æ‰“ã¡åˆã‚ã› / 2005å¹´11æœˆ22æ—¥ - ã€Œãƒ†ãƒˆãƒ©ã¡ã‚ƒã‚“ã¨ç›¸åŠ ç›¸ä¹—å¹³å‡ã€ã®LaTeXãƒ•ã‚¡ã‚¤ãƒ«å…¬é–‹ / æ°—æŒã¡ã®ã‚ˆã„æœ / 2005å¹´11æœˆ21æ—¥ - å¹´æœ«é€²è¡Œ / ãŠä»•äº‹ãƒ¡ãƒ¼ãƒ«ã¨Webã‚µã‚¤ãƒˆ / 2005å¹´11æœˆ20æ—¥ - æ—¥æ›œæ—¥ / æ•°å¦ã‚¬ãƒ¼ãƒ« / 2005å¹´11æœˆ19æ—¥ - ãŠã›ã‚“ã¹ã„ã®å¯¾è©± / 2005å¹´11æœˆ18æ—¥ - Tropy: 2005å¹´11æœˆ
kei-s 2005/11/03
web
ãƒªãƒ³ã‚¯
MySQL AB :: MySQL 4.1 ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«
æ¦‚è¦ ã“ã‚Œã¯ MySQL ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã§ã™ã€‚ MySQL 8.0 ã‹ã‚‰ 8.0.25ã€ãŠã‚ˆã³ NDB ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ 8.0 ã‹ã‚‰ 8.0.25-ndb-8.0.25 ã«åŸºã¥ã NDB Cluster ãƒªãƒªãƒ¼ã‚¹ã«ã¤ã„ã¦ãã‚Œãžã‚Œèª¬æ˜Žã—ã¾ã™ã€‚ ã¾ã ãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã¦ã„ãªã„ MySQL ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®æ©Ÿèƒ½ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆãŒå«ã¾ã‚Œã¦ã„ã‚‹å ´åˆãŒã‚ã‚Šã¾ã™ã€‚ ãƒªãƒªãƒ¼ã‚¹ã•ã‚ŒãŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®è©³ç´°ã¯ã€ã€ŒMySQL 8.0 ãƒªãƒªãƒ¼ã‚¹ãƒŽãƒ¼ãƒˆã€ã‚’å‚ç…§ã—ã¦ãã ã•ã„ã€‚ MySQL 8.0 ã®æ©Ÿèƒ½. ã“ã®ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã§ã¯ã€MySQL 8.0 ã®ã‚¨ãƒ‡ã‚£ã‚·ãƒ§ãƒ³ã«ã‚ˆã£ã¦ã¯å«ã¾ã‚Œã¦ã„ãªã„æ©Ÿèƒ½ã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã™ã€‚ã“ã®ã‚ˆã†ãªæ©Ÿèƒ½ã¯ã€ã”è‡ªèº«ã«ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ä»˜ä¸Žã•ã‚Œã¦ã„ã‚‹ MySQL 8.0 ã®ã‚¨ãƒ‡ã‚£ã‚·ãƒ§ãƒ³ã«å«ã¾ã‚Œã¦ã„ãªã„å ´åˆãŒã‚ã‚Šã¾ã™ã€‚ MySQL 8.0 ã®ä½¿ç”¨ã—ã¦ã„ã‚‹ã‚¨ãƒ‡ã‚£ã‚·ãƒ§ãƒ³ã«å«ã¾ã‚Œã‚‹æ©Ÿèƒ½ã«é–¢ã™ã‚‹è³ªå•ãŒã‚ã‚‹å ´åˆã¯ã€MySQL 8.0
kei-s 2005/10/26
sql

programming
ãƒªãƒ³ã‚¯
SQLè¬›åº§ - [SMART]
CONTACT WITH RHYTHMFACTORY ãƒªã‚ºãƒ ãƒ•ã‚¡ã‚¯ãƒˆãƒªãƒ¼ã¯ãƒ›ãƒ¼ãƒ ãƒšãƒ¼ã‚¸ã®åˆ¶ä½œä¼šç¤¾ã§ã™ã€‚ ãƒ›ãƒ¼ãƒ ãƒšãƒ¼ã‚¸åˆ¶ä½œã«é–¢ã™ã‚‹ã”è¦æœ›ãƒ»ã”ç›¸è«‡ã¯ã“ã¡ã‚‰ã‹ã‚‰ã©ã†ãžã€‚
kei-s 2005/10/26
sql

programming
ãƒªãƒ³ã‚¯
1