[B! sql] teddy-gã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

teddy-g id:teddy-g

sqlã«é–¢ã™ã‚‹teddy-gã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (13)

${{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ã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã€ã®è„…å¨
æ·±åˆ»ãªã€Œãƒ–ãƒ©ã‚¤ãƒ³ãƒ‰SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã€ã®è„…å¨ï¼šOWASP AppSec USA 2013 ãƒ¬ãƒãƒ¼ãƒˆï¼ˆå‰ç·¨ï¼‰ï¼ˆ2/2 ãƒšãƒ¼ã‚¸ï¼‰ æ¼ã‚Œã¦ã„ãªã„ã‚ˆã†ã§æ¼ã‚Œã¦ã„ã‚‹!? ãƒ–ãƒ©ã‚¤ãƒ³ãƒ‰SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã®è„…å¨ ã“ã“ã‹ã‚‰ã¯ã€ç†è€…ã‚‰ãŒå—è¬›ã—ãŸãƒˆãƒ¬ãƒ¼ãƒ‹ãƒ³ã‚°ã®å†…å®¹ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ 1ã¤ç›®ã¯ã€ã€ŒThe Art Of Exploiting Injection Flawsã€ã§ã™ã€‚SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã«ä»£è¡¨ã•ã‚Œã‚‹ã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³æ”»æ’ƒã«ã¤ã„ã¦ã€è¬›å¸«ãŒç”¨æ„ã—ãŸã‚µãƒ¼ãƒãƒ¼ã¸ã®ç–‘ä¼¼æ”»æ’ƒã‚’é€šã˜ã€ãã®æ”»æ’ƒæ‰‹æ³•ã‚’ç†è§£ã™ã‚‹ã®ãŒç›®çš„ã§ã™ã€‚ è¬›å¸«ã¯ã€ã€ŒSQL Injection, attacks and defenseã€ã®å…±è‘—è€…ã§ã€ãƒŽãƒƒãƒˆã‚½ãƒ¼ã‚»ã‚ãƒ¥ã‚¢ï¼ˆNotSoSecureï¼‰å‰µç«‹è€…ã®ã‚¹ãƒ¼ãƒŸãƒƒãƒˆãƒ»ã‚·ãƒƒãƒ€ãƒ¼ãƒ«ã‚¿ï¼ˆSumit Siddharthï¼‰æ°ã§ã™ã€‚ ãƒˆãƒ¬ãƒ¼ãƒ‹ãƒ³ã‚°ã§ã¯ã€åŸºæœ¬çš„ãªSQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã®æ‰‹æ³•ã‹ã‚‰ã€ãƒ–ãƒ©ã‚¤ãƒ³ãƒ‰SQLã‚¤ãƒ³ã‚¸ã‚§
teddy-g 2018/02/18
ã‚‚ã†ã¡ã‚‡ã£ã¨ä¸å¯§ã«Blind SQLiã®èª¬æ˜Ž

cybersecurity

security

cyberattacks

sql

sqli
ãƒªãƒ³ã‚¯
ã€Œãƒ–ãƒ©ã‚¤ãƒ³ãƒ‰SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã¨ã¯ä½•ã§ã™ã‹ï¼Ÿã€ã¸ã®å›žç”
ä»¥ä¸‹ã¯ã€Yahoo!çŸ¥æµè¢‹ã§ã®ä¸‹è¨˜è³ªå•ã«å¯¾ã™ã‚‹å›žç”ã§ã™ã€‚ ãƒ–ãƒ©ã‚¤ãƒ³ãƒ‰SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã¨ã¯ä½•ã§ã™ã‹ï¼Ÿ ã§ãã‚‹ã ã‘è©³ç´°ã«æ•™ãˆã¦ä¸‹ã•ã„ å›žç”ã—ãŸå¾Œã«ã€è³ªå•ãŒå–ã‚Šæ¶ˆã•ã‚Œã¦ã—ã¾ã„ã¾ã—ãŸã€‚Yahoo!çŸ¥æµè¢‹ã®ä»•æ§˜ã¨ã—ã¦ã€å–ã‚Šæ¶ˆã—ã•ã‚ŒãŸè³ªå•ã¯2é€±é–“ã§å‰Šé™¤ã•ã‚Œã‚‹ãŸã‚ã€å‚™å¿˜ã®ãŸã‚è»¢è¼‰ã—ã¾ã™ã€‚ ãƒ–ãƒ©ã‚¤ãƒ³ãƒ‰SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã¨ã„ã†ã®ã¯ã€SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³æ”»æ’ƒã®ä¸€ç¨®ã§ã™ã€‚ é€šå¸¸ã®SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³æ”»æ’ƒã§ã¯ã€æ¤œç´¢çµæžœã®æ–‡å—åˆ—ãŒè¡¨ç¤ºã•ã‚ŒãŸã‚Šã€SQLã®ã‚¨ãƒ©ãƒ¼ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ãŒè¡¨ç¤ºã•ã‚Œã‚‹ç®‡æ‰€ãŒã‚ã‚Šã€ãã‚Œã‚‰è¡¨ç¤ºã®ä¸€éƒ¨ã«ã€æœ¬æ¥ã¨ã¯åˆ¥ã®SQLæ–‡ã®æ¤œç´¢çµæžœã‚’è¡¨ç¤ºã•ã›ã‚‹ã“ã¨ã§ã€éš ã‚ŒãŸæƒ…å ±ã‚’è¡¨ç¤ºã—ã¾ã™ã€‚ ã—ã‹ã—ã€SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³è„†å¼±æ€§ã¯ã‚ã‚‹ãŒã€è¡¨ç¤ºã¨ã—ã¦æ¤œç´¢çµæžœã®è¡¨ç¤ºã‚‚ãªãã€ã‚¨ãƒ©ãƒ¼ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã«ã‚‚SQLã®ã‚¨ãƒ©ãƒ¼ãŒè¡¨ç¤ºã•ã‚Œãªã„å ´åˆãŒã‚ã‚Šã¾ã™ã€‚ä¾‹ãˆã°ã€ä»¥ä¸‹ã«ç´¹ä»‹ã™ã‚‹ä¾‹ã§ã¯ã€æŒ‡å®šã—ãŸãƒ¡ãƒ¼ãƒ«ã‚¢ãƒ‰ãƒ¬ã‚¹ãŒç™»éŒ²æ¸ˆã¿ã‹ã©ã†ã‹ã®ã¿ã‚’è¿”
teddy-g 2018/02/18
åœ°å‘³ãªæ–¹æ³•ã§å°‘ã—ãšã¤DBã®ä»•çµ„ã¿ã‚’ã²ã‚‚ã¨ãã€ãã‚ŒãŒãƒ–ãƒ©ã‚¤ãƒ³ãƒ‰SQLi

cybersecurity

cyberattacks

security

sql

sqli
ãƒªãƒ³ã‚¯
æ—¥ä»˜ãƒ»æ™‚åˆ»é–¢æ•°ï½œMySQLå†…éƒ¨é–¢æ•°ï½œMySQLï½œPHP & JavaScript Room
æ—¥ä»˜å½¢å¼ã¾ãŸã¯æ—¥ä»˜æ™‚åˆ»å½¢å¼ã§æŒ‡å®šã—ãŸæ—¥ä»˜dateã®æ›œæ—¥ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ï¼ˆ1=æ—¥ã€2=æœˆã€3=ç«ã€4=æ°´ã€5=æœ¨ã€6=é‡‘ã€7=åœŸï¼‰ã‚’è¿”ã—ã¾ã™ã€‚ å˜åœ¨ã—ãªã„æ—¥ä»˜ã‚„æ—¥ä»˜æ™‚åˆ»ã‚’æŒ‡å®šã—ãŸå ´åˆã¯ã€NULLãŒè¿”ã‚Šã¾ã™ã€‚ mysql> SELECT DAYOFWEEK('2006-12-25'); Enter +-------------------------+ | dayofweek('2006-12-25') | +-------------------------+ | 2 | +-------------------------+ 1 row in set (0.00 sec) mysql> SELECT DAYOFWEEK('2006-12-25 23:50:00'); Enter +----------------------------------+ | dayofweek('2006-12-
teddy-g 2015/12/03
WEEKDAYã¨ã‹HOURã¨ã‹MySQLã®æ—¥ä»˜ãƒ»æ™‚åˆ»é–¢æ•°ä¸€è¦§ã€‚çµæ§‹è‰²ã€…ã‚ã‚‹ã€‚

mysql

database

sql
ãƒªãƒ³ã‚¯
CASEå¼ã®ã‚¹ã‚¹ãƒ¡ / ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸–ç•Œ
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
teddy-g 2015/12/02
case selectä½¿ã†ã¨sqlã§çµæ§‹å‡¦ç†ãŒå®Œäº†ã™ã‚‹ã€‚ãƒžã‚¨ã‚·ãƒ§ãƒªã‚¹ãƒˆã«ã¯å¿…é ˆã€‚

database

sql

mysql
ãƒªãƒ³ã‚¯
MySQLã§DATETIMEåž‹ã®æ™‚åˆ»å·®ã‚’è¨ˆç®— - åœ°ä¸ã¸ã®ã¯ã—ã”
MySQLä¸Šã§ã€DATETIMEåž‹ã®æ™‚é–“å·®ã‚’å‡ºã™æ–¹æ³•ã§ã™ã€‚ åƒ•ã®å ´åˆã€å‡ºã—ãŸå€¤ã‚’åˆè¨ˆã—ã¦ã€ãã®å¾ŒPHPã§æ‰±ã†æµã‚Œã§ã—ãŸã®ã§ã€UNIX_TIMESTAMPã§å¤‰æ›ã—ã¦ã‹ã‚‰å·®ã‚’å‡ºã™æ–¹æ³•ã‚’æŽ¡ç”¨ã—ã¾ã—ãŸã€‚ è¤‡æ•°ã®æ–¹æ³•ã§çµæžœã‚’å‡ºã—ã¦ã¿ã‚‹ å·¦2ã¤ã®ãƒ‡ãƒ¼ã‚¿ã®å·®åˆ†ã‚’ã€ã‚«ãƒ©ãƒ åã®æ–¹æ³•ã§å‡ºã—ã¦ã„ã¾ã™ã€‚ ãã®ã¾ã¾æ¸›ç®— æ•°å—åˆ—ã®å·®åˆ†ã«ãªã‚Šã¾ã™ã€‚ SELECT datetime1 - datetime2 FROM table_name UNIXTIMESTAMPåŒ–ã—ã¦ã‹ã‚‰è¨ˆç®— ç§’æ•°ã§å–å¾—ã§ãã¾ã™ã€‚ SELECT UNIX_TIMESTAMP( datetime1 ) - UNIX_TIMESTAMP( datetime2 ) FROM table_name SUBTIME()ã§è¨ˆç®— å¾Œã‚ã®å¼•æ•°ã¯æ™‚åˆ»ã§ã¯ãªãæ™‚é–“ã‚’è¡¨ã™å€¤ã§ãªã‘ã‚Œã°ãªã‚‰ãªã„ã‚ˆã†ã§ã™ã€‚ SELECT SUBTIME(datetime1,datetime2)
teddy-g 2015/11/08
MySQLã§æ—¥ä»˜åž‹è¨ˆç®—ã™ã‚‹ã¨ãã¯UNIX_TIMESTAMP

MySQL

sql

tips
ãƒªãƒ³ã‚¯
HTML5 - Web SQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ - ã¨ã»ã»ã®WWWå…¥é–€
ã‚µãƒ³ãƒ—ãƒ«ã¯ã“ã¡ã‚‰ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹(testDB)ã®ä¸ã«ãƒ†ãƒ¼ãƒ–ãƒ«(test)ã‚’ä½œæˆã—ã€2ä»¶ã®ãƒ‡ãƒ¼ã‚¿ã‚’ INSERT ã—ã€ãã®ãƒ‡ãƒ¼ã‚¿ã‚’ SELECT ã§èªã¿å‡ºã—ã¦è¡¨ç¤ºã—ã¦ã„ã¾ã™ã€‚ Web SQL Database Sample <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>Web SQL Database Sample</title> <style> #message { margin:1em; width:500px; border:1px solid gray; padding:1em; } </style> <script> function print(msg) { document.getElementById("message").innerHTML += msg + "<br>"; } function te
teddy-g 2014/09/08
Web SQLã®è§£èª¬ã€‚SQLiteã¯æ¨™æº–ã˜ã‚ƒãªããªã£ãŸã‚“ã ãªã€‚

html5

websql

database

web

sql
ãƒªãƒ³ã‚¯
MySQL ã®NULL ã§ã¯ã¾ã£ãŸã“ã¨ã‚ã‚Œã“ã‚Œ - LukeSilviaâ€™s diary
MySQL ã«é™ã‚‰ãšã€SQL ã®NULL ã®ä»•æ§˜ã«ã¯ä½•å›žã‹ã€Œãˆã£ã€ã¨é©šãã“ã¨ãŒã‚ã£ãŸã®ã§ãƒ¡ãƒ¢ã—ã¦ãŠã“ã†ã¨æ€ã„ã¾ã™ã€‚5.1 ç‰ˆã®æ—¥æœ¬èªžãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ãŒãªã‹ã£ãŸã‚‚ã®ã«ã¤ã„ã¦ã¯ã€4.1 ã®ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã‚’å‚ç…§ã—ã¾ã—ãŸã€‚ ãã‚‚ãã‚‚NULL ã¯ä½•ã‚’æ„å‘³ã™ã‚‹ã‹ NULL ã¯æœªå®šç¾©ã¾ãŸã¯ã€ä¸æ˜Žã‚’æ„å‘³ã™ã‚‹ã€‚ã€Œé›»è©±ç•ªå·ã‚’æŒãŸãªã„ã€ã¨ã„ã†ã“ã¨ã‚’è¡¨ç¾ã™ã‚‹å ´åˆã¯ã€NULL ã§ã¯ãªãã€ç©ºã®æ–‡å—åˆ—ã‚’ä½¿ã†ã€‚ NULL å€¤ã¨ã„ã†ã‚‚ã®ã‚’ SQL åˆå¿ƒè€…ã¯ã‚ˆãæ··ä¹±ã—ã¾ã™ã€‚SQL åˆå¿ƒè€…ã¯ã€å¤šãã®å ´åˆã€NULL ãŒç©ºæ–‡å— "" ã¨åŒã˜ã§ã‚ã‚‹ã¨è€ƒãˆã¦ã—ã¾ã„ã¾ã™ã€‚ã“ã‚Œã¯é•ã„ã¾ã™ã€‚ãŸã¨ãˆã°ã€ä»¥ä¸‹ã®ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã¯å®Œå…¨ã«åˆ¥ã®ã‚‚ã®ã§ã™ã€‚ mysql> INSERT INTO my_table (phone) VALUES (NULL); mysql> INSERT INTO my_table (phone) VALUES (""); ã©ã¡ã‚‰ã®ã‚¹
teddy-g 2014/02/21
NULLã¨''ã¯é•ã†ã®ã‚ˆã

mysql

sql

tips

hacks
ãƒªãƒ³ã‚¯
nullã¨åŒã˜ãç©ºç™½ã‚’Countã—ãªã„æ–¹æ³•ã¯ï¼Ÿ - OKWAVE
ï¼£ï¼¯ï¼µï¼®ï¼´ã®ä½¿ã„æ–¹ ï¼ï½™ï¼³ï¼±ï¼¬ï¼”ï¼Žï¼ï¼Žï¼’ï¼–ã¨ï¼°ï¼¨ï¼°ã‚’ä½¿ã£ã¦ã¨ã‚ã‚‹ã‚·ã‚¹ãƒ†ãƒ ã‚’æ§‹ç¯‰ã—ã¦ã„ã¾ã™ã€‚ ï¼¡ã¨ï¼¢ã¨ã„ã†ãƒ†ãƒ¼ãƒ–ãƒ«ãŒã‚ã£ã¦ã€ãã‚Œãžã‚Œã®ãƒ†ãƒ¼ãƒ–ãƒ«ã«ç™»éŒ²ã—ã¦ã‚ã‚‹ãƒ¬ã‚³ãƒ¼ãƒ‰æ•°ã®åˆè¨ˆã‚’æ±‚ã‚ãŸã„ã®ã§ã™ãŒã€ã“ã†ã„ã†å ´åˆã¯ã§ãã‚‹ã®ã§ã—ã‚‡ã†ã‹ï¼Ÿ SELECTã€€count(*)ã€€FROMã€€ãƒ†ãƒ¼ãƒ–ãƒ«Aã§ãƒ†ãƒ¼ãƒ–ãƒ«Aã®ãƒ¬ã‚³ãƒ¼ãƒ‰æ•°ã¯æ±‚ã‚ã‚‰ã‚Œã¾ã™ãŒã€SELECT COUNT(*) FROM ãƒ†ãƒ¼ãƒ–ãƒ«Aã€ãƒ†ãƒ¼ãƒ–ãƒ«Bã¨ã™ã‚‹ã¨ãŠã‹ã—ãªä»¶æ•°ã«ãªã£ã¦ã—ã¾ã„ã¾ã™ã€‚ ã§ãã‚Œã°ä¸€ã¤ã®ã‚¯ã‚¨ãƒªã§å‡¦ç†ã—ãŸã„ã¨æ€ã£ã¦ã„ã‚‹ã®ã§ã™ãŒã€‚ åˆå¿ƒè€…çš„è³ªå•ã§ã™ã„ã¾ã›ã‚“ã€‚å®œã—ããŠé¡˜ã„ã—ã¾ã™ã€‚ è¤‡æ•°JOINã—ã¦ã„ã‚‹ã¨COUNTãŒæ£ã—ãå–å¾—ã§ããª LAMPç’°å¢ƒã§é–‹ç™ºã‚’ã—ã¦ã„ã¾ã™ã€‚ SQLæ–‡ã§COUNTã‚’æ±‚ã‚ã‚‹éš›ã«ã€ã¾ã¨ã‚ã¦çµæžœã‚’æ±‚ã‚ã‚ˆã†ã¨ã—ã¦ä¸Šæ‰‹ãè¡Œãã¾ã›ã‚“ã€‚ çŠ¶æ³ã¨ã—ã¦ã¯ä»¥ä¸‹ã§ã™ã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«dã¯idã‚’keyã«a,b,cï¼“ã¤ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã¨joinã—ã¦ã„ã¾ã™ã€‚ id
teddy-g 2014/02/21
IFä½¿ã£ã¦0ã‚’nullã«ã—ã¦ã‚ã’ã‚Œã°COUNTã§ã‚«ã‚¦ãƒ³ãƒˆã§ãã‚‹ã€‚ã•ã‚‚ãªã„ã¨0ã¯ã‚«ã‚¦ãƒ³ãƒˆã•ã‚Œã¡ã‚ƒã†ã€‚

mysql

sql

tips

hacks
ãƒªãƒ³ã‚¯
2007-07-05
æœ€è¿‘ã€Œå‹•çš„åž‹ä»˜è¨€èªžã€ã¨ã„ã†è¨€è‘‰ã«ã‹ãªã‚Šé•å’Œæ„Ÿã‚’æ„Ÿã˜ã¾ã™ã€‚ ãã‚“ãªä»Šæ—¥ã“ã®é ƒã§ã™ã€‚ çª“ã®æœ - ã€NEWSã€‘SQLæ–‡ã‚’GUIã§ä½œæˆã§ãã‚‹ãƒ•ãƒªãƒ¼ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é–‹ç™ºç’°å¢ƒã€Œé»’çŒ« SQL Studioã€NEW! http://www.forest.impress.co.jp/article/2007/07/04/kuronekosql.html ã¯ã¦ãƒ–ã§è¦‹ã¤ã‘ãŸã‚“ã§ã™ã‘ã©ã€ä½•ã‹ã‚ˆã•ã’ãªãƒ„ãƒ¼ãƒ«ãªã‚“ã ã‘ã©ãƒ»ãƒ»ãƒ»ãªã‚“ã ã‹ã•ãã£ã¨ã€ã“ã†ã„ã†ãƒ„ãƒ¼ãƒ«ã‚’ä¸€ç•ªä½¿ã„ãã†ãªé€£ä¸ãŒä½¿ã£ã¦ã„ãã†ãªDBã€MySQLã«æŽ¥ç¶šã§ããªãã¦ãƒ„ã‚«ã‚¨ãƒã‚§ãƒ„ãƒ¼ãƒ«ã®çƒ™å°ãŒæŠ¼ã•ã‚Œãã†ãªã®ã§ãƒ¡ãƒ¢ã£ã¦ãŠã ODBCãƒ‰ãƒ©ã‚¤ãƒã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« ãƒªãƒ¼ãƒ‰ãƒŸãƒ¼ã‚’èªã‚€ã¨MySQLã«ã‚‚æŽ¥ç¶šã§ãã‚‹ã‚ˆã£ã¦æ›¸ã„ã¦ã‚ã‚‹ã®ã§è©¦ã™ ã¾ãšODBCã‚³ãƒã‚¯ã‚¿ãƒ¼ã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¦ã‚¤ãƒ³ã‚¹ã‚³ã™ã‚‹ å½“ç„¶ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ©ãƒ¼ã§ã‚µãƒƒã‚¯ãƒƒã¨ã§ã™ã€‚ http://dev.mysql.com/downlo
teddy-g 2008/06/09
é»’çŒ«SQLã§MySQLä½¿ã†æ–¹æ³•

sql

mysql

DB
ãƒªãƒ³ã‚¯
ã¤ã¿ãWeb
teddy-g 2008/06/02
SQLé–‹ç™ºç’°å¢ƒCSEã®ãƒšãƒ¼ã‚¸

sql

DB

mysql
ãƒªãƒ³ã‚¯
PEAR MDB2ã§PHPã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ“ä½œã™ã‚‹ï¼šCodeZine
ã¯ã˜ã‚ã«ã€€PHPã«ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹æ–¹æ³•ãŒã„ãã¤ã‹ç”¨æ„ã•ã‚Œã¦ã„ã¾ã™ã€‚ãã®ã‚ˆã†ãªæ–¹æ³•ã®ä¸€ã¤ã«ã€ã€ŒPEAR MDB2ã€ãŒã‚ã‚Šã¾ã™ã€‚åå‰ã®é€šã‚ŠPEARã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã¨ã—ã¦å…¬é–‹ã•ã‚Œã¦ã„ã¾ã™ã€‚PEARã«ã¯MDB2ã®ã»ã‹ã«ã€ŒDBã€ã‚„ã€ŒMDBã€ã¨ã„ã£ãŸãƒ©ã‚¤ãƒ–ãƒ©ãƒªãŒã‚ã‚Šã€ç¾åœ¨ã§ã‚‚åˆ©ç”¨ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ã—ã‹ã—ãªãŒã‚‰ã€ã“ã‚Œã‚‰ã®é–‹ç™ºã¯ã™ã§ã«çµ‚äº†ã—ã¦ãŠã‚Šã€é–‹ç™ºè€…ã¯MDB2ã«ç§»è¡Œã™ã‚‹ã“ã¨ãŒæŽ¨å¥¨ã•ã‚Œã¦ã„ã¾ã™ã€‚ã€€æœ¬ç¨¿ã§ã¯ã€PEAR MDB2ã‚’ä½¿ã£ã¦ã€PHPã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ“ä½œã™ã‚‹æ¬¡ã®ã‚ˆã†ãªåŸºæœ¬çš„ãªæ–¹æ³•ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚PEAR MDB2ã‚’ä½¿ã†ã¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ï¼ˆMySQLã‚„PostgreSQLã€SQLiteç‰ï¼‰ã«ä¾å˜ã—ãªã„ã‚³ãƒ¼ãƒ‰ã‚’æ›¸ãã“ã¨ãŒã§ãã‚‹ã€‚SQLã®å®Ÿè¡Œã«ã¯ã€ãƒ—ãƒªãƒšã‚¢ãƒ¼ãƒ‰ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã‚’ä½¿ã†ã®ãŒåŸºæœ¬ã§ã‚ã‚‹ï¼ˆä¾‹å¤–ã‚ã‚Šï¼‰ã€‚PHPã«ã¯PEAR MDB2ã®ä»–ã«ã‚‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¸ã®ã‚¢ã‚¯ã‚»ã‚¹æ‰‹æ®µãŒæ•°å¤šãç”¨æ„ã•ã‚Œ
teddy-g 2008/06/02
PEAR MDB2ã®èª¬æ˜Žã€‚

php

pear

mysql

sqlite

sql

DB
ãƒªãƒ³ã‚¯
MySQL :: MySQL 5.6 ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢ãƒ« :: 12.19.1 GROUP BY (é›†ç´„) é–¢æ•°
ã“ã®ã‚»ã‚¯ã‚·ãƒ§ãƒ³ã§ã¯ã€å€¤ã®ã‚»ãƒƒãƒˆã‚’æ¼”ç®—ã™ã‚‹ã‚°ãƒ«ãƒ¼ãƒ— (é›†ç´„) é–¢æ•°ã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã™ã€‚ç‰¹ã«æŒ‡å®šã•ã‚Œã¦ã„ãªã‘ã‚Œã°ã€ã‚°ãƒ«ãƒ¼ãƒ—é–¢æ•°ã§ã¯ NULL å€¤ãŒç„¡è¦–ã•ã‚Œã¾ã™ã€‚ GROUP BY å¥ã‚’å«ã¾ãªã„ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã§ã‚°ãƒ«ãƒ¼ãƒ—é–¢æ•°ã‚’ä½¿ç”¨ã™ã‚‹å ´åˆã¯ã€ã™ã¹ã¦ã®è¡Œã‚’ã‚°ãƒ«ãƒ¼ãƒ—åŒ–ã™ã‚‹ã“ã¨ã¨åŒç‰ã«ãªã‚Šã¾ã™ã€‚è©³ç´°ã¯ã€ã‚»ã‚¯ã‚·ãƒ§ãƒ³12.19.3ã€ŒMySQL ã§ã® GROUP BY ã®å‡¦ç†ã€ã‚’å‚ç…§ã—ã¦ãã ã•ã„ã€‚ æ•°å€¤ã®å¼•æ•°ã®å ´åˆã€åˆ†æ•£ãŠã‚ˆã³æ¨™æº–åå·®é–¢æ•°ãŒ DOUBLE å€¤ã‚’è¿”ã—ã¾ã™ã€‚SUM() ãŠã‚ˆã³ AVG() é–¢æ•°ã¯ã€æ£ç¢ºãªå€¤ã®å¼•æ•° (æ•´æ•°ã¾ãŸã¯ DECIMAL) ã®å ´åˆã¯ DECIMAL å€¤ã‚’è¿”ã—ã€è¿‘ä¼¼å€¤ã®å¼•æ•° (FLOAT ã¾ãŸã¯ DOUBLE) ã®å ´åˆã¯ DOUBLE å€¤ã‚’è¿”ã—ã¾ã™ã€‚ SUM() ãŠã‚ˆã³ AVG() é›†è¨ˆé–¢æ•°ã¯æ™‚é–“å€¤ã‚’æ‰±ã„ã¾ã›ã‚“ã€‚(ã“ã‚Œã‚‰ã¯å€¤ã‚’æ•°å—ã«å¤‰æ›ã™ã‚‹ã®ã§ã€æœ€åˆã®æ•°å—ä»¥å¤–ã®æ–‡å—ã®ã‚ã¨ã®ã™ã¹ã¦
teddy-g 2006/03/07
MySQLã®GROUP BY

mysql

sql
ãƒªãƒ³ã‚¯
PHP: SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ - Manual
teddy-g 2005/12/22
SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã«ã¤ã„ã¦ã®PHPãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ãƒšãƒ¼ã‚¸

php

sql

security
ãƒªãƒ³ã‚¯
1