[B! SQL] the-dayã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

the-day id:the-day

SQLã«é–¢ã™ã‚‹the-dayã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (24)

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

Cassandraå…¥é–€ã¨ã€ã•ã‚‰ã«è©³ã—ãçŸ¥ã‚‹ãŸã‚ã®ãƒªã‚½ãƒ¼ã‚¹é›†
ã‚¯ãƒ©ã‚¦ãƒ‰æ™‚ä»£ã®æ–°ã—ã„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦ã€éžãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãªæ§‹é€ ã‚’æŒã¤NoSQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒè©±é¡Œã«ãªã£ã¦ã„ã¾ã™ï¼ˆNoSQLï¼Not Only SQLã€‚å‘½åã®çµŒç·¯ã¯ã“ã¡ã‚‰ï¼‰ã€‚ãã®NoSQLã®ä¸ã§ã€ã‚‚ã£ã¨ã‚‚æ³¨ç›®ã•ã‚Œã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®1ã¤ãŒApacheã®Cassandraã§ã™ã€‚ Cassandraã¯ã€Facebookã§å¤§è¦æ¨¡ãƒ‡ãƒ¼ã‚¿å‡¦ç†ã®ãŸã‚ã«é–‹ç™ºã•ã‚Œã€ãã®å¾Œã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã¨ãªã‚Šã€ç¾åœ¨ã§ã¯Apache Software Foundationã®ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã¨ã—ã¦é–‹ç™ºã•ã‚Œã¦ã„ã¾ã™ã€‚ ç¾åœ¨ã€Cassandraã¯Facebookã‚„Diggãªã©ã§ä½¿ã‚ã‚Œã¦ã„ã‚‹ã€ã‚‚ã—ãã¯ä½¿ã†ã“ã¨ãŒæ¤œè¨Žã•ã‚Œã¦ã„ã‚‹ã¨ã•ã‚Œã€Twitterã§ã‚‚ï¼ˆãƒ„ã‚¤ãƒ¼ãƒˆãƒ‡ãƒ¼ã‚¿ã®æ ¼ç´ã«ã¯ä½¿ã‚ã‚Œãªã„ã‚ˆã†ã§ã™ãŒã€ãã‚Œä»¥å¤–ã®ç”¨é€”ã§ï¼‰åˆ©ç”¨ã•ã‚Œã¦ã„ã¾ã™ã€‚ Twitterã¨DiggãŒNoSQLã®ã€ŒCassandraã€ã‚’é¸ã¶ç†ç”± TwitterãŒã€Cassandr
the-day 2010/08/01
cloudcomputing

sql

architechture

introduction

ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹

è³‡æ–™
ãƒªãƒ³ã‚¯
PHPã§ã®ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£å¯¾ç–ã«ã¤ã„ã¦ã®ãƒ¡ãƒ¢ - Liner Note
the-day 2009/04/16
security

php

programming

development

sql

ã¾ã¨ã‚

webåˆ¶ä½œ
ãƒªãƒ³ã‚¯
å¾³ä¸¸æµ©ã®æ—¥è¨˜ - ãã‚ãã‚SQLã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ã«é–¢ã—ã¦ä¸€è¨€ã„ã£ã¨ãã‹ - SQLã®ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—å†è€ƒ
è£œè¶³ ã“ã®è¨˜äº‹ã¯æ—§å¾³ä¸¸æµ©ã®æ—¥è¨˜ã‹ã‚‰ã®è»¢è¼‰ã§ã™ã€‚å…ƒURLã€ã‚¢ãƒ¼ã‚«ã‚¤ãƒ–ã€ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯1ã€ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯2ã€‚ å‚™å¿˜ã®ãŸã‚è»¢è¼‰ã„ãŸã—ã¾ã™ãŒã€ã“ã®è¨˜äº‹ã¯2007å¹´11æœˆ26æ—¥ã«å…¬é–‹ã•ã‚ŒãŸã‚‚ã®ã§ã€å½“æ™‚ã®å¾³ä¸¸ã®è€ƒãˆã‚’ç¤ºã™ã‚‚ã®ã‚’ã€åŸºæœ¬çš„ã«å†…å®¹ã‚’å¤‰æ›´ã›ãšã«ãã®ã¾ã¾è»¢è¼‰ã™ã‚‹ã‚‚ã®ã§ã™ã€‚ è£œè¶³çµ‚ã‚ã‚Š æœ¬ç¨¿ã§ã¯SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³å¯¾ç–ã¨ã—ã¦ã€SQLã®ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—å‡¦ç†ã®æ–¹æ³•ã«ã¤ã„ã¦æ¤œè¨Žã™ã‚‹ã€‚ æœ€è¿‘SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³æ”»æ’ƒãŒçŒ›å¨ã‚’æŒ¯ã‚‹ã£ã¦ã„ã‚‹ã“ã¨ã‚‚ã‚ã‚Šã€SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã«å¯¾ã™ã‚‹è§£èª¬è¨˜äº‹ãŒå¢—ãˆã¦ããŸã‚ˆã†ã ãŒã€å¯¾ç–æ–¹æ³•ã«ã¤ã„ã¦ã¯ååˆ†ã«æ›¸ã‹ã‚Œã¦ã„ãªã„ã‚ˆã†ã«æ„Ÿã˜ã‚‹ã€‚éžå¸¸ã«ç¨€ãªã‚±ãƒ¼ã‚¹ã®å¯¾å¿œãŒä¸ååˆ†ã ã¨è¨€ã£ã¦ã„ã‚‹ã®ã§ã¯ãªã„ã€‚ã”ãåŸºæœ¬çš„ãªã“ã¨ãŒååˆ†æ›¸ã‹ã‚Œã¦ã„ãªã„ã¨æ€ã†ã®ã ã€‚ SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³å¯¾ç–ã«ã¯äºŒé€šã‚Šã‚ã‚‹ã€‚ãƒã‚¤ãƒ³ãƒ‰æ©Ÿæ§‹ã‚’ä½¿ã†ã‚‚ã®ã¨ã€SQLã®ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ã«ã‚ˆã‚‹ã‚‚ã®ã ã€‚ã“ã®ã†ã¡ã€SQLã®ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ã«ã¤ã„ã¦ã€ååˆ†
the-day 2008/09/15
SQL

security

DB

database

programming

development

