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

ori53 id:ori53

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

${{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 ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£æ•™è‚²ã¯è«–ç†çš„ã«ç ´ç¶»ã—ã¦ã„ã‚‹ | yohgaki's blog ã€Œãƒ—ãƒªãƒšã‚¢ãƒ¼ãƒ‰ã‚¯ã‚¨ãƒªãŒåŸºæœ¬ã ã‘ã©ã€å‹•çš„ã« SQL ã‚’çµ„ã¿ç«‹ã¦ã‚‹å ´åˆã‚‚ã‚ã‚‹ã‹ã‚‰ã€ãã†ã„ã†å ´åˆã«å‚™ãˆã¦ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ã‚‚çŸ¥ã£ã¦ãŠã„ãŸã»ã†ãŒã„ã„ã‹ã‚‚ã€ - Togetterã¾ã¨ã‚ SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³å¯¾ç–ã§å¤§åž£é–ç”·æ°ã¯ä½•ã‚’å‹˜é•ã„ã—ã¦ã„ãŸã‹ | [ bROOM.LOG ! ] ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ã¨ãƒ—ãƒ¬ãƒ¼ã‚¹ãƒ›ãƒ«ãƒ€ã‚’ã‚ãã‚‹è°è«– - Togetterã¾ã¨ã‚ SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³å¯¾ç–ã¨ã—ã¦ã®ãƒ—ãƒªãƒšã‚¢ãƒ‰ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã¨ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ã«ã¤ã„ã¦ã®è°è«– - Togetterã¾ã¨ã‚ IPAã®ã€Œå®‰å…¨ãªSQLã®å‘¼ã³å‡ºã—æ–¹ã€ãŒå®‰å…¨ã«ãªã£ã¦ã„ãŸ | yohgaki's blog SQLã¸ã®å®‰å…¨ãªå€¤ã®åŸ‹ã‚è¾¼ã¿æ–¹ã«ã¤ã„ã¦ã€ã“ã“æ•°æ—¥ã§è‰²ã€…è°è«–ã¨ã„ã†ã‹æ„è¦‹ã®æŠ•ã’åˆã„ãŒã‚ã‚Šã¾ã—ãŸãŒã€è‡ªåˆ†ã¨ã—ã¦ã®è€ƒãˆã‚’ã¾ã¨ã‚ã¦ãŠãã¾ã™ã€‚ 1. SQLã«å€¤ã‚’åŸ‹ã‚è¾¼ã‚€å ´åˆã¯ã€ãƒ—ãƒªãƒš
ori53 2014/04/11
sql

security
ãƒªãƒ³ã‚¯
ç´¹ä»‹ï¼šã€æ›¸ç±ã€‘SQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³
ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®çˆ¶ã€ã‚¨ãƒ‰ã‚¬ãƒ¼ãƒ»Fãƒ»ã‚³ãƒƒãƒ‰æ°ãŒè«–æ–‡ã‚’ç™ºè¡¨ã—ãŸã®ã¯1970å¹´ã€‚ç§ãŒç”Ÿã¾ã‚Œã‚‹å‰ã®è©±ã§ã‚ã‚‹ã€‚ãã—ã¦SQLãŒANSIæ¨™æº–ã«ãªã£ãŸã®ãŒ1986å¹´ã€‚RDBMSã‚’ã€ãã—ã¦SQLã‚’ä½¿ã£ãŸã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºã¯å¸¸ã«ä¸»æµã§åœ¨ã‚Šç¶šã‘ãŸã¨è¨€ã£ã¦ã‚‚éŽè¨€ã§ã¯ãªã„ã€‚ãã‚“ãªæ´å²ã®ã‚ã‚‹SQLã§ã‚ã‚‹ãŒã€æœªã ã«å¤šãã®äººã¯SQLã‚’ä½¿ã„ã“ãªã›ã¦å±…ãªã„ã‚ˆã†ã«è¦‹ãˆã‚‹ã€‚ SQLã¯ã¨ã¦ã‚‚å¥¥ãŒæ·±ã„ã€‚ã‚½ãƒ¼ãƒˆã‚„ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãŒä½¿ç”¨å‡ºæ¥ã‚‹ãŠã‹ã’ã§ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ¢ãƒ‡ãƒ«ã‚’ç„¡è¦–ã—ã¦å˜ãªã‚‹ãƒ‡ãƒ¼ã‚¿ã®å…¥ã‚Œç‰©ã¨ã—ã¦ä½¿ã£ã¦ã‚‚ãã‚Œãªã‚Šã«ä¾¿åˆ©ã ã£ãŸã‚Šã™ã‚‹ã€‚ã ãŒã€ãã‚ŒãŒä»Šç¾åœ¨å¤šãã®æ‚²åŠ‡ã‚’ç”Ÿã‚“ã§ã„ã‚‹åŽŸå› ã§ã‚‚ã‚ã‚‹ã€‚å¤šãã®äººãŒåŒã˜ã‚ˆã†ã«SQLã‚’ç†è§£ã›ãšã€ãã®ãŸã‚å¤šãã®äººãŒåŒã˜æ‚²åŠ‡ã«è¦‹èˆžã‚ã‚Œã‚‹ã€‚ãã†ã€ãã‚ŒãŒã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã§ã‚ã‚‹ï¼ ä»Šå›žç´¹ä»‹ã™ã‚‹SQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã¯ã€æ´‹æ›¸SQL Antipatternsã®é‚¦è¨³ç‰ˆã ã€‚ç§ã¯å…ƒã€…è‹±èªžç‰ˆã®ãƒ•ã‚¡ãƒ³ã§ã§ã‚ã‚Šã€äººã€…ãŒé™¥ã‚Š
ori53 2013/01/26
sql

æœ¬
ãƒªãƒ³ã‚¯
SQL vs NoSQLã€ã‚°ãƒ¼ã‚°ãƒ«ã«ãŠã‘ã‚‹æˆ¦ã„ï¼ˆå‰ç·¨ï¼‰ã€‚Google I/O 2012
SQLã¨NoSQLã§ã¯ã©ã¡ã‚‰ãŒå„ªã‚Œã¦ã„ã‚‹ã®ã‹ï¼Ÿ ã‚°ãƒ¼ã‚°ãƒ«ã®æ‹…å½“è€…ãŒãƒ‡ã‚£ãƒ™ãƒ¼ãƒˆï¼ˆã¨ã„ã†ã‚ˆã‚Šå°èŠå±…ï¼š-ï¼‰ã‚’è¡Œã£ãŸã‚»ãƒƒã‚·ãƒ§ãƒ³ã€ŒGoogle I/O 2012 - SQL vs NoSQL: Battle of the Backends - YouTubeã€ãŒå…¬é–‹ã•ã‚Œã¦ã„ã¾ã™ã€‚ ã“ã®ã‚»ãƒƒã‚·ãƒ§ãƒ³ã¯ã€å…ˆã€…é€±é–‹å‚¬ã•ã‚ŒãŸGoogle I/O 2012ã§è¡Œã‚ã‚ŒãŸã‚‚ã®ã€‚SQLã¨NoSQLã«ã¯æ©Ÿèƒ½çš„ã«ã©ã®ã‚ˆã†ãªé•ã„ãŒã‚ã‚Šã€ã©ã†ä½¿ã„åˆ†ã‘ã‚‹ã¹ããªã®ã‹ã€æ˜Žç¢ºãªèª¬æ˜ŽãŒå‚è€ƒã«ãªã‚Šã¾ã™ã€‚ ãƒã‚¤ãƒ©ã‚¤ãƒˆã‚’ç´¹ä»‹ã—ã¾ã—ã‚‡ã†ã€‚ ã‚¯ãƒ©ã‚¦ãƒ‰ã«ãŠã‘ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ¡ãƒªãƒƒãƒˆ ã‚°ãƒ¼ã‚°ãƒ«ã®Alfred Fulleræ°ï¼ˆNoSQLæ‹…å½“ï¼‰ã€‚ ã‚¯ãƒ©ã‚¦ãƒ‰ã¯ãƒ•ã‚©ãƒ«ãƒˆãƒˆãƒ¬ãƒ©ãƒ³ãƒˆã§ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ä¸è¦ã€ãƒ‘ãƒƒãƒã‚‚ç§ãŸã¡ãŒé©ç”¨ã—ã¦ãŠã‚Šã€åˆ©ç”¨è€…ã¯é‹ç”¨ã«ã¤ã„ã¦å¿ƒé…ã™ã‚‹å¿…è¦ãŒãªã„ã€ã¨ã„ã£ãŸãƒ¡ãƒªãƒƒãƒˆãŒã‚ã‚‹ã€‚ ãƒ‡ãƒ¼ã‚¿ã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚„åœ°åŸŸåˆ†æ•£ã§ãƒ‡ãƒ¼ã‚¿ã‚‚ä¿å…¨ã•ã‚Œã€ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒ
ori53 2012/07/14
NOSQL

SQL
ãƒªãƒ³ã‚¯
[SQL Server] sqlcmd ãƒ¦ãƒ¼ãƒ†ã‚£ãƒªãƒ†ã‚£
é©ç”¨å¯¾è±¡: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW) Microsoft Fabric SQL Database sqlcmd ãƒ¦ãƒ¼ãƒ†ã‚£ãƒªãƒ†ã‚£ã‚’ä½¿ç”¨ã™ã‚‹ã¨ã€Transact-SQL ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã‚„ã‚·ã‚¹ãƒ†ãƒ ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã€ã‚¹ã‚¯ãƒªãƒ—ãƒˆ ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ä½¿ç”¨å¯èƒ½ãªã•ã¾ã–ã¾ãªãƒ¢ãƒ¼ãƒ‰ã§å…¥åŠ›ã§ãã¾ã™ã€‚ ã‚³ãƒžãƒ³ãƒ‰ ãƒ—ãƒãƒ³ãƒ—ãƒˆã€‚ ã‚¯ã‚¨ãƒª ã‚¨ãƒ‡ã‚£ã‚¿ãƒ¼ã§ã® SQLCMD ãƒ¢ãƒ¼ãƒ‰ã€‚ Windows ã‚¹ã‚¯ãƒªãƒ—ãƒˆ ãƒ•ã‚¡ã‚¤ãƒ«ã€‚ SQL Server ã‚¨ãƒ¼ã‚¸ã‚§ãƒ³ãƒˆ ã‚¸ãƒ§ãƒ–ã®ã‚ªãƒšãƒ¬ãƒ¼ãƒ†ã‚£ãƒ³ã‚° ã‚·ã‚¹ãƒ†ãƒ (cmd.exe) ã‚¸ãƒ§ãƒ– ã‚¹ãƒ†ãƒƒãƒ—ã€‚ Note Microsoft Entra ID ã¯Azure Active Directory (Azu
ori53 2011/06/14
SQL Server

sql
ãƒªãƒ³ã‚¯
ã¡ã‚‡ã£ã¨ä½¿ãˆã‚‹MySQLã®å°æŠ€5ã¤+1
ã“ã‚“ã«ã¡ã¯ã€‚æœ€è¿‘ã‚¬ã‚¹ã‚’æ¢ã‚ã‚‰ã‚Œæ¸©ã‚‚ã‚Šã®ç„¡ã„ç”Ÿæ´»ã‚’é€ã£ã¦ã„ã‚‹æ¾ç”°ã§ã™ã€‚ ä»Šå›žã¯æœ€è¿‘è‡ªåˆ†ãŒçŸ¥ã£ãŸMySQLã®å°æŠ€ã‚’ã„ãã¤ã‹æ›¸ã„ã¦ã¿ã¾ã™ã€‚ ã‚“ãªã‚‚ã‚“å¸¸è˜ã ã‚ï¼ã£ã¦ãƒã‚¿ãŒã‚ã£ã¦ã‚‚å„ªã—ãè¦‹å®ˆã£ã¦ã‚ã’ã¦ãã ã•ã„ã€‚ ã¾ãšä»Šå›žã®å®Ÿè¡Œã‚µãƒ³ãƒ—ãƒ«ã«ã¯ä»¥ä¸‹ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½¿ã£ã¦ã¾ã™ã€‚ mysql>Â SELECTÂ *Â FROMÂ user_m; +---------+----------+---------------------+ |Â user_idÂ |Â nameÂ Â Â Â Â |Â create_datetimeÂ Â Â Â Â | +---------+----------+---------------------+ |Â Â Â Â Â Â Â 1Â |Â atsushiÂ Â |Â 2007-05-17Â 21:53:40Â | |Â Â Â Â Â Â Â 2Â |Â joeÂ Â Â Â Â Â |Â 2007-05-17Â 21:53:59Â | |Â Â Â Â Â Â Â 3Â |Â masah
ori53 2011/06/07
mysql

sql
ãƒªãƒ³ã‚¯
MySQL :: MySQL 8.0 ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢ãƒ« :: 13.2.6.2 INSERT ... ON DUPLICATE KEY UPDATE ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆ
SAVEPOINTã€ROLLBACK TO SAVEPOINT ãŠã‚ˆã³ RELEASE SAVEPOINT ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆ
ori53 2010/11/23
mysql

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

mysql

php

reference

sql

ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹
ãƒªãƒ³ã‚¯
1