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

ktakeda47 id:ktakeda47

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

${{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ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³åˆ†é›¢ å®Ÿè·µã‚¬ã‚¤ãƒ‰ | POSTD
(æ³¨ï¼š2017/10/16ã€ã„ãŸã ã„ãŸãƒ•ã‚£ãƒ¼ãƒ‰ãƒãƒƒã‚¯ã‚’å…ƒã«ç¿»è¨³ã‚’ä¿®æ£ã„ãŸã—ã¾ã—ãŸã€‚) (æ³¨ï¼š2017/10/11ã€ã„ãŸã ã„ãŸãƒ•ã‚£ãƒ¼ãƒ‰ãƒãƒƒã‚¯ã‚’å…ƒã«ç¿»è¨³ã‚’ä¿®æ£ã„ãŸã—ã¾ã—ãŸã€‚) ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã§åˆ†é›¢ãƒ¬ãƒ™ãƒ«ã‚’ç›®ã«ã—ã¦ã€è»½ãä¸å®‰ã‚’æ„Ÿã˜ã¤ã¤ã€ã‚ã¾ã‚Šè€ƒãˆãªã„ã‚ˆã†ã«ã—ãŸã“ã¨ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã®æ—¥å¸¸ã®ä½¿ç”¨ä¾‹ã§ãã¡ã‚“ã¨åˆ†é›¢ã«ã¤ã„ã¦è¨€åŠã—ã¦ã„ã‚‹ã‚‚ã®ã¯ã»ã¨ã‚“ã©ã‚ã‚Šã¾ã›ã‚“ã€‚å¤šãã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®åˆæœŸè¨å®šã®åˆ†é›¢ãƒ¬ãƒ™ãƒ«ã‚’åˆ©ç”¨ã—ã¦ãŠã‚Šã€å¾Œã¯é‹é ¼ã¿ã§ã™ã€‚ã—ã‹ã—ã€æœ¬æ¥ã€ç†è§£ã—ã¦ãŠãã¹ãåŸºæœ¬çš„ãªãƒˆãƒ”ãƒƒã‚¯ã§ã‚ã‚Šã€ã„ãã‚‰ã‹æ™‚é–“ã‚’æŠ•å…¥ã—ã¦ã“ã®ã‚¬ã‚¤ãƒ‰ã®å†…å®¹ã‚’å¦ç¿’ã™ã‚Œã°ã€ã‚‚ã£ã¨å¿«é©ã«ä½œæ¥ã§ãã‚‹ã‚ˆã†ã«ãªã‚‹ã§ã—ã‚‡ã†ã€‚ ç§ã¯ã“ã®è¨˜äº‹ã®æƒ…å ±ã‚’å¦è¡“è«–æ–‡ã€PostgreSQLãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒ†ãƒ¼ã‚·ãƒ§ãƒ³ã‹ã‚‰é›†ã‚ã¾ã—ãŸã€‚åˆ†é›¢ãƒ¬ãƒ™ãƒ«ã® ä½•ãŸã‚‹ ã‹ã ã‘ã§ãªãã€é©ç”¨ã®æ£ç¢ºã•ã‚’ä¿æŒã—ã¤ã¤æœ€å¤§é€Ÿåº¦ã§ä½¿ã†ã«ã¯ã„ã¤ä½¿ã†ã¹ãã‹ã€ã¨ã„ã†ç–‘å•ã«ç”ãˆã‚‹ã¹
ktakeda47 2017/10/11
ï¼ˆ Oracle å‹‰å¼·ã•ã›ã‚‰ã‚ŒãŸæ™‚ã‚„ã£ãŸã‚ãƒ¼å…¨ç„¶è¦šãˆã¦ãªã„ã‚ãƒ¼ï¼‰

rdbms

sql

programming
ãƒªãƒ³ã‚¯
JVNTA#99929369: å›½å†…ã®ã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆã« SQL ã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã®è„†å¼±æ€§
æ—¥æœ¬å›½å†…ã®ã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆã«ãŠã‘ã‚‹ SQL ã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã®è„†å¼±æ€§ãŒã€å›½å†…å¤–ã‹ã‚‰ JPCERT/CC ã«è¤‡æ•°å ±å‘Šã•ã‚Œã¦ã„ã¾ã™ã€‚ æ—¥æœ¬å›½å†…ã®ã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆã«ãŠã‘ã‚‹ SQL ã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã®è„†å¼±æ€§ãŒã€å›½å†…å¤–ã‹ã‚‰ JPCERT/CC ã«è¤‡æ•°å ±å‘Šã•ã‚Œã¦ã„ã¾ã™ã€‚ ã‚ªãƒ¼ ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã® SQL ã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³è„†å¼±æ€§è¨ºæ–ãƒ„ãƒ¼ãƒ« sql map ã‚’ä½¿ç”¨ã—ã¦ã€æ—¥æœ¬å›½å†…ã®ã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆã§å‹•ä½œã™ã‚‹ã‚¦ã‚§ãƒ–ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®è„†å¼±æ€§ã‚’æ¤œå‡ºã—ã‚ˆã†ã¨ã™ã‚‹æµ·å¤–ã‹ã‚‰ã®ã‚¢ã‚¯ã‚»ã‚¹ãŒç™ºç”Ÿã—ã¦ã„ã¾ã™ã€‚ã“ã†ã—ãŸã‚¢ã‚¯ã‚»ã‚¹ã¯çµ„ç¹”è¦æ¨¡ã®å¤§å°ã«ã‚ˆã‚‰ãšã€ä¸å°ä¼æ¥ã‚„å€‹äººã®ã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆã«å¯¾ã—ã¦ã‚‚è¡Œã‚ã‚Œã¦ã„ã¾ã™ã€‚SQL ã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã®è„†å¼±æ€§ãŒå˜åœ¨ã™ã‚‹ã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆã§ã¯ã€ãƒ¦ãƒ¼ã‚¶ã‚„é–‹ç™ºè€…ã®æ„å›³ã—ãªã„ SQL æ–‡ãŒå®Ÿè¡Œã•ã‚Œã€æ§˜ã€…ãªå½±éŸ¿ã‚’å—ã‘ã‚‹å¯èƒ½æ€§ãŒã‚ã‚Šã¾ã™ã€‚ sql map ã¯ã€ãŠã‚‚ã«æ¬¡ã® 5ã¤ã®æ‰‹æ³•ã‚’ä½¿ç”¨ã—ã¾ã™ã€‚ Boolean-based blind WH
ktakeda47 2016/03/17
ã–ã£ãã‚Š

ipa

sql

security
ãƒªãƒ³ã‚¯
PostgreSQL 9.5ã®æ–°æ©Ÿèƒ½CONFLICTï¼ˆUPSERTï¼‰ã‚’ä½¿ã£ã¦ã¿ãŸã€‚ | DevelopersIO
ã¯ã˜ã‚ã« UPSERTãŒæŽ¡ç”¨ã•ã‚ŒãŸã¨ã„ã†äº‹ã§ä½¿ç”¨æ–¹æ³•ã‚’èª¿ã¹ã¦ã¿ã¾ã—ãŸã€‚ UPSERTã¨ã¯ ã€Œã“ã®ãƒ‡ãƒ¼ã‚¿ã‚’INSERTã—ãŸã„ã‘ã©ã€åŒã˜ãƒ‡ãƒ¼ã‚¿ãŒå˜åœ¨ã—ã¦ã„ã¦åˆ¶ç´„ã§å¼¾ã‹ã‚Œã‚‹ã‹ã‚‚ã—ã‚Œãªã„ã€‚ãã†ãªã£ãŸã‚‰UPDATEã—ãŸã„ãªã‚ã€‚ã€ ã¨è¨€ã£ãŸå ´åˆã«ä½¿ãˆã‚‹æ©Ÿèƒ½ã§ã™ã€‚ ãŸã ã—ã€UPSERTå¥ãŒä½œã‚‰ã‚ŒãŸè¨³ã§ã¯ãªãã€Œä¸€èˆ¬çš„ã«UPSERTã¨è¨€ã‚ã‚Œã¦ã„ã‚‹æ©Ÿèƒ½ã‚’æè¼‰ã—ãŸã‚ˆã€ã¨è¨€ã†äº‹ã¿ãŸã„ã§ã™ãã€‚ ã“ã®å¾Œã¯å®Ÿéš›ã«åˆ¶ç´„ã‚’è¨å®šã—ãŸãƒ†ãƒ¼ãƒ–ãƒ«ã«UPSERTã‚’è©¦ã—ã¦ã¿ã¦ã©ã†ãªã‚‹ã‹ã‚’è¦‹ã¦ã„ãã¾ã™ã€‚ æ¤œè¨¼ç’°å¢ƒ Mac OSX 10.9.5 PostgreSQL 9.5.1 æ§‹æ–‡ INSERT INTO ãƒ†ãƒ¼ãƒ–ãƒ«å VALUES ('å€¤ï¼‘', 'å€¤ï¼’', ...ï¼‰ ON CONFLICT ON CONSTRAINT åˆ¶ç´„å DO UPDATE SET ã‚«ãƒ©ãƒ ï¼‘='å€¤', ã‚«ãƒ©ãƒ ï¼’='å€¤', ...; INSERTã¨UPDATEã§ON
ktakeda47 2016/03/09
postgresql

SQL

rdbms

rdb
ãƒªãƒ³ã‚¯
æ›¸ç±å‡ºç‰ˆã®ãŠçŸ¥ã‚‰ã›ï¼šç†è«–ã‹ã‚‰å¦ã¶ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å®Ÿè·µå…¥é–€ ~ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ¢ãƒ‡ãƒ«ã«ã‚ˆã‚‹åŠ¹çŽ‡çš„ãªSQL
æ¥ã‚‹2æœˆ27æ—¥ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ–°æ›¸ç±ã‚’ç™ºå£²ã•ã›ã¦é ‚ãã“ã¨ã«ãªã£ãŸã€‚ã‚¿ã‚¤ãƒˆãƒ«ã¯ã€Œç†è«–ã‹ã‚‰å¦ã¶ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å®Ÿè·µå…¥é–€ ~ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ¢ãƒ‡ãƒ«ã«ã‚ˆã‚‹åŠ¹çŽ‡çš„ãªSQLã€ã¨ãªã£ã¦ã„ã‚‹ã€‚å˜ã«ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ã¨æ›¸ã„ã¦ã‚ã‚‹ãŒã€RDBãŒãƒ¡ã‚¤ãƒ³ã®ãƒ†ãƒ¼ãƒžã®æ›¸ç±ã§ã‚ã‚‹ã€‚ å¤šãã®äººãŒæœªã ã«RDBã‚’ä½¿ã„ã“ãªã›ã¦ã„ãªã„ã®ã§ã¯ãªã„ã‹ã€‚RDBã®ä½¿ã„æ–¹ã‚’ãƒžã‚¹ã‚¿ãƒ¼ã™ã‚‹ã«ã¯ä½•ãŒå¿…è¦ãªã®ã‹ã€‚ãã‚ŒãŒã“ã“æ•°å¹´ç§ãŒè¿½ã£ã¦ããŸãƒ†ãƒ¼ãƒžã§ã‚ã‚Šã€ã“ã®æ›¸ç±ã‚’å‡ºã™ã“ã¨ã«ãªã£ãŸå‹•æ©Ÿã§ã‚ã‚‹ã€‚ ã‚ã¾ã‚Šã«ã‚‚é…·ã„DBè¨è¨ˆã€ã‚ã¾ã‚Šã«ã‚‚ã‚¹ãƒ‘ã‚²ãƒ†ã‚£ãªã‚¯ã‚¨ãƒªã€ã‚ã¾ã‚Šã«ã‚‚å¸Œè–„ãªãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ«ã¸ã®ç†è§£ã€‚ãã†ã„ã£ãŸå•é¡Œã¯ã©ã“ã‹ã‚‰ç”Ÿã¿å‡ºã•ã‚Œã‚‹ã®ã‹ã€‚ãã®ã²ã¨ã¤ã®çµè«–ã¨ã—ã¦ãŸã©ã‚Šç€ã„ãŸã®ãŒã€ã€Œãã‚‚ãã‚‚RDBã®ä½¿ã„æ–¹ãŒã‚ã¾ã‚Šç†è§£ã•ã‚Œã¦ã„ãªã„ã®ã§ã¯ãªã„ã‹ã€ã¨ã„ã†ã“ã¨ã ã£ãŸã€‚åè‘—ã€SQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã§ã¯ã€Œã‚„ã£ã¦ã¯ã„ã‘ãªã„ã‚±ãƒ¼ã‚¹ã€ã«ã¤ã„ã¦å¦ã¶ã“ã¨ãŒã§ãã‚‹ãŒã€ãã®åå¯¾ã®ãƒ†ãƒ¼ãƒžã€ã¤ã¾ã‚Šæœ¬æ¥ã©ã®
ktakeda47 2015/02/03
book

rdbms

mysql

sql

db
ãƒªãƒ³ã‚¯
ã‚¤ãƒŸãƒ¥ãƒ¼ã‚¿ãƒ–ãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ«(å…¥é–€ç·¨)
6. Step1 ã‚¨ãƒ³ãƒ†ã‚£ãƒ†ã‚£ã®æŠ½å‡º ç™ºé€æ‹…å½“è€…ãŒå—æ³¨ãƒªã‚¹ãƒˆã‚’ã‚‚ã¨ã«ã€å•†å“ã®åœ¨åº«ã‚’ç¢ºèªã—ã€åœ¨åº«ãŒ ã‚ã‚Œã°å•†å“ã‚’ç™ºé€ã™ã‚‹ã€‚ â‘ è¦æ±‚ä»•æ§˜ã®ã€Œå‹•è©žã€ã‚’æŠœãå‡ºã—ã‚¨ãƒ³ãƒ†ã‚£ãƒ†ã‚£ã¨ã™ã‚‹ã€‚ â‘¡ â‘ ã«é–¢ã‚ã‚‹ã€Œåè©žã€ã‚’æŠœãå‡ºã—ã‚¨ãƒ³ãƒ†ã‚£ãƒ†ã‚£ã¨ã™ã‚‹ã€‚ â‘¢ ã‚¨ãƒ³ãƒ†ã‚£ãƒ†ã‚£é–“ã®é–¢é€£ã«ç·šã‚’å¼•ã â‘£ å±žæ€§ã‚„å€™è£œã‚ãƒ¼ã‚‚åˆ†ã‹ã‚‹ç¯„å›²ã§æ›¸ã„ã¦ãŠãã¾ã™ã€‚ é–“é•ã„ï¼ ã“ã®æ®µéšŽã§å®Ÿè£…ã‚’ãƒ—ãƒãƒ‘ãƒ†ã‚£ãƒ•ã‚¡ã‚¤ãƒ«ã«ã™ã‚‹ã¨ã‹ã€Enum ã«ã™ã‚‹ã¨ã‹æ±ºã‚æ‰“ã¡ã§ã‚¨ãƒ³ãƒ†ã‚£ãƒ†ã‚£ã¨ã—ã¦è¡¨ã•ãªã„ã®ã¯ã‚„ ã‚ã¾ã—ã‚‡ã†ã€‚ ã¾ãšã€ã¯ã˜ã‚ã«ã‚¨ãƒ³ãƒ†ã‚£ãƒ†ã‚£ã‚’æŠ½å‡ºã—ã¾ã™ã€‚
ktakeda47 2014/10/21
ã‚ã‹ã‚Šã‚„ã™ã„

development

rdbms

sql

db

mysql

postgresql

programming
ãƒªãƒ³ã‚¯
ã¨ã‚ã‚‹è¨ºæ–å“¡ã¨SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³
7. é€šå¸¸ã®Webã‚µãƒ¼ãƒã¨ã®é€šä¿¡ <html> <body> <form action=â€œregisterâ€ method=â€œPOSTâ€> æ°å:vultest<BR> ãƒ¡ãƒ¼ãƒ«ã‚¢ãƒ‰ãƒ¬ã‚¹:vulte [email protected]<BR> æ€§åˆ¥:ç”·<BR> ï¼ˆä»¥ä¸‹ç•¥ï¼‰ </html> POST /confirm.php HTTP/1.1 Host: example.jp ï¼ˆä»¥ä¸‹ç•¥ï¼‰ Cookie: PHP SESSID=xxxxxxxxxx name=vultest&mail=vultest%40example.jp&gender=1 HTTP Response HTTP Request 8. è‰²ã€…ã„ã˜ã£ã¦ã¿ã¦ã©ã†ã„ã†å¿œç”ãŒã‚ã‚‹ã‹ç¢ºèª POST /confirm.php HTTP/1.1 Host: example.jp ï¼ˆä»¥ä¸‹ç•¥ï¼‰ Cookie: PHP SESSID=xxxxxxxxxx name
ktakeda47 2014/08/12
security

sqlinjection

sql
ãƒªãƒ³ã‚¯
Cassandraãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ«å…¥é–€ - Arin Sarkissian - Digital Romanticism
ã“ã®è¨˜äº‹ã¯ã€Arin Sarkissianæ°ã®ãƒ–ãƒã‚°è¨˜äº‹ã€Œhttp://arin.me/blog/wtf-is-a-supercolumn-cassandra-data-modelã€ã‚’æ°ã®è¨±å¯ã‚’å¾—ã¦ç¿»è¨³ã—ãŸã‚‚ã®ã§ã™ã€‚ï¼ˆåŽŸæ–‡å…¬é–‹æ—¥ï¼š2009å¹´9æœˆ1æ—¥ï¼‰ ã“ã“ï¼‘ã€ï¼’ãƒ¶æœˆã¨ã„ã†ã‚‚ã®ã€Diggã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒªãƒ³ã‚°ãƒãƒ¼ãƒ ã¯Cassandraã«ã¤ã„ã¦èª¿ã¹ã€éŠã³ã€æœ€çµ‚çš„ã«ã¯ãƒ—ãƒãƒ€ã‚¯ã‚·ãƒ§ãƒ³ã«ãƒ‡ãƒ—ãƒã‚¤ã™ã‚‹ãŸã‚ã«ã‹ãªã‚Šã®æ™‚é–“ã‚’è²»ã‚„ã—ã¦ãã¾ã—ãŸã€‚ã“ã‚Œã¯å®Ÿã«æ¥½ã—ã„ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã§ã—ãŸãŒã€æ¥½ã—ããªã‚‹å‰ã«Cassandraã®ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ«ã«ã¤ã„ã¦ç†è§£ã™ã‚‹ãŸã‚ã«ç›¸å½“ã®æ™‚é–“ã‚’è²»ã‚„ã—ãŸã®ã§ã™ã€‚ã€Œ'super column'ã£ã¦ä½•ã ã‚ˆã€ã¨ã„ã†ãƒ•ãƒ¬ãƒ¼ã‚ºãŒä½•åº¦ã‚‚å£ã«ã•ã‚Œã¾ã—ãŸã€‚ ã‚‚ã—ã‚ãªãŸã®ãƒãƒƒã‚¯ã‚°ãƒ©ã‚¦ãƒ³ãƒ‰ãŒRDBMSãªã‚‰ã°ï¼ˆã»ã¨ã‚“ã©ã¿ã‚“ãªãŒãã†ã§ã—ã‚‡ã†ãŒï¼‰ã€Cassandraã®ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ«ã«ã¤ã„ã¦å¦ã¶éš›ã«ã€ã„ãã¤ã‹ã®ãƒãƒ¼ãƒŸãƒ³ã‚°è¦ç´„ã§
ktakeda47 2014/07/13
cassandra

nosql

sql

rdbms

kvs
ãƒªãƒ³ã‚¯
ã€Œã†ã‚‰ãŒã¿ãŒ Java ã¾ã‚ã‚Šã® ORM ã‚’çŸ¥ã‚ŠãŸã„ä¼šã€ ã«å‚åŠ ã—ã¦ããŸ - ã²ã ã¾ã‚Šã‚½ã‚±ãƒƒãƒˆã¯å£Šã‚Œãªã„
ã†ã‚‰ãŒã¿ãŒJavaã¾ã‚ã‚Šã®ORMã‚’çŸ¥ã‚ŠãŸã„ä¼š - connpass Java ã® O/R ãƒžãƒƒãƒ‘ãƒ¼ã¾ã‚ã‚Šã®è©±ã‚’çŸ¥ã‚ŠãŸã‹ã£ãŸã®ã§ã€6/14 ã«è¡Œã‚ã‚ŒãŸå‹‰å¼·ä¼š ã€Œã†ã‚‰ãŒã¿ãŒ Java ã¾ã‚ã‚Šã® ORM ã‚’çŸ¥ã‚ŠãŸã„ä¼šã€ ã«å‚åŠ ã—ã¦ãã¾ã—ãŸã€‚ ä¼šå ´ã¯å’Œå®¤ã§ã—ãŸã€‚ Java ã¾ã‚ã‚Šã® O/R ãƒžãƒƒãƒ‘ãƒ¼ã€ã‚ã‚“ã¾ã‚Šè©³ã—ããªã„ã®ã§ã„ã‚ã„ã‚çŸ¥ã‚Œã¦è‰¯ã‹ã£ãŸã§ã™ã€‚ ãƒ¡ãƒ¢ã‚’æ®‹ã—ã¦ãŠãã¾ã™ã€‚ ç™ºè¡¨å†…å®¹ Java ã® ORMã€Doma ã®è©± +Î± (@backpaper0 ã•ã‚“) ç™ºè¡¨è³‡æ–™: Javaã®ORMã€Domaã®è©± +Î± â€” Javaã®ORMã€Domaã®è©± 1.0 documentation ã„ã‚ã‚“ãª O/R ãƒžãƒƒãƒ‘ãƒ¼ã«ã¤ã„ã¦ã®ç°¡å˜ãªç´¹ä»‹ã¨ã€Doma ã®ç´¹ä»‹ã€‚ ç´¹ä»‹ã•ã‚ŒãŸ O/R ãƒžãƒƒãƒ‘ãƒ¼ã®ã†ã¡ã€ä½¿ã†ã¨ã—ãŸã‚‰ JPA ã‹ Iciql ã‹ Doma ã‹ãªãƒ¼ã¨ã„ã†æ°—æŒã¡ã«ãªã£ãŸã€‚ (å€‹äººã®æ„Ÿæƒ³ã§ã™ã€‚) ã¡ãªã¿ã«ç´¹
ktakeda47 2014/06/16
java

javase

orm

rdb

doma

sql

programming

rdbms
ãƒªãƒ³ã‚¯
http://www.saitolab.org/taiken/
ktakeda47 2014/06/11
security

programming

webservice

xss

sql
ãƒªãƒ³ã‚¯
è‹±å›½ã§å¤§è«–äº‰ã€äº¤é€šæ¨™è˜ã«ã‚¢ãƒã‚¹ãƒˆãƒãƒ•ã‚£ãƒ¼ã¯å¿…è¦ã‹ ï¼ˆï¼¡ï¼¦ï¼°ï¼æ™‚äº‹ï¼‰ - Yahoo!ãƒ‹ãƒ¥ãƒ¼ã‚¹
ã€AFPï¼æ™‚äº‹ã€‘è‹±å›½ã§ã€è‹±èªžã®æ–‡æ³•ã‚’ã‚ãã‚‹å¥‡å¦™ãªãƒãƒˆãƒ«ãŒç¹°ã‚Šåºƒã’ã‚‰ã‚Œã¦ã„ã‚‹ã€‚äº¤é€šæ¨™è˜ã‹ã‚‰ã€Œã‚¢ãƒã‚¹ãƒˆãƒãƒ•ã‚£ãƒ¼ã€ã‚’çœç•¥ã—ãŸã„åœ°æ–¹è°ä¼šã¨ã€ãã‚Œã‚’æ¢ã‚ã‚ˆã†ã¨ã™ã‚‹è‹±èªžæ„›å¥½å®¶ãŸã¡ã®é—˜ã„ã ã€‚ è‹±å›½ã®æ£ã—ã„è‹±èªžå®ˆã‚‹ã€Œã‚¯ã‚¤ãƒ¼ãƒ³ã‚ºãƒ»ã‚¤ãƒ³ã‚°ãƒªãƒƒã‚·ãƒ¥å”ä¼šã€ã€è§£æ•£ã¸ ã€€ãƒãƒˆãƒ«ã®æ³¢ã¯ä»Šã€å¤§å¦ã®è¡—ã‚±ãƒ³ãƒ–ãƒªãƒƒã‚¸ï¼ˆCambridgeï¼‰ã«æŠ¼ã—å¯„ã›ã¦ã„ã‚‹ã€‚ãŸã¨ãˆã°ã€Œã‚ãƒ³ã‚°ã‚ºãƒ»ãƒãƒ¼ãƒ‰ã€ã®æ¨™è˜ã¯ã€ã€ŒKing's Roadã€ã‹ã‚‰ã€ŒKings Roadã€ã«å¤‰ãˆã‚‰ã‚ŒãŸã€‚ ã—ã‹ã—ã‚±ãƒ³ãƒ–ãƒªãƒƒã‚¸å¸‚ã¯ã“ã®æ–¹é‡ã®æ’¤å›žã‚’ä½™å„€ãªãã•ã‚ŒãŸã€‚ä½•è€…ã‹ãŒå¤œä¸ã«ãƒžã‚¸ãƒƒã‚¯ã§ã‚¢ãƒã‚¹ãƒˆãƒãƒ•ã‚£ãƒ¼ã‚’æ›¸ãè¾¼ã‚€ã‚²ãƒªãƒ©é‹å‹•ã‚’å§‹ã‚ãŸãŸã‚ã ã€‚ åœ°æ–¹æ”¿åºœãŒå¥èªç‚¹ã‚’çœç•¥ã—å§‹ã‚ãŸã®ã¯ã€ä¸å¤®æ”¿åºœã‹ã‚‰æ•‘æ€¥åŒ»ç™‚ã‚µãƒ¼ãƒ“ã‚¹ã®ãŸã‚ã«ã¨ã€å‹§å‘ŠãŒã‚ã£ãŸãŸã‚ã¨ã¿ã‚‰ã‚Œã‚‹ã€‚ ä»Šå¹´ã€ãœã‚“ããã‚’æ‚£ã£ã¦ã„ãŸ10ä»£ã®åãŒã€ã‚¢ãƒã‚¹ãƒˆãƒãƒ•ã‚£ãƒ¼ã®ã›ã„ã§æ•‘æ€¥è»ŠãŒé•ã†ä½æ‰€ã«å‘ã‹ã£ãŸãŸã‚ã«æ»äº¡ã—ãŸã€‚ ã‚±ãƒ³ãƒ–ãƒªãƒƒã‚¸å¸‚è°ä¼š
ktakeda47 2014/04/07
"ã€Œå›½ã®ã‚¬ã‚¤ãƒ‰ãƒ©ã‚¤ãƒ³ã«ã¯ã€æ–°ã—ã„é€šã‚Šã®åå‰ã«å¥èªç‚¹ã‚’å…¥ã‚Œãªã„ã“ã¨ãŒæŽ¨å¥¨ã•ã‚Œã¦ã„ãŸã€‚å¥èªç‚¹ãŒæ•‘æ€¥ã‚µãƒ¼ãƒ“ã‚¹ã®ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã†ã¾ãå‡¦ç†ã•ã‚Œã¦ã„ãªã‹ã£ãŸãŸã‚ã ã¨æ€ã‚ã‚Œã‚‹ã€"

law

government

programming

sql

security
ãƒªãƒ³ã‚¯
MySQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
2018/01/26 ç¬¬2å›ž ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æ¯”è¼ƒã‚»ãƒŸãƒŠãƒ¼ https://osscons-database.connpass.com/event/74688/
ktakeda47 2014/03/02
mysql

performance

rdbms

sql

db
ãƒªãƒ³ã‚¯
https://jp.techcrunch.com/2014/02/12/20140211googles-cloud-sql-hits-general-availability-gets-an-sla-encryption-and-support-for-larger-databases/
ktakeda47 2014/02/13
google

cloud

sql

mysql

db

rdbms

paas
ãƒªãƒ³ã‚¯
Cloud SQL for MySQL, PostgreSQL, and SQL Server
Fully managed, cost-effective relational database service for PostgreSQL, MySQL, and SQL Server. Try Enterprise Plus edition for a 99.99% availability SLA and category-leading performance. New customers get $300 in free credits to try Cloud SQL and other Google Cloud products.
ktakeda47 2014/02/13
google

mysql

rdbms

db

cloud

sql

paas
ãƒªãƒ³ã‚¯
é¥ä½ä¿ on Twitter: "MySQLã‚³ãƒŸãƒ¥ç‰ˆã¯GPLãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã€‚ã‚³ãƒã‚¯ã‚¿ã‚‚GPLã€‚ãªã®ã§ã€ã‚³ãƒã‚¯ã‚¿ã‚’åˆ©ç”¨ã—ãŸã‚¢ãƒ—ãƒªã‚‚GPLã«ã—ãªã„ã¨ã„ã‘ãªã„ã€‚ã¤ã¾ã‚Šç¬¬ï¼“è€…ã«é ’å¸ƒã™ã‚‹ã“ã¨ãŒå¯èƒ½ã€ã¾ãŸã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã®é–‹ç¤ºç¾©å‹™ãŒç™ºç”Ÿã™ã‚‹ã€‚ã“ã‚Œã¯GPLãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã§å¿…ãšç™ºç”Ÿã™ã‚‹è©±ã€‚å•†ç”¨ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã¯GPLã§ã¯ãªã„ã‚ˆ #sqlworld"
ktakeda47 2014/01/25
mysql

java

jdbc

sql

rdbms
ãƒªãƒ³ã‚¯
PHP+PDO+MySQLã®çµ„ã¿åˆã‚ã›ã§ã¯SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³æ”»æ’ƒã§è¤‡æ–‡å‘¼ã³å‡ºã—ãŒå¯èƒ½
åŸºç¤Žã‹ã‚‰ã®PHPã¨ã„ã†æ›¸ç±ã‚’èªã‚“ã§ãŠã‚Šã¾ã—ãŸã‚‰ã€SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã®æ”»æ’ƒä¾‹ã¨ã—ã¦ã€ä»¥ä¸‹ã®SQLæ–‡ãŒã§ãã‚ãŒã‚‹ä¾‹ãŒç´¹ä»‹ã•ã‚Œã¦ã„ã¾ã—ãŸã€‚PHP+PDO+MySQLã¨ã„ã†çµ„ã¿åˆã‚ã›ã§ã™ã€‚ SELECT * FROM tb2 WHERE ban=1;delete from tb2 2ã¤ã®SQLæ–‡ãŒã‚»ãƒŸã‚³ãƒãƒ³ã§åŒºåˆ‡ã£ã¦1ã¤ã«ã¾ã¨ã‚ã‚‰ã‚Œã¦ã„ã¾ã™ãŒã€ã“ã‚Œã‚’ã€Œè¤‡æ–‡(multiple statement)ã€ã¨è¨€ã„ã¾ã™ã€‚ç§ã¯ã€SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³æ”»æ’ƒã®æ–‡è„ˆã§è¤‡æ–‡ãŒä½¿ãˆã‚‹çµ„ã¿åˆã‚ã›ã‚’èª¿ã¹ãŸã“ã¨ãŒã‚ã‚Šã€PHPã¨MySQLã¨ã„ã†çµ„ã¿åˆã‚ã›ã§ã¯ã€è¤‡æ–‡ã¯ä½¿ãˆãªã„ã¨æ€ã£ã¦ã„ã¾ã—ãŸã®ã§ã€ã“ã®æ”»æ’ƒã¯æˆç«‹ã—ãªã„ã®ã§ã¯ãªã„ã‹ã¨æ€ã„ã¾ã—ãŸã€‚ ã—ã‹ã—ã€æ±ºã‚ã¤ã‘ã‚‚è‰¯ããªã„ã¨æ€ã„æ‰‹å…ƒã®ç’°å¢ƒã§å‹•ã‹ã—ã¦ã¿ãŸã¨ã“ã‚ã€ã‚ã£ã•ã‚Šå‹•ãã§ã¯ã‚ã‚Šã¾ã›ã‚“ã‹ã€‚ PDOã‚’ç”¨ã„ã¦MySQLã‚’å‘¼ã³å‡ºã™å ´åˆã¯è¤‡æ–‡ãŒå®Ÿè¡Œã§ãã‚‹ã¨æ°—ã¥ãã¾ã—ãŸãŒã€ãªãœPDOã®å ´åˆ
ktakeda47 2013/12/17
"PDO::setAttribute(PDO::ATTR_EMULATE_PREPARES, false);"

php

pdo

security

sql

mysql
ãƒªãƒ³ã‚¯
åˆå¿ƒè€…ã®æ–¹ã«ã“ãã™ã™ã‚ãŸã„ ScalikeJDBC #play_kb - seratch's weblog in Japanese
#play_kb ã€ŒPlayFrameworké–¢è¥¿ãƒ“ã‚®ãƒŠãƒ¼ã‚º ç¬¬2å›ž #play_kbã€ã¨ã„ã† Play Framework åˆå¿ƒè€…ã®æ–¹å‘ã‘ã®å‹‰å¼·ä¼šãŒè¡Œã‚ã‚Œã¦ã„ã‚‹ã‚ˆã†ã§ã™ã€‚ç´ æ™´ã‚‰ã—ã„ã§ã™ãã€‚ http://www.zusaar.com/event/891003 æ±äº¬ã§ Scala ç•Œéšˆã®æ–¹ã«ãŠä¼šã„ã™ã‚‹ã¨ã€åå‰ãã‚‰ã„ã¯çŸ¥ã£ã¦ã„ãŸã ã‘ã¦ã„ã‚‹ã“ã¨ã‚‚å¢—ãˆã¦ãã¾ã—ãŸãŒã€ãã‚Œã¯åœ°åŸŸé™å®šã®è©±ã§ã€ã¾ã ã¾ã çŸ¥ååº¦ãŒä½Žã„ã‚ˆã†ã§ã™ã€‚ ScalikeJDBC ã‚‚é¸æŠžè‚¢ã«åŠ ãˆã¦ã‚ã’ã¦ãã ã•ã„ï¼ #play_kbâ€” ãŒããž (@gakuzzzz) August 3, 2013 ScalikeJDBC ã¯ã¾ã ã¾ã çŸ¥ååº¦ãŒè¶³ã‚Šãªã„ã§ã™ãã€‚ãŸã¶ã‚“åˆå¿ƒè€…ã®äººã¯ã“ã£ã¡ã®æ–¹ãŒæ¥½ã§ã™ã‚ˆã€‚ #play_kbâ€” Kazuhiro Sera (@seratch) August 3, 2013 @seratch Slickã‚‚Squeryl
ktakeda47 2013/12/09
scala

jdbc

sql

rdbms

db
ãƒªãƒ³ã‚¯
XSSã¨SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã®ä¸¡æ–¹ãŒå¯èƒ½ãªRFC5322é©åˆã®ãƒ¡ãƒ¼ãƒ«ã‚¢ãƒ‰ãƒ¬ã‚¹
ãƒ¡ãƒ¼ãƒ«ã‚¢ãƒ‰ãƒ¬ã‚¹ã®ã€Œãƒ«ãƒ¼ãƒ«ã€ã«é–¢ã™ã‚‹è©±é¡ŒãŒç››ã‚Šä¸ŠãŒã£ã¦ã„ã¾ã™ãã€‚ ã€Œãƒ¡ãƒ¼ãƒ«ã‚¢ãƒ‰ãƒ¬ã‚¹ã®ãƒ«ãƒ¼ãƒ«ã€ç³»ã¾ã¨ã‚ãŒãã‚ã£ã¦é–“é•ã£ã¦ã‚‹ã®ã§ã”æ³¨æ„ã‚’ ã€Œãƒ¡ãƒ¼ãƒ«ã‚¢ãƒ‰ãƒ¬ã‚¹ã®ãƒ«ãƒ¼ãƒ«ã€ãªã‚“ã¦ä½¿ã£ã¦ã¯ã„ã‘ãªã„3ã¤ã®ç†ç”± ã“ã‚Œã‚‰ã®ã‚¨ãƒ³ãƒˆãƒªã«ç•°è«–ãŒã‚ã‚‹ã‚ã‘ã§ã‚ã‚Šã¾ã›ã‚“ã€‚ãƒ¡ãƒ¼ãƒ«ã‚¢ãƒ‰ãƒ¬ã‚¹ã«é–¢ã™ã‚‹ãƒ«ãƒ¼ãƒ«ã¨ã„ã†ã¨RFC5322ãªã©ãŒã‚ã‚‹ã‚‚ã®ã®ã€ç¾å®Ÿã®é‹ç”¨ã§ã¯ç°¡æ˜“çš„ãªä»•æ§˜ã‚’ç”¨ã„ã¦ã„ã‚‹å ´åˆãŒå¤§åŠã§ã‚ã‚‹â€¦ã¨ã„ã†äº‹æƒ…ã¯ã€ç§ã‚‚ä»¥å‰ãƒ–ãƒã‚°ã«æ›¸ãã¾ã—ãŸã€‚ã€ æœ¬ç¨¿ã§ã¯ã€ã€Œç©ºå‰ã®ãƒ¡ãƒ¼ãƒ«ã‚¢ãƒ‰ãƒ¬ã‚¹ã®ãƒ«ãƒ¼ãƒ«ãƒ–ãƒ¼ãƒ (?)ã€ã«ä¾¿ä¹—ã™ã‚‹å½¢ã§ã€RFC5322ã«æº–æ‹ ã—ãŸãƒ¡ãƒ¼ãƒ«ã‚¢ãƒ‰ãƒ¬ã‚¹ã§ã€XSSã‚„SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã®æ”»æ’ƒãŒã§ãã‚‹ã“ã¨ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ã¨è¨€ã£ã¦ã‚‚ã€SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã«ã¤ã„ã¦ã¯ã€éŽåŽ»ã«æ›¸ãã¾ã—ãŸã®ã§ã€æœ¬ç¨¿ã§ã¯ã€RFC5322ãƒãƒªãƒƒãƒ‰ãªãƒ¡ãƒ¼ãƒ«ã‚¢ãƒ‰ãƒ¬ã‚¹ã§SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã¨XSSã®ä¸¡æ–¹ãŒã§ãã‚‹ãƒ¡ãƒ¼ãƒ«ã‚¢ãƒ‰ãƒ¬ã‚¹ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ ã¾ãšã€æ”»æ’ƒå¯¾è±¡ã¨ã—ã¦ã€ä»¥ä¸‹
ktakeda47 2013/11/29
security

xss

sql

rfc
ãƒªãƒ³ã‚¯
Nullã®ã¯ãªã—(upç”¨)
5/20ã®JAWS-UG CLIå°‚é–€æ”¯éƒ¨ #179R AWS CLIç’°å¢ƒå…¥é–€ã®LTã§è©±ã—ãŸå†…å®¹ã§ã™ã€‚ ã‹ãªã‚Šãƒ‹ãƒƒãƒãªå†…å®¹ã§ã€ã—ã‹ã‚‚è‰²æ°—ã®ãªã„ç™ºè¡¨ã«ãªã£ã¦ã—ã¾ã„ã¾ã—ãŸã€‚ The future of SEO is trending toward a more human-first and user-centric approach, powered by AI intelligence and collaboration. Are you ready? Watch as we explore which SEO trends to prioritize to achieve sustainable growth and deliver reliable results. Weâ€™ll dive into best practices to adapt your strategy around
ktakeda47 2013/07/28
sql

rdbms

db

mysql

postgresql

oracle
ãƒªãƒ³ã‚¯
DDLãƒ¬ãƒ™ãƒ«ã®å¤–éƒ¨ã‚ãƒ¼åˆ¶ç´„ã¯ä¸è¦ - è¨è¨ˆè€…ã®ç™ºè¨€
ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œã‚‹éš›ã«ã€DDLãƒ¬ãƒ™ãƒ«ã§å¤–éƒ¨ã‚ãƒ¼åˆ¶ç´„ã‚’ã¤ã‘ã‚‹ã“ã¨ãŒã‚ã‚‹ãŒã€ç§ã¯ã“ã‚Œã«ã¯åå¯¾ã§ã‚ã‚‹ã€‚çµ„ã¿è¾¼ã‚ã‚‹åˆ¶ç´„ã®å¹…ãŒç‹ã™ãŽã‚‹ã†ãˆã«ã€æ¥å‹™ãƒ«ãƒ¼ãƒ«ã«é–¢ã™ã‚‹è¨˜è¿°ãŒã‚ã¡ã“ã¡ã«æ•£ã‚‰ã°ã£ã¦ã—ã¾ã†ã‹ã‚‰ã ã€‚é †ã‚’è¿½ã£ã¦èª¬æ˜Žã—ã‚ˆã†ã€‚ å¤–éƒ¨ã‚ãƒ¼åˆ¶ç´„ã‚’çµ„ã¿è¾¼ã‚€ã“ã¨ã§ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã¯æ›´æ–°ãƒ»è¿½åŠ ãƒ»å‰Šé™¤æ“ä½œã«ãŠã„ã¦åˆ¶ç´„ã‚’å—ã‘ã‚‹ã€‚ãŸã¨ãˆã°ã€å—æ³¨ãƒ†ãƒ¼ãƒ–ãƒ«ãŒé¡§å®¢idã‚’æŒã£ã¦ã„ã‚‹ã¨ã—ã¦ã€ã“ã‚Œã«é¡§å®¢ãƒžã‚¹ã‚¿ãƒ¼ã«å¯¾ã™ã‚‹å¤–éƒ¨ã‚ãƒ¼åˆ¶ç´„ã‚’ä¸Žãˆã‚‹ã¨ã—ã‚ˆã†ã€‚ã“ã®ã¨ãã€å—æ³¨ç™»éŒ²ã®éš›ã«é¡§å®¢idã®å€¤ãŒãã®æ™‚ç‚¹ã®é¡§å®¢ãƒžã‚¹ã‚¿ãƒ¼ä¸Šã«å®šç¾©ã•ã‚Œã¦ã„ãªã‘ã‚Œã°ã‚¨ãƒ©ãƒ¼ã«ãªã‚‹ã€‚ã¾ãŸã€ç‰¹å®šã®é¡§å®¢ãƒ‡ãƒ¼ã‚¿ã‚’é¡§å®¢ãƒ†ãƒ¼ãƒ–ãƒ«ã‹ã‚‰å‰Šé™¤ã—ã‚ˆã†ã¨ã—ãŸã¨ãã«ã€æ—¢å˜ã®å—æ³¨ãƒ‡ãƒ¼ã‚¿ã¨é–¢é€£ã¥ã‘ã•ã‚Œã¦ã„ã‚‹ã‚ˆã†ãªé¡§å®¢ã§ã‚ã‚Œã°ã€ã‚„ã¯ã‚Šã‚¨ãƒ©ãƒ¼ã«ãªã‚‹ã€‚ ã“ã®ç¨‹åº¦ã®ä¾‹ã§ã‚ã‚Œã°ã€å¤–éƒ¨ã‚ãƒ¼åˆ¶ç´„ã‚’DDLãƒ¬ãƒ™ãƒ«ã§çµ„ã¿è¾¼ã‚€ã“ã¨ã«ä½•ã‚‰å•é¡Œã¯ãªã„ã€‚ ã¨ã“ã‚ãŒã€ç¾å®Ÿã¯æƒ³åƒä»¥ä¸Šã«è¤‡é›‘ã§ã‚ã‚‹ã€‚ãŸã¨ãˆã°ã€å¤šå°‘ä¸è‡ªç„¶ãªä¾‹ã§ã¯ã‚ã‚‹ãŒã€å—æ³¨
ktakeda47 2013/02/23
"ã‚ˆã†ã™ã‚‹ã«DDLãƒ¬ãƒ™ãƒ«ã®å¤–éƒ¨ã‚ãƒ¼åˆ¶ç´„æ©Ÿæ§‹ã¯ã€ç¾å®Ÿã®æ¥å‹™è¦ä»¶ã‚’å‰ã«ã—ã¦ã¯ã‚¤ãƒ©ã‚¤ãƒ©ã•ã›ã‚‰ã‚Œã‚‹ã»ã©ã«å˜ç´”ã§ä¸é€”åŠç«¯ã§ã‚ã‚‹ã€‚"

development

db

rdbms

programming

sql
ãƒªãƒ³ã‚¯
ã€ŒSQL ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã€ã¯è‰²ã‚“ãªæˆ¦äº‰ã®ç«ç¨®ã«ãªã‚Šãã† - yoshiori.github.io
ç›£è¨³ã®ä¸€äººã§ã‚ã‚‹ @t_wada ã«çŒ®æœ¬é ‚ãã¾ã—ãŸã€‚ ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ï¼ï¼ï¼ ã§ã ã€ã„ããªã‚Šã ã‘ã©ã‚³ãƒ¬ã€ã‚¿ã‚¤ãƒˆãƒ«ã§æã—ã¦ã‚‹ã¨æ€ã†ã‚“ã ã‚ˆãâ€¦â€¦ ã ã£ã¦ã€SQL ã®ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã¦ã‚¿ã‚¤ãƒˆãƒ«ã ã£ãŸã‚‰ã€ join ã—ãŸçµæžœã®æ–¹ã§ where ã§çµžã‚‹ã‚ˆã‚Šã‚‚ on å¥ã§å…ˆã«çµžã‚Œ çš„ãªã®ãŒæ›¸ã„ã¦ã‚ã‚‹ã¨æ€ã†ã˜ã‚ƒã‚“ï¼ï¼ å•ã„åˆã‚ã›è¨€èªžã®äº‹ã ã¨æ€ã†ã˜ã‚ƒã‚“ï¼ï¼ï¼ é•ã£ãŸâ€¦â€¦ ã»ã¨ã‚“ã©æ›¸ã„ã¦ã‚ã‚‹ã®ã¯ DB è¨è¨ˆã«ã¤ã„ã¦ã ã£ãŸâ€¦â€¦ ã¾ãã€å‰¯é¡Œã¯ã€ŒAvoiding the Pitfalls of Database Programmingã€ã®ã ã—ã€ã¾ãã„ã„ã‹ã€‚ ã‚“ã§ã€èªã‚“ã§ã¿ãŸæ„Ÿæƒ³ã¨ã‹ ã‚‚ã†ãã€ä½•å¹´ã‹ DB çµ¡ã‚“ã é–‹ç™ºã—ãŸã“ã¨ã®ã‚ã‚‹äººãªã‚‰ï¼ˆãƒ»âˆ€ãƒ»ï¼‰ï¾†ï¾”ï¾†ï¾”å‡ºæ¥ã‚‹ã¨æ€ã†ã€‚ ã€Œâ€ãƒžãƒ«ãƒã‚«ãƒ©ãƒ ã‚¢ãƒˆãƒªãƒ“ãƒ¥ãƒ¼ãƒˆâ€ã¨ã‹ 10 å¹´å‰ã«é€šã£ãŸã‚ãƒ¼ã€ ã¨ã‹ ã€Œã‚ãƒ¼ã¯ã„ã¯ã„â€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚·ãƒ§ãƒƒãƒˆã‚¬ãƒ³â€ä¹™ã€ ã¿ãŸã„ãªã€‚ Explain
ktakeda47 2013/02/12
èªã¿ãŸã„

sql

rdbms

kvs

development

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