webåˆ¶ä½œ
ãƒªãƒ³ã‚¯
ç‰¹é›†:åŸºç¤Žã‹ã‚‰ç†è§£ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã—ãã¿ - ç‰¹é›†:åŸºç¤Žã‹ã‚‰ç†è§£ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã—ãã¿ï¼šITpro
ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ãƒ–ãƒ©ãƒƒã‚¯ãƒœãƒƒã‚¯ã‚¹ã€‚ã©ã‚“ãªSQLæ–‡ã‚’æŠ•ã’ãŸã‚‰ã©ã‚“ãªçµæžœãŒè¿”ã£ã¦ãã‚‹ã‹ã•ãˆçŸ¥ã£ã¦ã„ã‚Œã°ã‚ˆã„ã€---ãã†æ€ã£ã¦ã„ã‚‹äººã‚‚å¤šã„ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚ ã—ã‹ã—ï¼Œæœ¬ç‰©ã®ã‚½ãƒ•ãƒˆã‚¦ã‚¨ã‚¢ãƒ»ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã‚’ç›®æŒ‡ã™ã®ã§ã‚ã‚Œã°ï¼Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒå‹•ãä»•çµ„ã¿ã‚’å¦ã¶ã“ã¨ã¯é¿ã‘ã¦é€šã‚Œã¾ã›ã‚“ã€‚ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãªã©ã«å•é¡ŒãŒç”Ÿã˜ãŸã¨ãã©ã“ã‹ã‚‰æ‰‹ã‚’ä»˜ã‘ã¦ã„ã„ã®ã‹çš†ç›®è¦‹å½“ãŒã¤ã‹ãªã„ï¼Œã¨ã„ã£ãŸäº‹æ…‹ã«é™¥ã‚Šã‹ãã¾ã›ã‚“ã€‚ å¸‚è²©ã®RDBMSã®å†…éƒ¨ã¯ã‹ãªã‚Šè¤‡é›‘ã§ã™ãŒï¼ŒåŸºæœ¬çš„ãªéƒ¨åˆ†ã‚’ç†è§£ã™ã‚‹ã®ã¯ãã‚Œã»ã©é›£ã—ãã‚ã‚Šã¾ã›ã‚“ã€‚ã“ã®ç‰¹é›†ã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å‹•ãä»•çµ„ã¿ã‚’ç†è§£ã—ã¦ãã ã•ã„ã€‚ ã‚¤ãƒ³ãƒˆãƒ â—ãƒ–ãƒ©ãƒƒã‚¯ãƒœãƒƒã‚¯ã‚¹ã®ã¾ã¾ã§ã„ã„ã®ï¼Ÿ åŸºç¤Žã‹ã‚‰ç†è§£ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã—ãã¿ï¼ˆ1ï¼‰ ï¼°ï½ï½’ï½”ï¼‘ â—SQLæ–‡ã¯ã©ã®ã‚ˆã†ã«å®Ÿè¡Œã•ã‚Œã‚‹ã®ã‹ åŸºç¤Žã‹ã‚‰ç†è§£ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã—ãã¿ï¼ˆ2ï¼‰ åŸºç¤Žã‹ã‚‰ç†è§£ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã—ãã¿ï¼ˆ3ï¼‰ åŸºç¤Žã‹ã‚‰ç†è§£ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã—ãã¿ï¼ˆ4ï¼‰ åŸº
the-day 2007/12/17
***

ã¾ã¨ã‚

DB

sql

programming

development

webåˆ¶ä½œ

è³‡æ–™

study

tutorial
ãƒªãƒ³ã‚¯
HTMLã®è¦ç´ ã‚’SQLã®ã‚ˆã†ã«å–ã‚Šå‡ºã›ã‚‹PHPã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã€ŽhtmlSQLã€ | IDEA*IDEA
ãƒ‰ãƒƒãƒˆã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ä»£è¡¨ã®ãƒ©ã‚¤ãƒ•ãƒãƒƒã‚¯ãƒ–ãƒã‚°
the-day 2007/11/28
sql

html

php

library

programming

development

webåˆ¶ä½œ

webã‚µãƒ¼ãƒ“ã‚¹
ãƒªãƒ³ã‚¯
SQLã‚’è‰²ã‚“ãªå½¢å¼ã§æ•´å½¢ã§ãã‚‹ã€ŒInstant SQL Formatterã€:phpspoté–‹ç™ºæ—¥èªŒ
Instant SQL Formatter SQLã‚’è‰²ã‚“ãªå½¢å¼ã§æ•´å½¢ã§ãã‚‹ã€ŒInstant SQL Formatterã€ã€‚ å…¥åŠ›ã—ãŸï¼³ï¼±ï¼¬ã‚’HTMLã§åˆ†ã‹ã‚Šã‚„ã™ãã‚«ãƒ©ãƒ¼ãƒªãƒ³ã‚°ï¼†æ•´å½¢ã—ãŸã‚Šã€C#ã‚„Delphiã€PHPãªã©ã®è¨€èªžã§ä½¿ãˆã‚‹ã‚ˆã†ã«å¤‰æ›ã™ã‚‹ã“ã¨ãŒå¯èƒ½ã§ã™ã€‚ æ¬¡ã®ã‚ˆã†ã«ã€é•·ãƒ¼ãƒ¼ã„ï¼³ï¼±ï¼¬æ–‡ãŒã‚ã£ãŸã¨ã—ã¦ã‚‚æ•´å½¢ã—ã¦è¦‹ã‚„ã™ãã™ã‚‹ã“ã¨ãŒå‡ºæ¥ã¾ã™ã€‚ select i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.t ype#,i.flags,i.property,i.pctfree$,i.initrans,i.ma xtrans,i.blevel,i.leafcnt,i.distkey,i.lblkkey,i.db lkkey,i.clufac,i.cols,i.analyzetime,i.samplesize,i .dataobj#,nvl(i.degree,
the-day 2007/10/12
generator

format

SQL

tool

DB

development

programming

