[B! sql] syo-yuã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

syo-yu id:syo-yu

sqlã«é–¢ã™ã‚‹syo-yuã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (26)

${{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 - karasuyamatenguã®æ—¥è¨˜
PostgeSQLã®ã‚³ã‚¢ãƒ¡ãƒ³ãƒãƒ¼Bruce MomjianãŒæ˜”æ›¸ã„ãŸã‚·ã‚§ãƒ«ã«ã‚ˆã‚‹SQLã‚¤ãƒ³ã‚¿ãƒ—ãƒªã‚¿ã®è©±ï¼š http://blog.andrewvc.com/before-postgresql-bruce-momjian-wrote-an-sql 760ãƒ©ã‚¤ãƒ³ã®å®Ÿè£…ã§CREATE, DELETE, DROP, INSERT, SELECT, UPDATE, WHERE, PRINT, EDITãªã©ã®ã‚³ãƒžãƒ³ãƒ‰ã‚’ã‚µãƒãƒ¼ãƒˆã™ã‚‹ã€‚ ã“ã‚“ãªé¢¨ã«ä½¿ãˆã‚‹ï¼š http://momjian.us/download/shql.1.3.demo.shql /pã¯ãƒ—ãƒªãƒ³ãƒˆ /gã¯Goã€ã¤ã¾ã‚Šã‚³ãƒžãƒ³ãƒ‰ã‚’å®Ÿè¡Œã™ã‚‹ã¨ã„ã†æ„å‘³ã ã¨æ€ã†ã€‚ ãƒ€ãƒ³ãƒãƒ¼ãƒ‰ã¯ã“ã“ã‹ã‚‰ï¼š http://momjian.us/download/ ä»Šæ—¥ã€å®Ÿç”¨æ€§ã¯ã‚ã¾ã‚Šãªã„ã‹ã‚‚ã—ã‚Œãªã„ã‘ã©ã‚·ã‚§ãƒ«ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã®å‹‰å¼·ææ–™ã«ãªã‚Šãã†ã€‚
syo-yu 2011/09/25
sql

shell
ãƒªãƒ³ã‚¯
Charming Python: Functional programming in Python, Part 3
syo-yu 2010/02/27
programming

tutorial

howto

database

article

sql

sqlite

introduction

databases
ãƒªãƒ³ã‚¯
mysql ã¨ drizzle ã®è² è·ãƒ†ã‚¹ãƒˆãƒ„ãƒ¼ãƒ«ã€Œskyloadã€ãŒå‡„ã„ï¼ - kazuhoã®ãƒ¡ãƒ¢ç½®ãå ´
tmaesakaã•ã‚“ãŒã‚„ã£ã¦ãã‚Œã¾ã—ãŸã€‚ ãšã„ã¶ã‚“å‰ã‹ã‚‰SQLã®ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã‚’æ¸¬å®šã™ã‚‹ã®ã«ä½¿ã„ã‚„ã™ã„ãƒ—ãƒã‚°ãƒ©ãƒ ãªã„ã‹ãªãƒ¼ã¨æ€ã£ã¦ã¾ã—ãŸã€‚å€‹äººçš„ã«ã¯mysqlslapã¨ã„ã†ã®ã‚’ä½¿ã£ã¦ãŸã®ã§ã™ãŒã€å¹¾ã‚‰ã‹æ°—ã«å…¥ã‚‰ãªã„æ‰€ãŒã‚ã£ãŸã‚Šã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ã‚ªãƒ—ã‚·ãƒ§ãƒ³ãŒè¤‡é›‘ã§æ¯Žå›ž --help ã‚’èªã‚“ã ã‚Šã—ã¦ã„ã¾ã—ãŸã€‚ä½™è¨ˆãªæ©Ÿèƒ½ãªã‚“ã‹ãªãã¦ã€æŒ‡å®šã—ãŸSQLã‚’é«˜é€Ÿã«ãã‚Šã‹ãˆã—ã¦ãã‚Œã‚‹ç‰©ãŒæ¬²ã—ã„ãªãã£ã¦æ€ã£ã¦ãŸã‚“ã§ã™ã€‚ ã¨ã‚ã‚‹IRCã§ã“ã®å‰ã€tmaesakaã•ã‚“ã‹ã‚‰ã€Œã„ã¾ä½œã£ã¦ã‚‹ã€ã¨ã„ã†è©±ã‚’èžã„ã¦ã€ã„ã‚ã„ã‚è¦æœ›ã‚’è¨€ã£ã¦ãŸã‚“ã§ã™ãŒã€ã¤ã„ã•ã£ããƒãƒ¥ãƒ¼ãƒˆãƒªã‚¢ãƒ«ãŒå…¬é–‹ã•ã‚Œã¾ã—ãŸã€‚é€Ÿã„w åå‰ã¯skyloadã€‚ã¨ã¦ã‚‚å°ã•ãã€å®Ÿè£…ã‚³ãƒ¼ãƒ‰ã ã¨800è¡Œç¨‹åº¦ã§ã™ã€‚ã—ã‹ã‚‚ã‚ªãƒ—ã‚·ãƒ§ãƒ³ãŒå°‘ãªã„ã®ã§ä½¿ã„æ–¹ãŒå˜ç´”ã§ã™ã€‚è©¦ã—ã«é©å½“ãª INSERT ã®é€Ÿåº¦ã‚’æ¸¬ã£ã¦ã¿ã¾ã—ãŸã€‚ $ skyload --server=localhost --mysql
syo-yu 2009/07/08
tools

tool

performance

database

debug

test

sql

mysql

db

todo
ãƒªãƒ³ã‚¯
Using filesort
åŽ»å¹´ã‚½ãƒ¼ãƒˆã«é–¢ã™ã‚‹è¨˜äº‹ã‚’æ›¸ã„ãŸãŒã€ä»Šæ—¥ã¯ãã®ç¶šãã§ã‚ã‚‹ã€‚ MySQLã§EXPLAIN SELECT...ã‚’å®Ÿè¡Œã™ã‚‹ã¨Extraãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã§ã‚ˆãè¦‹ã‹ã‘ã‚‹ã€ŒUsing filesortã€ã¨ã„ã†æ–‡å—åˆ—ã€‚Filesortã£ã¦ä¸€ä½“ãªã‚“ã ã‚ã†ï¼Ÿã¨æ€ã£ãŸã“ã¨ã¯ãªã„ã ã‚ã†ã‹ã€‚å˜åˆ€ç›´å…¥ã«è¨€ã£ã¦Filesortã®æ£ä½“ã¯ã‚¯ã‚¤ãƒƒã‚¯ã‚½ãƒ¼ãƒˆã§ã‚ã‚‹ã€‚ ã‚¯ã‚¨ãƒªã«ORDER BYãŒå«ã¾ã‚Œã‚‹å ´åˆã€MySQLã¯ã‚ã‚‹ç¨‹åº¦ã®å¤§ãã•ã¾ã§ã¯å…¨ã¦ãƒ¡ãƒ¢ãƒªå†…ã§ã‚¯ã‚¤ãƒƒã‚¯ã‚½ãƒ¼ãƒˆã‚’å‡¦ç†ã™ã‚‹ã€‚ã‚ã‚‹ç¨‹åº¦ã®å¤§ãã•ã¨ã¯sort_buffer_sizeã§ã‚ã‚Šã€ã“ã‚Œã¯ã‚»ãƒƒã‚·ãƒ§ãƒ³ã”ã¨ã«å¤‰æ›´å¯èƒ½ã§ã‚ã‚‹ã€‚ã‚½ãƒ¼ãƒˆã«å¿…è¦ãªãƒ¡ãƒ¢ãƒªãŒsort_buffer_sizeã‚ˆã‚Šå¤§ãããªã‚‹ã¨ã€ãƒ†ãƒ³ãƒãƒ©ãƒªãƒ•ã‚¡ã‚¤ãƒ«ï¼ˆãƒ†ãƒ³ãƒãƒ©ãƒªãƒ†ãƒ¼ãƒ–ãƒ«ã§ã¯ãªã„ï¼‰ãŒä½œæˆã•ã‚Œã€ãƒ¡ãƒ¢ãƒªã¨ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ä½µç”¨ã—ã¦ã‚¯ã‚¤ãƒƒã‚¯ã‚½ãƒ¼ãƒˆãŒå®Ÿè¡Œã•ã‚Œã‚‹ã€‚ Filesortã¯å…¨ã¦ã®ã‚½ãƒ¼ãƒˆå‡¦ç†ã«ãŠã„ã¦å®Ÿè¡Œã•ã‚Œã‚‹ã‚ã‘ã§ã¯ãªã„ã€‚å‰å›žã®è¨˜äº‹
syo-yu 2009/03/20
performance

database

sql

mysql

db

tuning

sort

rdbms
ãƒªãƒ³ã‚¯
ã‚¤ãƒ³ãƒ†ãƒ« ã‚³ãƒ³ãƒ‘ã‚¤ãƒ©ãƒ¼ã®å®ŸåŠ›ã‚’æ¸¬ã‚‹â€•â€•ã‚¤ãƒ³ãƒ†ãƒ« ã‚³ãƒ³ãƒ‘ã‚¤ãƒ©ãƒ¼ç‰ˆMySQLã¯æœ¬å½“ã«é€Ÿã„ã®ã‹ï¼Ÿ | OSDN Magazine
ã‚¤ãƒ³ãƒ†ãƒ«ãŒé–‹ç™ºã—ã¦ã„ã‚‹ã€Œã‚¤ãƒ³ãƒ†ãƒ« ã‚³ãƒ³ãƒ‘ã‚¤ãƒ©ãƒ¼ã€ã¯ã€ã‚¤ãƒ³ãƒ†ãƒ«CPUã«æœ€é©åŒ–ã•ã‚ŒãŸé«˜é€Ÿãªãƒã‚¤ãƒŠãƒªã‚’ç”Ÿæˆã™ã‚‹ã¨ã„ã†ã“ã¨ã§çŸ¥ã‚‰ã‚Œã¦ãŠã‚Šã€Oracleãªã©ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’æ±‚ã‚ã‚‹ãƒ™ãƒ³ãƒ€ãƒ¼ã§æŽ¡ç”¨ã•ã‚Œã¦ã„ã‚‹ã»ã‹ã€ç§‘å¦è¨ˆç®—ç”¨ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã€3Dã‚°ãƒ©ãƒ•ã‚£ãƒƒã‚¯ã‚½ãƒ•ãƒˆãªã©ã€ã•ã¾ã–ã¾ãªã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã®ã‚³ãƒ³ãƒ‘ã‚¤ãƒ«ã«åˆ©ç”¨ã•ã‚Œã¦ã„ã‚‹ã€‚ ã—ã‹ã—ã€ã€Œã‚¤ãƒ³ãƒ†ãƒ« ã‚³ãƒ³ãƒ‘ã‚¤ãƒ©ãƒ¼ã¯ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãŒé«˜ã„ã€ã¨ã ã‘è¨€ã‚ã‚Œã¦ã‚‚ã€ãªã‹ãªã‹ãƒ”ãƒ³ã¨æ¥ãªã„äººã‚‚å¤šã„ã®ã§ã¯ãªã„ã ã‚ã†ã‹ã€‚ãã“ã§ã€ã‚¤ãƒ³ãƒ†ãƒ« ã‚³ãƒ³ãƒ‘ã‚¤ãƒ©ãƒ¼ã§ã‚³ãƒ³ãƒ‘ã‚¤ãƒ«ã•ã‚ŒãŸãƒã‚¤ãƒŠãƒªã‚’ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ãƒ†ã‚¹ãƒˆã—ã€å®Ÿéš›ã©ã®ç¨‹åº¦ã®æ€§èƒ½å‘ä¸ŠãŒè¦‹è¾¼ã¾ã‚Œã‚‹ã®ã‹ã‚’èª¿ã¹ã¦ã¿ã‚ˆã†ã€‚ å„æ‰€ã§é«˜è©•ä¾¡ã‚’å—ã‘ã‚‹ã‚¤ãƒ³ãƒ†ãƒ« ã‚³ãƒ³ãƒ‘ã‚¤ãƒ©ãƒ¼ ã‚¤ãƒ³ãƒ†ãƒ« ã‚³ãƒ³ãƒ‘ã‚¤ãƒ©ãƒ¼ã¯CPUãƒ¡ãƒ¼ã‚«ãƒ¼ã§ã‚ã‚‹ã‚¤ãƒ³ãƒ†ãƒ«ãŒé–‹ç™ºã—ã¦ã„ã‚‹ã¨ã„ã†ã“ã¨ã§ã€Core i7ãªã©ã®æœ€æ–°CPUã«æè¼‰ã•ã‚Œã¦ã„ã‚‹SSE 4.2ã¨ã„ã£ãŸå‘½ä»¤ã‚»ãƒƒãƒˆã¸ã®å¯¾å¿œãŒå›³ã‚‰ã‚Œã¦ã„ã‚‹ã»ã‹ã€ã‚¤ãƒ³
syo-yu 2009/03/05
performance

sql

mysql

compiler

tuning

benchmark

Cluster

intel

icc
ãƒªãƒ³ã‚¯
æ¼¢(ã‚ªãƒˆã‚³)ã®ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿é“: MySQLã‚’é«˜é€ŸåŒ–ã™ã‚‹10ã®æ–¹æ³•
ã¡ã‚‡ã£ã¨ã‚ãƒ£ãƒƒãƒâˆ’ãªã‚¿ã‚¤ãƒˆãƒ«ã‚’ã¤ã‘ã¦ã—ã¾ã£ãŸãŒã€ä»Šæ—¥ã¯ç‹¬æ–ã¨åè¦‹ã§MySQLã‚’é«˜é€ŸåŒ–ã™ã‚‹æ–¹æ³•ã‚’10å€‹ç´¹ä»‹ã—ã‚ˆã†ã€‚MySQLã‚µãƒ¼ãƒã‚’ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã™ã‚‹ã¨ãã‚„åˆæœŸå°Žå…¥ã™ã‚‹å ´åˆãªã©ã«å‚è€ƒã«ã—ã¦ã‚‚ã‚‰ã„ãŸã„ã€‚ 1. ãƒãƒƒãƒ•ã‚¡ã‚’å¢—ã‚„ã™ã€ã¾ãŸã¯æ¸›ã‚‰ã™ ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®åŸºæœ¬ä¸ã®åŸºæœ¬ã§ã‚ã‚‹ãŒã€é©åˆ‡ãªãƒãƒƒãƒ•ã‚¡ã‚µã‚¤ã‚ºã‚’è¨å®šã™ã‚‹ã“ã¨ã¯ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®è¦ã§ã‚ã‚‹ã€‚ä¸»ãªãƒãƒƒãƒ•ã‚¡ã¯æ¬¡ã®é€šã‚Šã€‚ innodb_buffer_pool_sizeãƒ»ãƒ»ãƒ»InnoDBã ã‘ã‚’åˆ©ç”¨ã™ã‚‹å ´åˆã¯ç©ºããƒ¡ãƒ¢ãƒªã®7ã€œ8å‰²ç¨‹åº¦ã‚’å‰²ã‚Šå½“ã¦ã‚‹æœ€ã‚‚é‡è¦ãªãƒãƒƒãƒ•ã‚¡ã§ã‚ã‚‹ã€‚ä½™è«‡ã ãŒã€å®Ÿéš›ã«ã¯ã“ã“ã§å‰²ã‚Šå½“ã¦ãŸå€¤ã®5ã€œ10%ãã‚‰ã„ã‚’å¤šã‚ã«ãƒ¡ãƒ¢ãƒªã‚’ä½¿ã†ã®ã§æ³¨æ„ãŒå¿…è¦ã ã€‚ key_buffer_sizeãƒ»ãƒ»ãƒ»MyISAMã ã‘ã‚’åˆ©ç”¨ã™ã‚‹å ´åˆã¯ã€ç©ºããƒ¡ãƒ¢ãƒªã®3å‰²ç¨‹åº¦ã‚’å‰²ã‚Šå½“ã¦ã‚‹ã¨ã„ã„ã€‚æ®‹ã‚Šã¯ãƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†ãƒ ã®ã‚ãƒ£ãƒƒã‚·ãƒ¥ç”¨ã«æ®‹ã—ã¦ãŠã“ã†ã€‚ sort_buffer_
syo-yu 2009/02/25
optimize

tips

sql

mysql

db

tuning

performance
ãƒªãƒ³ã‚¯
PostgreSQL wiki
Welcome to the PostgreSQL Wiki! This wiki contains user documentation, how-tos, and tips 'n' tricks related to PostgreSQL. It also serves as a collaboration area for PostgreSQL contributors. User Documentation Frequently Asked Questions Community Generated Articles, Guides, and Documentation General articles and guides PostgreSQL Tutorials PostgreSQL Related Code Snippets Detailed installation gui
syo-yu 2008/08/17
xml

wiki

tutorial

tuning

sql

reference

postgresql

performance

howto

postgres
ãƒªãƒ³ã‚¯
Google Spreadsheets ã‚’ç°¡æ˜“ SQL DB ã«ï¼ã€ŒGoogle Visualization APIã€ - WebOS Goodies
WebOS Goodies ã¸ã‚ˆã†ã“ãï¼ WebOS ã¯ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆã®æœªæ¥å½¢ã€‚ã‚ã‚‰ã‚†ã‚‹ Web ã‚µã‚¤ãƒˆãŒç¹‹ãŒã‚Šã€å…±æœ‰ã—ã€å”åŠ›ã—ã¦å‰µã‚Šä¸Šã’ã‚‹ã€ã²ã¨ã¤ã®å·¨å¤§ãªæƒ…å ±ã‚·ã‚¹ãƒ†ãƒ ã§ã™ã€‚ãã“ã§ã¯ã€ã‚ã‚‰ã‚†ã‚‹æƒ…å ±ãŒãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ä¸Šã«è“„ç©ã•ã‚Œã€æˆ‘ã€…ã¯ã„ã¤ã§ã‚‚ã€ã©ã“ã‹ã‚‰ã§ã‚‚ã€å¤šå½©ãªãƒ‡ãƒã‚¤ã‚¹ã‚’ä½¿ã£ã¦ãã‚Œã‚‰ã«ã‚¢ã‚¯ã‚»ã‚¹ã§ãã¾ã™ã€‚ WebOS Goodies ã¯ã€ã•ã¾ã–ã¾ãªæƒ…å ±æä¾›ã‚„ãƒ„ãƒ¼ãƒ«é–‹ç™ºã‚’é€šã—ã¦ã€ãã‚“ãªä¸–ç•Œã®å®Ÿç¾ã«å°‘ã—ã§ã‚‚è²¢çŒ®ã™ã‚‹ã¹ãæ´»å‹•ã—ã¦ã„ãã¾ã™ã€‚ çš†ã•ã‚“ã€ Google Docs ã®ã‚¬ã‚¸ã‚§ãƒƒãƒˆæ©Ÿèƒ½ã¯ã‚‚ã†ä½¿ã£ã¦ã¿ã¾ã—ãŸã§ã—ã‚‡ã†ã‹ã€‚ãƒ‡ãƒ¼ã‚¿ã‚’ã•ã¾ã–ã¾ãªæ–¹æ³•ã§å¯è¦–åŒ–ã™ã‚‹ã‚¬ã‚¸ã‚§ãƒƒãƒˆã‚’ã‚·ãƒ¼ãƒˆä¸Šã«é…ç½®ã§ãã‚‹ã¨ã„ã†ã‚‚ã®ã§ã€ã“ã®ã‚¬ã‚¸ã‚§ãƒƒãƒˆã¯è‡ªä½œã™ã‚‹ã“ã¨ã‚‚ã§ãã¾ã™ï¼ˆiGoogle ã‚¬ã‚¸ã‚§ãƒƒãƒˆãƒ™ãƒ¼ã‚¹ï¼‰ã€‚ãã®éš›ã«ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã®æƒ…å ±ã‚’å–å¾—ã™ã‚‹ãŸã‚ã«ä½¿ã‚ã‚Œã‚‹ã®ãŒã€æœ¬æ—¥ã”ç´¹ä»‹ã™ã‚‹ Google Visualization API ã§
syo-yu 2008/04/08
google

api

database

sql

webservice

db

spreadsheet
ãƒªãƒ³ã‚¯
HTTP Server Test Page powered by CentOS-WebPanel.com
This page is used to test the proper operation of the HTTP server after it has been installed. If you can read this page it means that the HTTP server installed at this site is working properly. The fact that you are seeing this page indicates that the website you just visited is either experiencing probl ems or is undergoing routine maintenance. If you would like to let the administrators of this
syo-yu 2008/03/21
MySQL

software

osx

database

mac

Tools

sql

admin
ãƒªãƒ³ã‚¯
Mac OSXå‘ã‘SQLiteãƒ•ãƒãƒ³ãƒˆã‚¨ãƒ³ãƒ‰Â·SqliteQuery MOONGIFT
Rails2.0ã‹ã‚‰ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒSQLite3ã«ãªã£ãŸã€‚MySQLã®ã‚ˆã†ã«åˆ¥é€”ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ãŒä¸è¦ãªåˆ†ã€é–‹ç™ºãŒã•ã‚‰ã«å®¹æ˜“ã«ãªã£ãŸã¨è¨€ãˆã‚‹ã€‚SQLã‚’ã»ã¨ã‚“ã©åˆ©ç”¨ã™ã‚‹ã“ã¨ãŒãªã„ãŒã€ãã‚Œã§ã‚‚ä½•ã‚‚ãƒ•ãƒãƒ³ãƒˆã‚¨ãƒ³ãƒ‰ãŒãªã„ã®ã¯å¯‚ã—ã„ã€‚ ãã“ã§SQLã‚’å®Ÿè¡Œã™ã‚‹ã®ã¿ã§ã¯ã‚ã‚‹ãŒã€ã“ã‚Œã‚’ä½¿ã£ã¦ã¿ã‚‹ã®ã¯ã©ã†ã ã‚ã†ã‹ã€‚ ä»Šå›žç´¹ä»‹ã™ã‚‹ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ»ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã¯SqliteQueryã€SQLite3ãƒ•ãƒãƒ³ãƒˆã‚¨ãƒ³ãƒ‰ã ã€‚ SqliteQueryã¯Mac OSXå‘ã‘ã®ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã€SQLã‚’å®Ÿè¡Œã—ã€ãã®çµæžœã‚’è¡¨ç¤ºã™ã‚‹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã ã€‚SQLite3è‡ªä½“ã¯ç®¡ç†æ©Ÿèƒ½ãªã©ã¯æŒã¡åˆã‚ã›ãªã„ã®ã§ã€ååˆ†ã¨è¨€ãˆã°ååˆ†ãã†ã ã€‚ãŸã ã—ãƒ†ãƒ¼ãƒ–ãƒ«ä¸€è¦§ãªã©ãŒã¨ã‚Œãªã„ã®ãŒè¾›ã„ã€‚ åŸºæœ¬çš„ã«ã¯ä½•ã‚‰ã‹ã®SQLã‚’å®Ÿè¡Œã—ã¦ã€ãã®çµæžœã‚’è¡¨ç¤ºã™ã‚‹ã¨è¨€ã†ã“ã¨ã«ãªã‚‹ã€‚CREATE TABLEã€INSERTã€SELECTãªã©ã€å„ç¨®SQLã¯ãã®ã¾ã¾åˆ©ç”¨ã§ãã‚‹
syo-yu 2008/03/12
sqlite

tool

osx

mac

db

sql

MacOSX
ãƒªãƒ³ã‚¯
Emacs ã§ SQL ã‚’æ•´å½¢ã™ã‚‹ â€” ã‚ã‚Šãˆã‚‹ãˆã‚Šã‚
perltidy ã‚’ä½¿ã£ã¦ã¿ãŸã‚Š(*)ã€ elisp ã‚’ä½¿ã£ã¦ã¿ãŸã‚Šã—ã¦ SQL ã‚’æ•´å½¢ã™ã‚‹æ–¹æ³•ã‚’æ¨¡ç´¢ã—ã¦ã„ã¾ã—ãŸãŒã€æœ€çµ‚çš„ã«å°‚ç”¨ã®ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ã‚’ä½¿ã†ã®ãŒä¸€ç•ªã†ã¾ãã„ã£ãŸã®ã§ã€ãã‚Œã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ (*) æ–‡å—åˆ—é€£çµæ¼”ç®—åã®æ”¹è¡Œã®æ‰±ã„ã‚’ã†ã¾ãåˆ¶å¾¡ã§ããªã‹ã£ãŸ ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ã®æº–å‚™ ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ã¨ã—ã¦ blancoSql Formatter ã¨ã„ã†ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‚’ä½¿ã„ã¾ã™(*)ã€‚ (*) http://sourceforge.jp/projects/blancofw/files/?release_id=27764#27764 Java ã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã§ã™ã€‚ä¼‘æ—¥ãƒãƒƒã‚¯ã« Java ã‚’ä½¿ã†ã¨ã™ã”ãä¸æ„‰å¿«ã«ãªã‚‹ã®ã¯ãªãœã§ã—ã‚‡ã†ã‹ã€‚ã¾ã‚ã„ã„ã§ã™ã€‚ % mkdir ~/opt % unzip balcoSql Formatter-0.1.0.src.zip -d ~/opt Java ã®ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã‚’æ›¸ãã¾ã™ã€‚ ~
syo-yu 2007/12/24
emacs

sql
ãƒªãƒ³ã‚¯
MySQLã‚¯ã‚¤ãƒƒã‚¯ãƒ»ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹
ã“ã®æ–‡æ›¸ã¯ã€osCommerceã§ä½¿ç”¨ã—ã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹MySQLã®åŸºæœ¬çš„ãªä½¿ã„æ–¹ã«ã¤ã„ã¦è§£èª¬ã—ã¦ã„ã¾ã™ã€‚ãŠã‚‚ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ç®¡ç†è€…ã‚ˆã‚Šã‚‚ã€ãƒ¦ãƒ¼ã‚¶ã«å‘ã‘ã¦æ›¸ã‹ã‚Œã¦ã„ã¾ã™ã€‚ ã¯ã˜ã‚ã« ã“ã“ã§ã¯ã€MySQLã‚µãƒ¼ãƒã¯èµ·å‹•ã—ã¦ã„ã‚‹ã‚‚ã®ã¨ã—ã¦èª¬æ˜Žã—ã¾ã™ã€‚ MySQLã®æ–‡å—ã«ã¤ã„ã¦ MySQLã§ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åã‚„ãƒ†ãƒ¼ãƒ–ãƒ«åã®å¤§æ–‡å—ã¨å°æ–‡å—ã‚’åŒºåˆ¥ã—ã¦ã„ã¾ã™ã€‚ãã‚Œä»¥å¤–ã¯åŒºåˆ¥ã—ã¾ã›ã‚“ã€‚ MySQLã®ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰åã‚„ãƒ†ãƒ¼ãƒ–ãƒ«åã«ä½¿ãˆã‚‹æ–‡å—ã¯ã€è‹±æ•°å—ã¨_ï¼ˆã‚¢ãƒ³ãƒ€ãƒ¼ãƒãƒ¼ï¼‰ã€$ã€ã‚µãƒ¼ãƒã®ã‚ãƒ£ãƒ©ã‚¯ã‚¿ã‚»ãƒƒãƒˆã«ã‚ã‚‹æ–‡å—ã§ã™ã€‚ çŸ¥ã£ã¦ãŠããŸã„ã‚³ãƒžãƒ³ãƒ‰ mysqladminï¼ˆãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä½œæˆãƒ»å‰Šé™¤ã‚„ã€MySQLã‚µãƒ¼ãƒã®æƒ…å ±ã‚’å¾—ã‚‹ï¼‰ mysqlshowï¼ˆãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã®æƒ…å ±ã‚’è¡¨ç¤ºã™ã‚‹ï¼‰ mysqlï¼ˆMySQLã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã®èµ·å‹•ï¼‰ mysqldumpï¼ˆãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ãƒ€ãƒ³ãƒ—ã™ã‚‹ï¼‰ myisamchkï¼ˆãƒ†ãƒ¼ãƒ–ãƒ«
syo-yu 2007/12/15
mysql

reference

database

db

sql

software

tips
ãƒªãƒ³ã‚¯
15ç¨®é¡žã®SQL Injectionãƒ„ãƒ¼ãƒ«è©•ä¾¡
ã“ã“ã®ã¨ã“ã‚ã€ã„ãã¤ã‹ã®SQL Injectionãƒ„ãƒ¼ãƒ«ã«ã¤ã„ã¦èª¿ã¹ã¦ã„ã¾ã—ãŸã€‚ä»Šæ—¥ã¯ãã®çµæžœã‚’æ—¥è¨˜ã«æ›¸ã„ã¦ã¿ã‚ˆã†ã¨æ€ã„ã¾ã™ã€‚ ã¯ã˜ã‚ã« SQL Injectionãƒ„ãƒ¼ãƒ«ã¨ã¯ SQL Injectionè„†å¼±æ€§ã®ç™ºè¦‹ã¨ã€ç™ºè¦‹ã—ãŸè„†å¼±æ€§ã‚’çªã„ã¦ã®DBå†…æƒ…å ±ã®å–å¾—ã‚’è¡Œãªã†ãŸã‚ã®ãƒ„ãƒ¼ãƒ«ã§ã™ã€‚ ãŸã ã—ã€å¤šãã®ãƒ„ãƒ¼ãƒ«ã§ã¯ã€Œè„†å¼±æ€§ã®ç™ºè¦‹ã€ã¯ãŠã¾ã‘ã§ã€å¾Œè€…ã®DBå†…æƒ…å ±ã®å–å¾—ã«ä¸»çœ¼ã‚’ç½®ã„ã¦ã„ã¾ã™ã€‚ä¸€èˆ¬çš„ã«ã¯ã€æ±Žç”¨ã®Webè„†å¼±æ€§ã‚¹ã‚ãƒ£ãƒŠãªã©ã§è„†å¼±æ€§ã‚’è¦‹ã¤ã‘ã¦ã€ãã®è„†å¼±æ€§ã«å¯¾ã—ã¦ã“ã®æ—¥è¨˜ã«æ›¸ã„ã¦ã„ã‚‹ã‚ˆã†ãªãƒ„ãƒ¼ãƒ«ã‚’ä½¿ã£ã¦æƒ…å ±ã‚’å–å¾—ã™ã‚‹ã¨ã„ã†ä½¿ã„æ–¹ã‚’ã™ã‚‹ã“ã¨ãŒå¤šã„ã§ã—ã‚‡ã†ã€‚ SQL Injectionãƒ„ãƒ¼ãƒ«ã¯ã€ã„ã‚ã‚†ã‚‹Hackingãƒ„ãƒ¼ãƒ«ã§ã™ã€‚è„†å¼±æ€§æ¤œæŸ»ã‚’è¡Œãªã†è€…ã‹ã€ã•ã‚‚ãªã‘ã‚Œã°Crackingã‚’è¡Œãªã†çŠ¯ç½ªè€…ãŒä½¿ã†ãã‚‰ã„ã§ã€ä¸€èˆ¬ã®Webé–‹ç™ºè€…ã‚„ãƒ¦ãƒ¼ã‚¶ã®äººãŒä½¿ã†å¿…è¦ã«è¿«ã‚‰ã‚Œã‚‹ã“ã¨ã¯ç„¡ã„ã§ã—ã‚‡ã†ã€‚ ãƒ„ãƒ¼ãƒ«ã®ä½¿ç”¨ã«éš›ã—ã¦
syo-yu 2007/12/04
SQL

security

testing
ãƒªãƒ³ã‚¯
SQLã®åŸºç¤Ž ã€ŒSELECTã€æ–‡ã‚’è¦šãˆã‚ˆã†
æœ¬è¨˜äº‹ã®ãŠã‚‚ãªå†…å®¹ ã„ã‚ã„ã‚ã‚ã‚‹SQLã®è¦æ ¼ ã‚µãƒ³ãƒ—ãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ“ä½œã—ã¦ã¿ã‚‹ SELECTæ–‡ã®åŸºæœ¬çš„ãªä½¿ã„æ–¹ WHEREå¥ã®ä½¿ã„æ–¹ æ¡ä»¶ã®æŒ‡å®šæ–¹æ³• ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚·ã‚¹ãƒ†ãƒ ï¼ˆRDBMSï¼‰ã‚‚ã€ä»Šã‚„ã€ã‚·ã‚¹ãƒ†ãƒ ã®æ§‹ç¯‰ã«ã¯ä¸å¯æ¬ ãªã‚‚ã®ã¨ãªã‚Šã¾ã—ãŸã€‚çš†ã•ã‚“ãŒç›®ã«ã—ã¦ã„ã‚‹ã‚·ã‚¹ãƒ†ãƒ ã‚„ã€ç®¡ç†ã—ã¦ã„ã‚‹ã‚·ã‚¹ãƒ†ãƒ ã§ã‚‚ã€RDBMSãŒä½¿ã‚ã‚Œã¦ã„ãªã„ã‚·ã‚¹ãƒ†ãƒ ã‚’æŽ¢ã™ã»ã†ãŒå¤§å¤‰ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚RDBMSã®æ™®åŠã«ã¨ã‚‚ãªã„ã€RDBMSã¸ã®ã‚¢ã‚¯ã‚»ã‚¹æ‰‹æ®µã§ã‚ã‚‹SQLã‚‚ã€æ—¥å¸¸çš„ã«ã‚ˆãè¦‹ã‹ã‘ã‚‹ã‚‚ã®ã¨ãªã‚Šã¾ã—ãŸã€‚ ã“ã®SQLå®Ÿè·µè¬›åº§ã§ã¯ã€SQLã®åŠ¹çŽ‡çš„ãªä½¿ã„æ–¹ã‚’ã‚¨ãƒƒã‚»ãƒ³ã‚¹ã«ã—ã¦ãŠä¼ãˆã—ã¦ã„ã“ã†ã¨è€ƒãˆã¦ã„ã¾ã™ã€‚SQLã¯ã€ãƒ‡ãƒ¼ã‚¿ã‚’æ“ä½œã™ã‚‹ãŸã‚ã«éžå¸¸ã«ç°¡å˜ãªæ§‹æ–‡ã§æ§‹æˆã•ã‚Œã¦ã„ã‚‹ã‚ˆã†ã«è¦‹ãˆã¾ã™ã€‚ã¨ã“ã‚ãŒã€å®Ÿéš›ã«ä½¿ã„è¾¼ã‚“ã§ã„ãã¨ã€ä¸€è¦‹ç°¡å˜ã«å–å¾—ã§ãã‚‹ã‚ˆã†ã«è¦‹ãˆã‚‹ãƒ‡ãƒ¼ã‚¿ãŒå–å¾—ã§ããªã„å ´é¢ã«ã¶ã¡å½“ãŸã‚‹ã“ã¨ãŒã‚ã‚‹ã¨æ€ã„ã¾ã™ã€‚ã¾ãŸé€†ã«
syo-yu 2007/09/09
SQL

DATABASE

tutorial

programming

study

web

tech
ãƒªãƒ³ã‚¯
SQLã§æœ¨ã¨éšŽå±¤æ§‹é€ ã®ãƒ‡ãƒ¼ã‚¿ã‚’æ‰±ã†â€•â€•å…¥ã‚Œåé›†åˆãƒ¢ãƒ‡ãƒ«
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
syo-yu 2007/09/01
sql

database

db

tree

tips

design

programming
ãƒªãƒ³ã‚¯
ActiveRecordã§æ¤œç´¢ - SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³å¯¾ç– - ã†ãªã®æ—¥è¨˜
SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã®è„†å¼±æ€§ã‚’ãªãã™ãŸã‚ã€findã§ã®æ¤œç´¢æ¡ä»¶ã®æŒ‡å®šæ–¹æ³•ã«ã¯æ³¨æ„ãŒå¿…è¦ã§ã™ã€‚ Ã—ã€Œ:conditions=>"name = '" + name + "'"ã€ã®ã‚ˆã†ã«æ¡ä»¶ã‚’è‡ªå‰ã§ä½œæˆã™ã‚‹ã®ã¯å±é™ºã€‚ â—‹ã€Œ:conditions=>"name = ?", nameã€ã‚„ã€Œ:conditions=>{:name=>name}ã€ã¨ã™ã‚Œã°å®‰å…¨ã€‚ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã‚’è‡ªå‹•ã§ã‚µãƒ‹ã‚¿ã‚¤ã‚¸ãƒ³ã‚°ã—ã¦ãã‚Œã¾ã™ã€‚ â—‹find_by_* ã‚‚å®‰å…¨ã€‚ ãƒ‡ãƒ¼ã‚¿: mysql> select * from kittens; +----+-------+-------+------+ | id | name | color | age | +----+-------+-------+------+ | 1 | mii | gray | 1 | | 2 | tora | brown | 2 | | 3 | kuro | b
syo-yu 2007/06/10
activerecord

ruby

sql

security
ãƒªãƒ³ã‚¯
SELECTæ–‡ã®å¯èªæ€§ã‚’é«˜ã‚ã‚‹ãŸã‚ã«å¿ƒãŒã‘ã¦ã„ã‚‹ã“ã¨ - Enjoy*Study
SELECTæ–‡ã¨ã„ã£ã¦ã‚‚ã€å˜ä¸€ãƒ†ãƒ¼ãƒ–ãƒ«ã—ã‹ä½¿ã‚ãªã„ã‚ˆã†ãªSQLã§ã¯ãªãã¦ã€è¤‡æ•°ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’çµåˆã™ã‚‹ã‚ˆã†ãªå ´åˆã«ã€æ°—ã‚’ã¤ã‘ã¦ã„ã‚‹ã“ã¨ã‚’æ›¸ãå‡ºã—ã¦ã¿ã¾ã™ã€‚ USINGå¥ã‚ˆã‚ŠONå¥ã‚’ä½¿ã† 2ã¤ã®ãƒ†ãƒ¼ãƒ–ãƒ«ãªã‚‰ã°ã€ãã‚Œã»ã©æ°—ã«ã¯ãªã‚Šã¾ã›ã‚“ãŒã€3ã¤ä»¥ä¸Šã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’çµåˆã™ã‚‹éš›ã«ã¯ã€ONå¥ã§æŒ‡å®šã—ãŸåˆ—ãŒã€ã©ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã®åˆ—ã«ã‹ã‹ã£ã¦ãã¦ã„ã‚‹ã‹ã‚ã‹ã‚‰ãªããªã‚Šã¾ã™ã€‚ ãªã®ã§ã€ã‚¿ã‚¤ãƒ—é‡ãŒå¢—ãˆã‚‹ã¨ã—ã¦ã‚‚ã€ONå¥ã‚’ä½¿ã†ã‚ˆã†ã«ã—ã¦ã„ã¾ã™ã€‚ USINGã®å ´åˆ SELECT u.user_id, u.name, p.password, d.name FROM user u LEFT JOIN pass p USING(user_id) LEFT JOIN dep d USING(dep_id) ONå¥ã®å ´åˆ SELECT u.user_id, u.name, p.password, d.name FROM user u LE
syo-yu 2007/06/07
coding

sql

programming

tips
ãƒªãƒ³ã‚¯
CocoaMySQL - A MySQL GUI for Mac OS X
This project has been abandoned. Its source code has been used to create a new project called "Sequel Pro": http://code.google.com/p/sequel-pro/
syo-yu 2007/04/21
administration

application

applications

bookmarks

cocoa

coding

computer

console

opensource

sql
ãƒªãƒ³ã‚¯
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
syo-yu 2007/03/17
sql

security

injection

cheatsheet

database

mysql

reference
ãƒªãƒ³ã‚¯
https://sqlitebrowser.sourceforge.net/screenshots.html
syo-yu 2007/01/25
SQLite

SQL

database

desktop

db

Free

software

Source

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