[B! sql] nextbigthingã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

nextbigthing id:nextbigthing

sqlã«é–¢ã™ã‚‹nextbigthingã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (8)

${{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ã®å‘¼ã³å‡ºã—æ–¹
2010 å¹´ 3 æœˆ ã€Œå®‰å…¨ãªã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆã®ä½œã‚Šæ–¹ã€ åˆ¥å†Š å®‰å…¨ãª S Q L ã® å‘¼ã³å‡ºã—æ–¹ æœ¬æ›¸ã¯ã€ä»¥ä¸‹ã® URL ã‹ã‚‰ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã§ãã¾ã™ã€‚ ã€Œå®‰å…¨ãª SQL ã®å‘¼ã³å‡ºã—æ–¹ã€ http://www.ipa.go.jp/security/vuln/websecurity.html ç›®æ¬¡ ç›®æ¬¡.....................................................................................................................................................................................................2 ã¯ã˜ã‚ã«.................................................
nextbigthing 2011/07/25
sql

ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£
ãƒªãƒ³ã‚¯
SQL æ•°å€¤é–¢æ•° - ä½™ã‚Šã€å››æ¨äº”å…¥ã€åˆ‡ã‚Šæ¨ã¦ã€åˆ‡ã‚Šä¸Šã’ã€æ•°å€¤ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆä»– - SAK Streets
SQL æ•°å€¤é–¢æ•° - ä½™ã‚Šã€å››æ¨äº”å…¥ã€åˆ‡ã‚Šæ¨ã¦ã€åˆ‡ã‚Šä¸Šã’ã€æ•°å€¤ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆä»– åŸºæœ¬çš„ã« Oracleã€SQL-Serverã€MDB ã§å…±é€šã§ã™ã€‚ â– ãƒ“ãƒƒãƒˆè«–ç†ç© (Oracle8i ä»¥é™) ãƒ»bitand() é–¢æ•°ã¯ã€ãƒ“ãƒƒãƒˆè«–ç†ç©ã‚’è¿”ã™ã€‚ ãƒ“ãƒƒãƒˆãƒžã‚¹ã‚¯ã«ä½¿ç”¨ã§ãã‚‹ã®ã§ä¾¿åˆ©ã§ã‚ã‚‹ã€‚ select bitand(255, 4) from dual; select decode(bitand(255, 4), 1, '1', 'not 1') from dual; â– çµ¶å¯¾å€¤ ãƒ»abs() é–¢æ•°ã¯ã€çµ¶å¯¾å€¤ã‚’è¿”ã™ã€‚ ã“ã®ä¾‹ã§ã¯ã€å—æ³¨æ•°ã«ãƒžã‚¤ãƒŠã‚¹ãŒã‚ã£ã¦ã‚‚æ£æ•°ã¨ã—ã¦å•ã„åˆã‚ã•ã‚Œã‚‹ã€‚ select å“ç•ª, abs(å—æ³¨æ•°) from sak.å—æ³¨m order by å“ç•ª ; â– ä½™ã‚Š ãƒ»mod() é–¢æ•°ã¯ã€ä½™ã‚Šã‚’è¿”ã™ã€‚ ã“ã®ä¾‹ã§ã¯ã€å—æ³¨æ•°ã‚’ 1000 ã§å‰²ã£ãŸã‚ã¾ã‚ŠãŒå•ã„åˆã‚ã•ã‚Œã‚‹ã€‚ select å“ç•ª
nextbigthing 2011/05/14
sql
ãƒªãƒ³ã‚¯
Web Page Under Construction
Network Solutions - Original domain name registration and reservation services with variety of internet-related business offerings. Quick, dependable and reliable.
nextbigthing 2011/05/02
sql

geocoding

mysql
ãƒªãƒ³ã‚¯
ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã¨ã¯ SQL -TECHSCORE-
SQL ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æ“ä½œè¨€èªžSQLã«ã¤ã„ã¦ã€ã¾ãŸRDBMSã®æŒã¤æ©Ÿèƒ½ã«ã¤ã„ã¦è©³ã—ãè§£èª¬ã—ã¾ã™ã€‚ DBæ¦‚è¦ã€SQLã€ãƒ†ãƒ¼ãƒ–ãƒ«æ“ä½œã€ãƒ‡ãƒ¼ã‚¿æ“ä½œ ... ç‰¹é›†ï¼šreplication PostgreSQLã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚·ã‚¹ãƒ†ãƒ ã‚’ç´¹ä»‹ã—ã€ãã‚Œã‚‰ã®æ©Ÿèƒ½ã‚’æ¯”è¼ƒã—ã¦ã„ãã¾ã™ã€‚ ç‰¹é›†ï¼špgbench PostgreSQLã®ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ãƒ†ã‚¹ãƒˆã«ç”¨ã„ã‚‰ã‚Œã‚‹ãƒ—ãƒã‚°ãƒ©ãƒ ã§ã‚ã‚‹ pgbench ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚ SQLæ¼”ç¿’å•é¡Œ å„ç« ã«ç”¨æ„ã•ã‚ŒãŸæ¼”ç¿’å•é¡Œã‚’é›†ã‚ã¾ã—ãŸã€‚
nextbigthing 2011/04/01
sql
ãƒªãƒ³ã‚¯
Oracleã§ä½¿ã†SQLã®åŸºç¤Žã‚’å¦ã¶
2005å¹´3æœˆ16æ—¥ã‹ã‚‰ã¯è©¦é¨“æ™‚é–“ã¨å•é¡Œæ•°ãŒå¤‰æ›´ã•ã‚Œã¾ã—ãŸã€‚ä»¥å‰ã¯120åˆ†ã§56å•ã§ã—ãŸãŒã€å•é¡Œæ•°ãŒå°‘ãªããªã‚Š90åˆ†ã§40å•ã«ãªã‚Šã¾ã—ãŸã€‚ãŸã ã—ä»¥å‰ã¯71ï¼…ã ã£ãŸåˆæ ¼ç‚¹ã®å‰²åˆã¯ã€å¤‰æ›´å¾Œã‚‚70ï¼…ã§ã™ã®ã§é›£æ˜“åº¦ã¯å¤‰ã‚ã‚Šã¾ã›ã‚“ã€‚å•é¡Œæ•°ãŒå°‘ãªããªã£ãŸåˆ†ã€ã„ã‹ã«å„è¨å•ã«æ£è§£ã™ã‚‹ã‹ãŒé‡è¦ã§ã™ã€‚ã¾ãŸã€ä»¥å‰ã¯ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã®ä½œæˆé–¢é€£ã¯ã»ã¨ã‚“ã©å‡ºé¡Œã•ã‚Œã¦ã„ã¾ã›ã‚“ã§ã—ãŸãŒã€è©¦é¨“ãŒå¤‰æ›´ã•ã‚Œã¦ã‹ã‚‰ã¯ã‹ãªã‚Šã®å•é¡Œæ•°ãŒå‡ºé¡Œã•ã‚Œã¦ã„ã¾ã™ã€‚ ã§ã¯Bronze SQL åŸºç¤Ž Iã®ç¯„å›²ã«æ²¿ã£ã¦å„ç¨®å•é¡Œã‚’è§£ããªãŒã‚‰è§£èª¬ã—ã¦ã„ãã¾ã—ã‚‡ã†ã€‚ åŸºæœ¬çš„ãªSELECTæ–‡ã®ä½œæˆ ç†è§£ã—ã¦ãŠããŸã„ã“ã¨ 1. ç¢ºèªã—ã¦ãŠããŸã„å†…å®¹ SELECTæ–‡ã®æ©Ÿèƒ½ åŸºæœ¬çš„ãªSELECTæ–‡ã®å®Ÿè¡Œ SQLæ–‡ã¨iSQL*Plusï¼ˆSQL*Plusï¼‰ã‚³ãƒžãƒ³ãƒ‰ã®åŒºåˆ¥ 2. SQLæ–‡ã®åŒºåˆ† SQLï¼ˆStructured Query Languageï¼šæ§‹é€ åŒ–å•ã„åˆã‚ã›è¨€
nextbigthing 2011/03/22
sql

database
ãƒªãƒ³ã‚¯
ãƒˆãƒƒãƒ—ãƒšãƒ¼ã‚¸
SQL ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æ“ä½œè¨€èªžSQLã«ã¤ã„ã¦ã€ã¾ãŸRDBMSã®æŒã¤æ©Ÿèƒ½ã«ã¤ã„ã¦è©³ã—ãè§£èª¬ã—ã¾ã™ã€‚ DBæ¦‚è¦ã€SQLã€ãƒ†ãƒ¼ãƒ–ãƒ«æ“ä½œã€ãƒ‡ãƒ¼ã‚¿æ“ä½œ ... ç‰¹é›†ï¼šreplication PostgreSQLã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚·ã‚¹ãƒ†ãƒ ã‚’ç´¹ä»‹ã—ã€ãã‚Œã‚‰ã®æ©Ÿèƒ½ã‚’æ¯”è¼ƒã—ã¦ã„ãã¾ã™ã€‚ ç‰¹é›†ï¼špgbench PostgreSQLã®ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ãƒ†ã‚¹ãƒˆã«ç”¨ã„ã‚‰ã‚Œã‚‹ãƒ—ãƒã‚°ãƒ©ãƒ ã§ã‚ã‚‹ pgbench ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚ SQLæ¼”ç¿’å•é¡Œ å„ç« ã«ç”¨æ„ã•ã‚ŒãŸæ¼”ç¿’å•é¡Œã‚’é›†ã‚ã¾ã—ãŸã€‚
nextbigthing 2011/03/12
sql

SQL
ãƒªãƒ³ã‚¯
ãƒˆãƒƒãƒ—ãƒšãƒ¼ã‚¸
SQL ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æ“ä½œè¨€èªžSQLã«ã¤ã„ã¦ã€ã¾ãŸRDBMSã®æŒã¤æ©Ÿèƒ½ã«ã¤ã„ã¦è©³ã—ãè§£èª¬ã—ã¾ã™ã€‚ DBæ¦‚è¦ã€SQLã€ãƒ†ãƒ¼ãƒ–ãƒ«æ“ä½œã€ãƒ‡ãƒ¼ã‚¿æ“ä½œ ... ç‰¹é›†ï¼šreplication PostgreSQLã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚·ã‚¹ãƒ†ãƒ ã‚’ç´¹ä»‹ã—ã€ãã‚Œã‚‰ã®æ©Ÿèƒ½ã‚’æ¯”è¼ƒã—ã¦ã„ãã¾ã™ã€‚ ç‰¹é›†ï¼špgbench PostgreSQLã®ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ãƒ†ã‚¹ãƒˆã«ç”¨ã„ã‚‰ã‚Œã‚‹ãƒ—ãƒã‚°ãƒ©ãƒ ã§ã‚ã‚‹ pgbench ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚ SQLæ¼”ç¿’å•é¡Œ å„ç« ã«ç”¨æ„ã•ã‚ŒãŸæ¼”ç¿’å•é¡Œã‚’é›†ã‚ã¾ã—ãŸã€‚
nextbigthing 2011/03/12
sql

DB
ãƒªãƒ³ã‚¯
SQUATãŒMacã§ã‚‚å‹•ã„ãŸ! - moroã®æ—¥è¨˜
SQLãƒ‰ãƒªãƒ«ãŒã‚ˆã†ã‚„ãè²·ãˆãŸã®ã§ã€ã•ã£ããç›®çŽ‰ã§ã‚ã‚‹SQUATã‚’è©¦ãã†ã€ã¨ã€‚ http://d.hatena.ne.jp/habuakihiro/20070522#1179811248 ã‚ãŸã—ã¯ Mac ãªã®ã§åŒæ¢±ã®ãƒãƒƒãƒãƒ•ã‚¡ã‚¤ãƒ«ã¯ä½¿ãˆãªã‹ã£ãŸã‚‚ã®ã®ã€Terminalã‹ã‚‰ä¸‹è¨˜ã®ã‚³ãƒžãƒ³ãƒ‰ã‚’å®Ÿè¡Œã—ã¦å•é¡Œãªãèµ·å‹•ã§ãã¾ã—ãŸã€‚ä½•å•ã‹è©¦ã—ã¦ã¿ã¾ã—ãŸãŒã€é †èª¿ã«å‹•ã„ã¦ã„ã‚‹æ¨¡æ§˜ã§ã™ã€‚Macã§å‹•ãã‹ã©ã†ã‹ä¸å®‰ãªã®ã§è²·ã„æŽ§ãˆã¦ã„ã‚‹ã€ã¨ã„ã†æ–¹ã¯ã”å®‰å¿ƒã‚’ã€‚ # å±•é–‹ã—ã¦ unzip squat-1.0.0.zip # ãã®ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã«ç§»å‹•ã—ã¦ cd squat-1.0.0 # javaã‚³ãƒžãƒ³ãƒ‰ã€‚ã“ã‚Œã ã‘ã€‚ java -cp data:squat.jar jp.towersquest.squat.Main ã„ã‚„ã€œã€ãªã‚“ã¨ã„ã†ã‹æ¥½ã—ã„ã€‚SQLã§ãƒ¬ãƒƒãƒ‰ã‚°ãƒªãƒ¼ãƒ³ã¯æ–°æ„Ÿè¦šã§ã™ã€‚Dockã‹ã‚‰ãƒ€ãƒ–ãƒ«ã‚¯ãƒªãƒƒã‚¯ã§èµ·å‹•ã§ãã‚‹ã‚ˆã†ã«
nextbigthing 2010/12/14
squat

mac

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

sql
ãƒªãƒ³ã‚¯
1