useful
ãƒªãƒ³ã‚¯
ã‚¦ãƒŽã‚¦ãƒ©ãƒœ Unoh Labs: ãƒ–ãƒ©ã‚¦ã‚¶ã§ERå›³ãŒæã‘ã‚‹ã€ŒWWW SQL Designerã€ç´¹ä»‹
GT Nitro: Car Game Drag Raceã¯ã€å…¸åž‹çš„ãªã‚«ãƒ¼ã‚²ãƒ¼ãƒ ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ã“ã‚Œã¯ã‚¹ãƒ”ãƒ¼ãƒ‰ã€ãƒ‘ãƒ¯ãƒ¼ã€ã‚¹ã‚ãƒ«å…¨é–‹ã®ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã‚²ãƒ¼ãƒ ã§ã™ã€‚ãƒ–ãƒ¬ãƒ¼ã‚ã¯å¿˜ã‚Œã¦ã€ã“ã‚Œã¯ãƒ‰ãƒ©ãƒƒã‚°ãƒ¬ãƒ¼ã‚¹ã€ãƒ™ã‚¤ãƒ“ãƒ¼ï¼å¤å…¸çš„ãªã‚¯ãƒ©ã‚·ãƒƒã‚¯ã‹ã‚‰æœªæ¥çš„ãªãƒ“ãƒ¼ã‚¹ãƒˆã¾ã§ã€æœ€ã‚‚ã‚¯ãƒ¼ãƒ«ã§é€Ÿã„è»Šã¨ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã§ãã¾ã™ã€‚ã‚¹ãƒ†ã‚£ãƒƒã‚¯ã‚·ãƒ•ãƒˆã‚’ãƒžã‚¹ã‚¿ãƒ¼ã—ã€ãƒ‹ãƒˆãƒã‚’è³¢ãä½¿ã£ã¦ç«¶äº‰ã‚’æ‰“ã¡ç ´ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ã“ã®ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã‚²ãƒ¼ãƒ ã¯ãã®ãƒªã‚¢ãƒ«ãªç‰©ç†å¦ã¨ç´ æ™´ã‚‰ã—ã„ã‚°ãƒ©ãƒ•ã‚£ãƒƒã‚¯ã‚¹ã§ã‚ãªãŸã®å¿ƒã‚’çˆ†ç™ºã•ã›ã¾ã™ã€‚ã“ã‚Œã¾ã§ãƒ—ãƒ¬ã‚¤ã—ãŸã“ã¨ã®ãªã„ã‚ˆã†ãªã‚‚ã®ã§ã™ã€‚ GT Nitroã¯ã€ãƒªãƒ•ãƒ¬ãƒƒã‚¯ã‚¹ã¨ã‚¿ã‚¤ãƒŸãƒ³ã‚°ã‚’è©¦ã™ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã‚²ãƒ¼ãƒ ã§ã™ã€‚æ£ã—ã„çž¬é–“ã«ã‚®ã‚¢ã‚’ã‚·ãƒ•ãƒˆã—ã€ã‚¬ã‚¹ã‚’æ€ã„åˆ‡ã‚Šè¸ã‚€å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ã¾ãŸã€å¤§ç‰©ãŸã¡ã¨ç«¶ã„ã¤ã¤ã€è»Šã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¨ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ã‚‚è¡Œã‚ãªã‘ã‚Œã°ãªã‚Šã¾ã›ã‚“ã€‚ä¸–ç•Œä¸ã§æœ€é«˜ã®ãƒ‰ãƒ©ã‚¤ãƒãƒ¼ã¨è»Šã¨ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã«æŒ‘ã‚€ã“ã¨ã«ãªã‚Šã€ãƒ‰ãƒ©ãƒƒã‚°ãƒ¬ãƒ¼ã‚¹ã®çŽ‹å†
the-day 2007/10/07
generator

SQL

DB

ER

webã‚µãƒ¼ãƒ“ã‚¹

MySQL

development

programming
ãƒªãƒ³ã‚¯
InnoDB ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° - MySQLã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹2007 - akiyan.com ç®¡ç†äººãƒ¡ãƒ¢
http://www.mysql-ucj2007.jp/details/j25.html æœ¨ä¸‹ é–æ–‡ æ° NTTã‚³ãƒ ã‚¦ã‚§ã‚¢æ ªå¼ä¼šç¤¾ ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆç®¡ç†çµ±æ‹¬éƒ¨æŠ€è¡“SEéƒ¨é–€ DB æŠ€è¡“ã‚°ãƒ«ãƒ¼ãƒ— ï¼ˆã€ŒInnoDBã€ã¯ã€Œã„ã‚“ã®ã§ãƒ¼ã³ãƒ¼ã€ã¨è¨€ã†ã‚‰ã—ã„...ä»Šã¾ã§ã€Œã„ã®ã§ãƒ¼ã³ãƒ¼ã€ã¨è¨€ã£ã¦ã¾ã—ãŸï¼‰ InnoDBã‚’ãªãœä½¿ã†ã‹ ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ ã‚³ãƒŸãƒƒãƒˆã€ãƒãƒ¼ãƒ«ãƒãƒƒã‚¯ã€ã‚»ãƒ¼ãƒ–ãƒã‚¤ãƒ³ãƒˆ å¤–éƒ¨ã‚ãƒ¼ è¡Œãƒ¬ãƒ™ãƒ«ãƒãƒƒã‚¯ ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— ã‚¯ãƒ©ãƒƒã‚·ãƒ¥ãƒªã‚«ãƒãƒª ã‚¯ãƒ©ãƒƒã‚·ãƒ¥ãƒªã‚«ãƒãƒª MyISAMã¯ãƒ‡ãƒ¼ã‚¿é‡ã®å¢—å¤§ã¨ã¨ã‚‚ã«æ™‚é–“ãŒã‹ã‹ã‚‹ InnoDBã¯ãƒ‡ãƒ¼ã‚¿é‡ã®å¢—å¤§ã¨ã®ç›¸é–¢ãŒãªã„ InnoDBãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®çŽ‹é“çš„ã‚¢ãƒ—ãƒãƒ¼ãƒ ã‚¯ã‚¨ãƒªã‚’æ”¹å–„ã—ã¦å…¨ä½“çš„ã«å‡¦ç†åŠ¹çŽ‡ã‚’ä¸Šã’ã‚‹ ãƒ‡ãƒ¼ã‚¿ã‚µã‚¤ã‚ºã‚’ã§ãã‚‹ã ã‘å°ã•ã ãƒ¡ãƒ¢ãƒªã‚’ã§ãã‚‹ã ã‘å¤šãç©ã‚€ ã‚³ãƒŸãƒƒãƒˆæ€§èƒ½ï¼ˆåŒæœŸæ›¸ãè¾¼ã¿ï¼‰ innodb_flush_log_at_trx_commit=1,0,2
the-day 2007/09/15
DB

MySQL

performance

server

tuning

sql

programming

