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

hogem id:hogem

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

${{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ãƒ†ãƒ¼ãƒ–ãƒ«çµåˆ - ã“ã›ãã®æŠ€è¡“æ—¥è¨˜
ãƒ†ãƒ¼ãƒ–ãƒ«ã®JOINãŒè‹¦æ‰‹ã§ã—ãŸãŒã€ã“ã®ä¾‹ã‚’æ€ã„ã¤ã„ã¦ã‹ã‚‰ã¯ã€ã™ã£ãã‚Šãã£ãã‚Šç†è§£ã§ãã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸã€‚ã‚€ã—ã‚é ã‹ã‚‰é›¢ã‚Œã¾ã›ã‚“â€¦â€¦ã€‚ â€» INNERã€OUTERã¯é£¾ã‚Šã€‚çœç•¥ã§ãã‚‹ã€‚ INNER JOIN â†’ JOIN LEFT OUTER JOIN â†’ LEFT JOIN RIGHT OUTER JOIN â†’ RIGHT JOIN â€» ON ...=... ã‚’ã¾ã¨ã‚ã¦ USING(å±žæ€§) ã¨æ›¸ã‘ã‚‹ã€‚ â€» ä½•ã§çµåˆã™ã‚‹ã‹è¨€ã†ã¾ã§ã‚‚ãªã„æ™‚ã¯ã€NATURALã‚’æŒ‡å®šã™ã‚‹ã¨å‹æ‰‹ã«JOINã—ã¦ãã‚Œã‚‹ã€‚NATURALã«JOINã—ã¦â€¦â€¦ã€‚ â€» WHEREã¯çµåˆã—ãŸçµæžœã«ä½œç”¨ã™ã‚‹ã€‚ â€» ç¾å®Ÿã«ã¯ä¸Šå›³ã®ã‚ˆã†ã«1å¯¾1ã§çµåˆã—ã¾ã›ã‚“ã€‚ â€» ãŠã¾ã‘ã€‚CROSS JOINã€‚ ã“ã‚“ãªã®ä½¿ã„ã¾ã›ã‚“ã€‚ ãƒ–ã‚¯ãƒžç”¨ç”»åƒã€‚
hogem 2010/09/17
åœ°ç„ã®ã‚ˆã†ã«ã‚ˆãã‚ã‹ã‚‹ä»£å„Ÿã¨ã—ã¦ã€åœ°ç„ã®ã‚ˆã†ã«åˆ‡ãªããªã‚Šã¾ã™

database

sql
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è² è·ãƒ†ã‚¹ãƒˆãƒ„ãƒ¼ãƒ«ã¾ã¨ã‚(3) - SH2ã®æ—¥è¨˜
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è² è·ãƒ†ã‚¹ãƒˆãƒ„ãƒ¼ãƒ«ã¾ã¨ã‚ã®ç¬¬3å›žã§ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è² è·ãƒ†ã‚¹ãƒˆãƒ„ãƒ¼ãƒ«ã¾ã¨ã‚(1) TPC-Bã€TPC-Wãƒ™ãƒ¼ã‚¹ã®ãƒ„ãƒ¼ãƒ«ã‚’6ã¤ç´¹ä»‹ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è² è·ãƒ†ã‚¹ãƒˆãƒ„ãƒ¼ãƒ«ã¾ã¨ã‚(2) TPC-Cãƒ™ãƒ¼ã‚¹ã®ãƒ„ãƒ¼ãƒ«ã‚’6ã¤ç´¹ä»‹ ã‹ãªã‚ŠæœŸé–“ãŒç©ºã„ã¦ã—ã¾ã„ã¾ã—ãŸãŒã€ä»Šå›žã¯TPC-Hãƒ™ãƒ¼ã‚¹ã®ãƒ„ãƒ¼ãƒ«ã‚’è¦‹ã¦ã„ããŸã„ã¨æ€ã„ã¾ã™ã€‚ TPC-Hã¨ã¯ TPC-Hã¯RDBMSãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ä»•æ§˜ã®ä¸€ã¤ã§ã€æ„æ€æ±ºå®šæ”¯æ´ã‚·ã‚¹ãƒ†ãƒ (DSS)ã¨ã—ã¦ã®æ€§èƒ½ã‚’æ¸¬å®šã™ã‚‹ã‚‚ã®ã§ã™ã€‚å¤§è¦æ¨¡ãªãƒ‡ãƒ¼ã‚¿ã‚’å¯¾è±¡ã«ã‚¢ãƒ‰ãƒ›ãƒƒã‚¯ãªã‚¯ã‚¨ãƒªã‚’å®Ÿè¡Œã—ã¾ã™ã€‚ã‚¯ã‚¨ãƒªã¯å…¨éƒ¨ã§22ç¨®é¡žå®šç¾©ã•ã‚Œã¦ã„ã¾ã™ã€‚ TPC-Hã¯TPC-B/W/Cãªã©ã¨ç•°ãªã‚Šã€å®Ÿè¡Œã™ã‚‹ã‚¯ã‚¨ãƒªãã®ã‚‚ã®ã‚„ãƒ†ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿ç”Ÿæˆãƒ„ãƒ¼ãƒ«ãŒTPCã‹ã‚‰æä¾›ã•ã‚Œã¦ã„ã¾ã™ã€‚è©¦ã—ã«ã€ä¸€ç•ªè² è·ãŒé«˜ã„9ç•ªã®ã‚¯ã‚¨ãƒªã‚’ç¢ºèªã—ã¦ã¿ã¾ã—ã‚‡ã†ã€‚ -- $ID$ -- TPC-H/TPC-R Product Type Profit Me
hogem 2010/01/12
mysql

benchmark

sql
ãƒªãƒ³ã‚¯
SQL ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžè³‡æ–™ - SAK Streets
SQL é–‹ç™ºè¨€èªžè³‡æ–™ SQL ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžè³‡æ–™ SQL åŸºç¤Žç·¨ SQL åŸºç¤Žå®Ÿåœ°ç·¨ SQL ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ç·¨ Oracle PL/SQL ç·¨ PostgreSQL ç·¨ã€JAVA Servletã€JSP ç·¨ MySQL ç·¨ SQL ãã®ä»–å¿œç”¨ç·¨ VB ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžè³‡æ–™ VB RDO + SQL å¿œç”¨ç·¨ VB ADO + SQL å¿œç”¨ç·¨ VB oo4o + SQL å¿œç”¨ç·¨ ASP VB Script ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžè³‡æ–™ ASP VB Script ADO + SQL å¿œç”¨ç·¨ ASP VB Script oo4o + SQL å¿œç”¨ç·¨ SQL åŸºç¤Žç·¨ 2000.10.14 SQL åŸºç¤Žç·¨ (ãã®ä¸€) ãƒ†ãƒ¼ãƒ–ãƒ«æ“ä½œ create tableã€alter tableã€drop table SQL åŸºç¤Žç·¨ - ã€è£œè¶³ã€‘è¤‡åˆã‚ãƒ¼ alter tableã€primary key 2000.10
hogem 2007/10/17
mysql

sql

postgresql
ãƒªãƒ³ã‚¯
ã„ã¾ã®æ°—æŒã¡ã‚’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(æ¼ã‚Œã®ç²¾æ¶²)
hogem 2007/05/27
2ch

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
hogem 2007/03/17
sql

security

cheatsheet
ãƒªãƒ³ã‚¯
PostgreSQLã‚’ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ã§æ“ä½œã™ã‚‹
ä»Šå›žã®ãŠã‚‚ãªå†…å®¹ ã‚½ãƒ¼ã‚¹ã‹ã‚‰ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« ã‚³ãƒ³ãƒ‘ã‚¤ãƒ«ã¨ãƒã‚¤ãƒŠãƒªã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« PostgreSQLã®åˆæœŸåŒ– ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½œæˆ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚’æ“ä½œã™ã‚‹ ãƒ†ãƒ¼ãƒ–ãƒ«ã«ãƒ‡ãƒ¼ã‚¿ã‚’è¿½åŠ selectæ–‡ã§æ¤œç´¢ psqlã§ä½¿ãˆã‚‹ã‚³ãƒžãƒ³ãƒ‰ä¸€è¦§ PostgreSQLã¯ã€Linuxã‚„FreeBSDãŠã‚ˆã³ä¸€éƒ¨ã®å•†ç”¨UNIXã§ã¯ã€ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã‚·ã‚¹ãƒ†ãƒ ã‚’ç”¨ã„ã¦ç°¡å˜ã«ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ã“ã¨ã‚‚å¯èƒ½ã§ã™ã€‚ãŸã ã—RedHatç³»ã®Linuxï¼ˆRedHatã‚„Turbo Linuxã€Vine Linuxãªã©ï¼‰ã§ã¯ã€/usrç›´ä¸‹ã®ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªï¼ˆ/usr/binã‚„/usr/libï¼‰ã«ãƒ•ã‚¡ã‚¤ãƒ«ãŒé…ç½®ã•ã‚Œã¦ã€å¾Œã§ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ã™ã‚‹å ´åˆãªã©ã«å°‘ã—æˆ¸æƒ‘ã„ã‚’æ„Ÿã˜ã‚‹ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ï¼ˆå˜ã«ç†è€…ã ã‘ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ãŒ^^;;ï¼‰ã€‚ ãã†ã„ã†ã¨ãã¯ã€ãœã²ã¨ã‚‚PostgreSQLã‚’ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã‹ã‚‰ã‚³ãƒ³ãƒ‘ã‚¤ãƒ«ã—ã¾ã—ã‚‡ã†ã€‚ãã®æ‰‹é †ã‚’ç´¹ä»‹ã—
hogem 2007/01/27
postgresql

sql
ãƒªãƒ³ã‚¯
1