development
ãƒªãƒ³ã‚¯
æœ€çŸã‹ã¤æœ€é€Ÿã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã€ŒDBé«˜é€ŸåŒ–æŠ€è¡“ã€ï¼ˆå‰ç·¨ï¼‰ï¼šITpro
ãƒã‚¤ãƒ³ãƒˆ ãƒ»é«˜åº¦ãªã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚„ã‚¸ãƒ§ã‚¤ãƒ³ã‚’åˆ©ç”¨ã—ï¼Œæœ€çŸçµŒè·¯ã§ãƒ‡ãƒ¼ã‚¿ã«ã‚¢ã‚¯ã‚»ã‚¹ ãƒ»ãƒ¡ãƒ¢ãƒªãƒ¼ä¸è¶³ã‚’è‡ªå¾‹çš„ã«è§£æ¶ˆã—ï¼Œã‚ãƒ£ãƒƒã‚·ãƒ¥ã®ãƒ’ãƒƒãƒˆçŽ‡ã‚’é«˜ã‚ã‚‹ ãƒ»ã‚¤ãƒ³ãƒ¡ãƒ¢ãƒªãƒ¼DBã¯å…¨ãƒ‡ãƒ¼ã‚¿ã‚’ãƒ¡ãƒ¢ãƒªãƒ¼ã§å‡¦ç†ã—ï¼Œé«˜é€ŸåŒ–ã‚’å›³ã‚‹ ç›®çš„åœ°ã«æ—©ãåˆ°ç€ã—ãŸã„ãªã‚‰ï¼Œæœ€çŸã®çµŒè·¯ã‚’æœ€é€Ÿã§è¡Œã‘ã°ã‚ˆã„ã€‚ã“ã‚Œã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼ˆDBï¼‰ã§ã‚‚åŒæ§˜ã ï¼ˆå›³1ï¼‰ã€‚ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãªã©ã‚’ä½¿ã£ã¦ãƒ‡ãƒ¼ã‚¿ã¸ã®æœ€çŸçµŒè·¯ã‚’è¦‹ã¤ã‘ï¼Œãƒ¡ãƒ¢ãƒªãƒ¼ãƒ»ã‚¢ã‚¯ã‚»ã‚¹ã‚’å¢—ã‚„ã—ã¦ï¼Œæœ€é€Ÿã§ãŸã©ã‚Šç€ãã€‚DBã«ã¯ãã‚“ãªæŠ€è¡“ãŒè©°ã¾ã£ã¦ã„ã‚‹ã€‚ å›³1â—ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é«˜é€ŸåŒ–æŠ€è¡“ã®ãƒã‚¤ãƒ³ãƒˆ ãƒ“ãƒƒãƒˆãƒžãƒƒãƒ—ãƒ»ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãªã©ã‚’ä½¿ã„ã€ãƒ‡ãƒ¼ã‚¿ã«ãŸã©ã‚Šç€ãæœ€çŸã®é“ã‚’é¸ã¶ã€‚ã¾ãŸã€ã§ãã‚‹ã ã‘ãƒ¡ãƒ¢ãƒªãƒ¼ã«ãƒ‡ãƒ¼ã‚¿ã‚’ã‚ãƒ£ãƒƒã‚·ãƒ¥ã•ã›ã¦ãŠãã“ã¨ã§ã€ã‚¢ã‚¯ã‚»ã‚¹ã®ã‚¹ãƒ”ãƒ¼ãƒ‰ã‚’ä¸Šã’ã‚‹ã€ã¨ã„ã†äºŒã¤ã®ãƒã‚¤ãƒ³ãƒˆãŒã‚ã‚‹ [ç”»åƒã®ã‚¯ãƒªãƒƒã‚¯ã§æ‹¡å¤§è¡¨ç¤º] ä»¥ä¸‹ã§ã¯ï¼Œï¼ˆ1ï¼‰ãƒ‡ãƒ¼ã‚¿ã«ãŸã©ã‚Šç€ãæœ€çŸã®é“ã‚’é¸ã¶ä»•çµ„ã¿ã¨ï¼Œï¼ˆ2ï¼‰ã‚¢ã‚¯ã‚»ã‚¹ã®ã‚¹ãƒ”ãƒ¼ãƒ‰ã‚’ä¸Šã’ã‚‹ä»•çµ„ã¿ã®
the-day 2007/09/13
DB

performance

sql

tips

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

algorithm

programming

development

DB
ãƒªãƒ³ã‚¯
ãƒ—ãƒãŒä½œã£ãŸé»’çŒ«å°ã®ãƒ•ãƒªãƒ¼ã‚½ãƒ•ãƒˆ é»’çŒ«ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢å·¥æˆ¿ (å¼•ã£è¶Šã—ã¾ã—ãŸ)
â– æœ€æ–°æƒ…å ± é»’çŒ«ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢å·¥æˆ¿ã®ãƒ›ãƒ¼ãƒ ãƒšãƒ¼ã‚¸ã¯å¼•ã£è¶Šã—ã¾ã—ãŸã€‚ æ–°ã—ã„ãƒ›ãƒ¼ãƒ ãƒšãƒ¼ã‚¸ã¯ã“ã¡ã‚‰ â†’ http://kuronekosoft.ewinds.net/ 5ç§’å¾Œã«è‡ªå‹•çš„ã«ã‚¸ãƒ£ãƒ³ãƒ—ã—ã¾ã™ã€‚ é»’çŒ« SQLÂ Studio ã¯ã€ã‚ã‚‰ã‚†ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æŽ¥ç¶šå¯èƒ½ãªæ±Žç”¨SQLé–‹ç™ºç’°å¢ƒã§ã™ã€‚é»’çŒ« SQLÂ Studio ã«ã¯ã€SQLã‚’æ‰‹æ—©ãä½œã‚‹ãŸã‚ã®å…¥åŠ›æ”¯æ´æ©Ÿèƒ½ã‚„ã€ä½œã£ãŸSQLã‚’ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã¨ã—ã¦ç®¡ç†ã™ã‚‹æ©Ÿèƒ½ãŒç”¨æ„ã•ã‚Œã¦ã„ã¾ã™ã€‚ â– é»’çŒ« SQL StudioÂ ã«ã¤ã„ã¦çŸ¥ã‚ŠãŸã„ â†’ é»’çŒ« SQL Studio â– é»’çŒ« SQL StudioÂ ã‚’ç´¹ä»‹ã—ã¦ã„ãŸã ãã¾ã—ãŸ â†’ SQLæ–‡ã‚’GUIã§ä½œæˆã§ãã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é–‹ç™ºç’°å¢ƒ... - çª“ã®æœ â†’ ä½¿ã„ã‚„ã™ã„SQLå®Ÿè¡Œç’°å¢ƒ... - Unofficial DB2 BLOG â†’ ã©ã‚“ãªDBã‚‚GUIã§SQLä½œæˆ... - Hibiæ—¥è¨˜ â†’ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é–‹ç™ºã®å¿…éœ€å“
the-day 2007/08/30
DB

SQL

software

generator

tool

free

useful

MySQL
ãƒªãƒ³ã‚¯
çª“ã®æœ - ã€NEWSã€‘SQLæ–‡ã‚’GUIã§ä½œæˆã§ãã‚‹ãƒ•ãƒªãƒ¼ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é–‹ç™ºç’°å¢ƒã€Œé»’çŒ« SQL Studioã€
GUIã«ã‚ˆã‚‹SQLæ–‡ã®ä½œæˆãªã©ã€ã•ã¾ã–ã¾ãªé–‹ç™ºæ”¯æ´æ©Ÿèƒ½ã‚’å‚™ãˆã‚‹SQLé–‹ç™ºç’°å¢ƒã€Œé»’çŒ« SQL Studioã€v1.1.7.413ãŒ6æœˆ4æ—¥ã«å…¬é–‹ã•ã‚ŒãŸã€‚Windows 2000/XPã«å¯¾å¿œã—ã¦ãŠã‚Šã€å€‹äººä½¿ç”¨ãƒ»æ¥å‹™ã«ã‹ã‹ã‚ã‚‰ãšãƒ•ãƒªãƒ¼ã‚½ãƒ•ãƒˆã¨ã—ã¦åˆ©ç”¨å¯èƒ½ã€‚ç¾åœ¨ä½œè€…ã®ãƒ›ãƒ¼ãƒ ãƒšãƒ¼ã‚¸ã‹ã‚‰ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã§ãã‚‹ã€‚ ã€Œé»’çŒ« SQL Studioã€ã¯ã€SQLæ–‡ã®ä½œæˆã‚„ãƒ†ã‚¹ãƒˆã‚’è¡Œãˆã‚‹æ±Žç”¨ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é–‹ç™ºç’°å¢ƒã€‚æœ¬ã‚½ãƒ•ãƒˆä¸Šã‹ã‚‰OLE DBæŽ¥ç¶šã¾ãŸã¯ODBCãƒ‰ãƒ©ã‚¤ãƒã«å¯¾å¿œã™ã‚‹å„ç¨®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¸ç›´æŽ¥æŽ¥ç¶šå¯èƒ½ã§ã€ä½œæˆã—ãŸSQLæ–‡ã‚’å®Ÿéš›ã«ãƒ†ã‚¹ãƒˆå®Ÿè¡Œã§ãã‚‹ã€‚ç”»é¢ã¯3ãƒšã‚¤ãƒ³æ§‹æˆã§ã€å·¦å´ã«ã¯è¤‡æ•°ã®SQLã‚½ãƒ¼ã‚¹ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ç®¡ç†ã§ãã‚‹ãƒ•ã‚¡ã‚¤ãƒ©ãƒ¼ã€ä¸å¤®ã«ã¯è¤‡æ•°ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ã‚¿ãƒ–ã§åˆ‡ã‚Šæ›¿ãˆã¦è¡¨ç¤ºã§ãã‚‹ã‚¨ãƒ‡ã‚£ã‚¿ãƒ¼ã€å³å´ã«ã¯æŽ¥ç¶šã—ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ§‹é€ ã‚’ãƒ„ãƒªãƒ¼ã¨ãƒªã‚¹ãƒˆã§è¡¨ç¤ºã™ã‚‹â€œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ã‚¯ã‚¹ãƒ—ãƒãƒ¼ãƒ©â€ãŒè¡¨ç¤ºã•ã‚Œã‚‹ã€‚ SQLæ–‡ã®ä½œæˆæ™‚ã¯ã€ã•ã¾ã–
the-day 2007/08/30
DB

SQL

software

generator

tool

free

useful

MySQL
ãƒªãƒ³ã‚¯
ã‚¦ãƒŽã‚¦ãƒ©ãƒœ Unoh Labs: MySQL5ã‹ã‚‰ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹çµåˆã§ï¼‘ãƒ†ãƒ¼ãƒ–ãƒ«è¤‡æ•°ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ã†
GT Nitro: Car Game Drag Raceã¯ã€å…¸åž‹çš„ãªã‚«ãƒ¼ã‚²ãƒ¼ãƒ ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ã“ã‚Œã¯ã‚¹ãƒ”ãƒ¼ãƒ‰ã€ãƒ‘ãƒ¯ãƒ¼ã€ã‚¹ã‚ãƒ«å…¨é–‹ã®ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã‚²ãƒ¼ãƒ ã§ã™ã€‚ãƒ–ãƒ¬ãƒ¼ã‚ã¯å¿˜ã‚Œã¦ã€ã“ã‚Œã¯ãƒ‰ãƒ©ãƒƒã‚°ãƒ¬ãƒ¼ã‚¹ã€ãƒ™ã‚¤ãƒ“ãƒ¼ï¼å¤å…¸çš„ãªã‚¯ãƒ©ã‚·ãƒƒã‚¯ã‹ã‚‰æœªæ¥çš„ãªãƒ“ãƒ¼ã‚¹ãƒˆã¾ã§ã€æœ€ã‚‚ã‚¯ãƒ¼ãƒ«ã§é€Ÿã„è»Šã¨ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã§ãã¾ã™ã€‚ã‚¹ãƒ†ã‚£ãƒƒã‚¯ã‚·ãƒ•ãƒˆã‚’ãƒžã‚¹ã‚¿ãƒ¼ã—ã€ãƒ‹ãƒˆãƒã‚’è³¢ãä½¿ã£ã¦ç«¶äº‰ã‚’æ‰“ã¡ç ´ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ã“ã®ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã‚²ãƒ¼ãƒ ã¯ãã®ãƒªã‚¢ãƒ«ãªç‰©ç†å¦ã¨ç´ æ™´ã‚‰ã—ã„ã‚°ãƒ©ãƒ•ã‚£ãƒƒã‚¯ã‚¹ã§ã‚ãªãŸã®å¿ƒã‚’çˆ†ç™ºã•ã›ã¾ã™ã€‚ã“ã‚Œã¾ã§ãƒ—ãƒ¬ã‚¤ã—ãŸã“ã¨ã®ãªã„ã‚ˆã†ãªã‚‚ã®ã§ã™ã€‚ GT Nitroã¯ã€ãƒªãƒ•ãƒ¬ãƒƒã‚¯ã‚¹ã¨ã‚¿ã‚¤ãƒŸãƒ³ã‚°ã‚’è©¦ã™ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã‚²ãƒ¼ãƒ ã§ã™ã€‚æ£ã—ã„çž¬é–“ã«ã‚®ã‚¢ã‚’ã‚·ãƒ•ãƒˆã—ã€ã‚¬ã‚¹ã‚’æ€ã„åˆ‡ã‚Šè¸ã‚€å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ã¾ãŸã€å¤§ç‰©ãŸã¡ã¨ç«¶ã„ã¤ã¤ã€è»Šã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¨ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ã‚‚è¡Œã‚ãªã‘ã‚Œã°ãªã‚Šã¾ã›ã‚“ã€‚ä¸–ç•Œä¸ã§æœ€é«˜ã®ãƒ‰ãƒ©ã‚¤ãƒãƒ¼ã¨è»Šã¨ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã«æŒ‘ã‚€ã“ã¨ã«ãªã‚Šã€ãƒ‰ãƒ©ãƒƒã‚°ãƒ¬ãƒ¼ã‚¹ã®çŽ‹å†
the-day 2007/07/16
sql

DB

tuning

index

MySQL

é‹ç”¨

webåˆ¶ä½œ
ãƒªãƒ³ã‚¯
ã„ã¾ã®æ°—æŒã¡ã‚’SQLã§è¡¨ã™ã‚¹ãƒ¬:ã‚¢ãƒ«ãƒ•ã‚¡ãƒ«ãƒ•ã‚¡ãƒ¢ã‚¶ã‚¤ã‚¯
Begin transaction Select *ã€€into ä¿º from å†·è”µåº« where ç¨®é¡ž='é…’' order by ã‚¢ãƒ«ã‚³ãƒ¼ãƒ«åº¦æ•° Select *ã€€into ä¿º from å†·è”µåº« where ç¨®é¡ž='é…’' order by ã‚¢ãƒ«ã‚³ãƒ¼ãƒ«åº¦æ•° Select *ã€€into ä¿º from å†·è”µåº« where ç¨®é¡ž='é…’' order by ã‚¢ãƒ«ã‚³ãƒ¼ãƒ«åº¦æ•° Goto ä¾¿æ‰€ ä¾¿æ‰€: Rollback INSERTINTOãƒžãƒ³ã‚³VALUES(æ¼ã‚Œã®ãƒ‰ãƒªãƒ«ãƒãƒ³ãƒ) INSERTINTOãƒžãƒ³ã‚³VALUES(æ¼ã‚Œã®ãƒ‰ãƒªãƒ«ãƒãƒ³ãƒ) INSERTINTOãƒžãƒ³ã‚³VALUES(æ¼ã‚Œã®ãƒ‰ãƒªãƒ«ãƒãƒ³ãƒ) INSERTINTOãƒžãƒ³ã‚³VALUES(æ¼ã‚Œã®ãƒ‰ãƒªãƒ«ãƒãƒ³ãƒ) INSERTINTOãƒžãƒ³ã‚³VALUES(æ¼ã‚Œã®ãƒ‰ãƒªãƒ«ãƒãƒ³ãƒ) INSERTINTOãƒžãƒ³ã‚³VALUES(æ¼ã‚Œã®ç²¾æ¶²)
the-day 2007/06/18
sql

DB

ãƒã‚¿
ãƒªãƒ³ã‚¯
SQLã§é›†åˆæ¼”ç®—ï¼šCodeZine
ã¯ã˜ã‚ã«ã€€SQLãŒé›†åˆè«–ã«ç«‹è„šã™ã‚‹è¨€èªžã§ã‚ã‚‹ã¨ã„ã†ã“ã¨ã¯ã€ã“ã®é€£è¼‰ã§ä¸€è²«ã—ã¦å¼·èª¿ã—ã¦ããŸãƒ†ãƒ¼ãƒžã®ä¸€ã¤ã§ã™ã€‚ãã®ç‰¹æ€§ã®ã‚†ãˆã«ã€SQLã¯ã€Œé›†åˆæŒ‡å‘è¨€èªžã€ã¨å‘¼ã°ã‚Œã¦ã„ã¾ã™ã—ã€å®Ÿéš›ã€é›†åˆçš„ãªè¦³ç‚¹ã‹ã‚‰è¦‹ãŸã¨ãã«åˆã‚ã¦ã€ãã®å¼·åŠ›ã•ãŒç†è§£ã§ãã‚‹ã¨ç§ã¯è€ƒãˆã¦ã„ã¾ã™ã€‚ã—ã‹ã—ç¾å®Ÿã«ã¯ã€SQLã®ã“ã®å´é¢ã¯é•·ã‚‰ãç„¡è¦–ã•ã‚Œã¦ãã¾ã—ãŸã€‚ã€€ãã®èƒŒæ™¯ã«ã¯ã€SQLã«ã‚‚è²¬ä»»ã®ä¸€ç«¯ãŒã‚ã‚Šã¾ã™ã€‚ã¨ã„ã†ã®ã‚‚ã€SQLã¯ã¡ã‚‡ã£ã¨å‰ã¾ã§ã€é«˜æ ¡ã§ç¿’ã†ç¨‹åº¦ã®åŸºæœ¬çš„ãªé›†åˆæ¼”ç®—åã™ã‚‰æŒã£ã¦ã„ãªã‹ã£ãŸã‹ã‚‰ã§ã™ã€‚å’Œï¼ˆUNIONï¼‰ã“ãSQL-86ã‹ã‚‰ã®å¤å‚ã§ã™ãŒã€äº¤å·®ï¼ˆINTERSECTï¼‰ã¨å·®ï¼ˆEXCEPTï¼‰ãŒæ¨™æº–ã«å…¥ã£ãŸã®ã¯SQL-92ã§ã™ã—ã€é™¤ç®—ï¼ˆDIVIDE BYï¼‰ãŒæœªã ã«æ¨™æº–åŒ–ã•ã‚Œã¦ã„ãªã„ã“ã¨ã¯ã€å‰ã«ã‚‚è¿°ã¹ã¾ã—ãŸã€‚ã ã‹ã‚‰ã€SQLãŒè¨€èªžã¨ã—ã¦ä¸å®Œå…¨ã ã¨ã„ã†æ‰¹åˆ¤ã¯ã€ç†ç”±ã®ãªã„ã‚‚ã®ã§ã¯ãªã‹ã£ãŸã®ã§ã™ã€‚ã€€ã—ã‹ã—ã€ç¾åœ¨ã§ã¯æ¨™æº–SQLã«åŸºæœ¬çš„ãªé›†åˆæ¼”ç®—å
the-day 2007/06/16
sql

DB

mysql

programming

development
ãƒªãƒ³ã‚¯
ç„¡æ–™ã§ä½¿ãˆã‚‹SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³å¯¾ç–ã‚¹ã‚ãƒ£ãƒŠã€€ãƒˆãƒƒãƒ—ï¼‘ï¼•*ãƒ›ãƒ¼ãƒ ãƒšãƒ¼ã‚¸ã‚’ä½œã‚‹äººã®ãƒã‚¿å¸³
the-day 2007/06/11
sql

security

DB

development

tips

useful
ãƒªãƒ³ã‚¯
SQLæ–‡ã‚’ãã‚Œã„ã«ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆã—ã¦ãã‚Œã‚‹ã€ŽSQL in Formã€ | POP*POP
é•·ï½žã„SQLæ–‡ã‚’è¦‹ã¦ã„ã‚‹ã¨ã©ã“ãŒã©ã†ã„ã†æ§‹é€ ã«ãªã£ã¦ã„ã‚‹ã®ã‹ãŒã‚ã‹ã‚‰ãªããªã£ã¦ãã¾ã™ã‚ˆãã€‚ ãã†ã—ãŸã¨ãã«ä½¿ãˆãã†ãªã®ãŒã€ŒSQL in Formã€ã§ã™ã€‚ ä¸€èˆ¬å‘ã‘ã®ã‚µãƒ¼ãƒ“ã‚¹ã§ã¯ãªã„ã§ã™ãŒã€é–¢ä¿‚ã‚ã‚‹æ–¹ã«ã¯ä¾¿åˆ©ãªã®ã§ã¯ã€‚ ä»¥ä¸‹ã«ç°¡å˜ã«ã”ç´¹ä»‹ã€‚ â†‘ ãŸã¨ãˆã°ã“ã®ã‚ˆã†ãªSQLæ–‡ã€‚ã‚³ãƒ¡ãƒ³ãƒˆåˆ†ã‚„ã‚¤ãƒ³ãƒ‡ãƒ³ãƒˆãŒã‚ã‹ã‚Šã«ãããªã£ã¦ã„ã¾ã™ã€‚ â†‘ SQL in Formã‚’é€šã›ã°ã“ã®é€šã‚Šã€‚æ§‹é€ ãŒã™ã£ãã‚Šã—ã¦è¦‹ã‚„ã™ã„ã§ã™ãã€‚ å¤‰æ›ã™ã‚‹éš›ã«ã¯æ”¹è¡Œã‚„ã‚¤ãƒ³ãƒ‡ãƒ³ãƒˆã€ç©ºç™½ã®æ‰±ã„ãªã©ã®è¨å®šã‚’ã™ã‚‹ã“ã¨ã‚‚ã§ãã¾ã™ã€‚ã¾ãŸãƒ‡ã‚¹ã‚¯ãƒˆãƒƒãƒ—ç”¨ã®ã‚¢ãƒ—ãƒªã‚‚ã‚ã‚‹ã¿ãŸã„ã§ã™ãã€‚ ã”åˆ©ç”¨ã¯ä»¥ä¸‹ã‹ã‚‰ã©ã†ãžã€‚ç„¡æ–™ã§ä½¿ãˆã¾ã™ã€‚ Â» SQL Formatter / SQL Formatter formats SQL Statements
the-day 2007/06/09
generator

sql

programming

development

DB

webã‚µãƒ¼ãƒ“ã‚¹

useful

tips
ãƒªãƒ³ã‚¯
suVeneã®ã‚ã‚Œ: ä¿ºçš„ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ãƒ«ãƒ¼ãƒ« SQLç·¨
2007å¹´01æœˆ19æ—¥ ä¿ºçš„ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ãƒ«ãƒ¼ãƒ« SQLç·¨ ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã®ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ãƒ«ãƒ¼ãƒ«ãŒã“ã†ã§ãªã‘ã‚Œã°ã„ã‘ãªã„ã¨ã‹ã€ä»–äººã«å¼·åˆ¶ã™ã‚‹ã‚ã‘ã§ã¯ãªã„ãŒã€è‡ªåˆ†è‡ªèº«ã§ä¸€è²«æ€§ã®ç„¡ã„ã‚³ãƒ¼ãƒ‰ã‚’æ›¸ãã®ã¯æ°—æŒã¡æ‚ªã„ã®ã§ã€ã‚ªãƒ¬ã‚ªãƒ¬ãƒ«ãƒ¼ãƒ«ã‚’æ±ºã‚ã¦ãŸã‚Šã™ã‚‹ã€‚å¤§æŠµã¯ ãƒ‡ãƒ»ãƒ•ã‚¡ã‚¯ãƒˆçš„ãªãƒ«ãƒ¼ãƒ«ã«æ²¿ã†å½¢ã§æ›¸ãã“ã¨ãŒå¤šã„ã®ã ãŒã€SQL ã‚„ PL/SQL ã«é–¢ã—ã¦ã¯ãªã‹ãªã‹ãƒ‡ãƒ•ã‚¡ã‚¯ãƒˆã¨å‘¼ã¹ã‚‹ã‚‚ã®ãŒãªã„ã®ã§(ã‚ã‚‹ã®ã‹?)ã€ãƒ¡ãƒ¢çš„ã«æ›¸ãã¨ã‚ã¦ãŠãã€‚ åŽŸå‰‡ã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰å°æ–‡å—ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆåå¤§æ–‡å—ã‚«ãƒ³ãƒžã¯å¾Œã‚ã‚¤ãƒ³ãƒ‡ãƒ³ãƒˆã¯åŠè§’ã‚¹ãƒšãƒ¼ã‚¹ã§ 2ä¸€ã¤ã® SQL æ–‡ã§ã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰æ¯Žã«ã‚¤ãƒ³ãƒ‡ãƒ³ãƒˆã—ãªã„(å‰¯å•åˆã›é™¤ã) ã¾ãšã€1.2. ã«ä»˜ã„ã¦ãªã®ã ãŒã€æ˜”ã¯ã€Œã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰ï¼å¤§æ–‡å—ã€ã¨ã„ã†æ„å‘³ä¸æ˜Žãªå…ˆå…¥è¦³ã§å¤§æ–‡å—ã§æ›¸ã„ã¦ã„ãŸã€‚ãŸã ã€ãã‚Œã ã¨ PL/SQL ã®ã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰ã‚‚å¤§æ–‡å—ã€ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆåã‚‚å¤§æ–‡å—ã§çµå±€ã»ã¨ã‚“ã©å¤§æ–‡å—ã«ãªã£ã¦ã—ã¾ã†ã®ã¨ã€Shift æŠ¼ã™
the-day 2007/01/28
DB

SQL

code
ãƒªãƒ³ã‚¯
mysql ã‚’é«˜é€ŸåŒ–ã—ãŸã„ã¨ãã«èªã‚€ãƒ¡ãƒ¢ (TechKnowledge)
çµ¦æ–™ã®æŒ¯è¾¼å£åº§ã¨ã—ã¦ä¸‰äº•ä½å‹éŠ€è¡Œã«å£åº§ã‚’æŒã£ã¦ã„ã¾ã™ã€‚è‡ªå‹•æ”¯æ‰•ã„ã‚µãƒ¼ãƒ“ã‚¹ã‚’ä½¿ç”¨ã—ã¦å…‰ç†±è²»ç‰ã®å…¬å…±æ–™é‡‘ã®æ”¯æ‰•ã„ã‚’ã—ã¦ã„ã¾ã™ãŒã€å…ˆæ—¥ãã‚Œã‚‰ã®å†…ã®ä¸€ã¤ã‚’å¤±å¿µã—ã¦ãŸã“ã¨ã«æ°—ã¥ãã¾ã—ãŸã€‚å£åº§ã‚’ç¢ºèªã—ãŸæ™‚ã«ã¯ã™ã§ã«å¼•ãè½ã¨ã—ãŒå®Œäº†ã—ã¦ã„ãŸãŸã‚ã€æ‰‹å…ƒã®è³‡é‡‘ãŒå¿ƒç´°ããªã£ãŸçŠ¶æ…‹ã§æ•°æ—¥ã‚’éŽã”ã•ãªã‘ã‚Œã°ãªã‚Šã¾ã›ã‚“ã€‚ä¸‰äº•ä½å‹éŠ€è¡Œã§å³æ—¥ã‚ãƒ£ãƒƒã‚·ãƒ³ã‚°ãŒå¯èƒ½ã§ã‚ã‚Œã°ã€æ˜¯éžåˆ©ç”¨ã—ãŸã„ã®ã§ã™ãŒã€‚ é‹ãŒè‰¯ã‘ã‚Œã°ã€ä¸‰äº•ä½å‹éŠ€è¡Œã®å³æ—¥ã‚ãƒ£ãƒƒã‚·ãƒ³ã‚°ã¯å¯èƒ½ ä¸‰äº•ä½å‹éŠ€è¡Œã®ç‰¹å¾´ã¯ã¾ãšã‚¯ãƒ¬ã‚¸ãƒƒãƒˆã‚«ãƒ¼ãƒ‰ä¼šç¤¾ã¨ã®é€£æºã—ãŸã‚µãƒ¼ãƒ“ã‚¹ãŒé…åŠ›çš„ãªã“ã¨ãŒã‚ã’ã‚‰ã‚Œã¾ã™ã€‚ã‚ãƒ£ãƒƒã‚·ãƒ³ã‚°ã§ã¯éŠ€è¡Œã‚«ãƒ¼ãƒ‰ãƒãƒ¼ãƒ³ã§ã™ã‹ã‚‰ã€ä½•ã‚ˆã‚Šå®‰ã„é‡‘åˆ©ãŒå¤§ãã„åˆ©ç‚¹ã«ãªã‚Šã¾ã™ã€‚æ¦‚ãéŠ€è¡Œç³»ã®å¯©æŸ»ã«å¿…è¦ãªæ™‚é–“ã¯é•·ããªã‚‹ã‚ˆã†ã§ã™ãŒã€ä¸‰äº•ä½å‹éŠ€è¡Œã§ã¯ã‚«ãƒ¼ãƒ‰ç™ºè¡ŒãŒå½“æ—¥ã«è¡Œãªã£ã¦ãã‚Œã¾ã™ã€‚ ä¸‰äº•ä½å‹éŠ€è¡Œã¯å³æ—¥ã‚ãƒ£ãƒƒã‚·ãƒ³ã‚°ãŒã§ãã‚‹ã‹ã¨è¨€ã†ã¨å¾®å¦™ãªã“ã¨ã«ãªã‚Šã¾ã™ã€‚ç”³è¾¼ã‹ã‚‰å¯©æŸ»çµæžœã®é€£çµ¡ã¾ã§ã¯ã€åœŸæ—¥
the-day 2006/11/27
DB

MySQL

mysql

sql

tuning

performance

tips
ãƒªãƒ³ã‚¯
ä»Šå¤œåˆ†ã‹ã‚‹SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³å¯¾ç– â€• ï¼ IT
ã€é–¢é€£è¨˜äº‹ã€‘ æœ¬å†…å®¹ã«ã¤ã„ã¦ã®ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆè¨˜äº‹ã‚’å…¬é–‹ã—ã¦ã„ã¾ã™ã€‚ã‚ã‚ã›ã¦ã”ç¢ºèªãã ã•ã„ï¼ˆç·¨é›†éƒ¨ï¼‰ Security&Trustã‚¦ã‚©ãƒƒãƒï¼ˆ60ï¼‰ ä»Šå¤œã“ãã‚ã‹ã‚‹å®‰å…¨ãªSQLã®å‘¼ã³å‡ºã—æ–¹ ï½ž é«˜æœ¨æµ©å…‰æ°ã«èžã„ã¦ã¿ãŸ http://www.atmarkit.co.jp/fsecurity/column/ueno/60.html Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«å¯¾ã™ã‚‹æ”»æ’ƒæ‰‹æ³•ã®1ã¤ã§ã‚ã‚‹SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã®å˜åœ¨ã¯ã€ã‹ãªã‚ŠåºƒãçŸ¥ã‚‰ã‚Œã‚‹ã‚ˆã†ã«ãªã£ãŸã€‚ã—ã‹ã—ã€ãã®å¯¾ç–ã¯ã¾ã æœ¬å½“ã«ç†è§£ã•ã‚Œã¦ã„ãªã„ã‚ˆã†ã«æ€ãˆã‚‹ã€‚ãƒ•ã‚©ãƒ¼ãƒ ã‹ã‚‰æ¸¡ã•ã‚ŒãŸå€¤ã®ç‰¹æ®Šæ–‡å—ã‚’ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ã—ãŸã‚Šã€PHPã®magic_quotes_gpcã¨ã„ã£ãŸè‡ªå‹•ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—æ©Ÿèƒ½ã‚’ã‚ªãƒ³ã«ã™ã‚‹ã ã‘ã§å¯¾ç–ã—ãŸã¤ã‚‚ã‚Šã«ãªã£ã¦ã„ãªã„ã ã‚ã†ã‹ã€‚ åŸºæœ¬ã¯ã‚‚ã¡ã‚ã‚“ã€ã‚»ã‚«ãƒ³ãƒ‰ã‚ªãƒ¼ãƒ€ãƒ¼SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã‚„ãƒžãƒ«ãƒãƒã‚¤ãƒˆæ–‡å—ã‚’åˆ©ç”¨ã—ãŸSQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã®æ”»æ’ƒãƒ‘ã‚¿ãƒ¼ãƒ³ã‚„ã€ãã®å¯¾
the-day 2006/11/02
web

security

programming

sql

SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³

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