[db tech showcase Tokyo 2015] A14:Amazon Redshiftã®å ã¨ãªã£ãã¹ã±ã¼ã«ã¢ã¦ãåã«ã©ã ãã¼DBå¾¹åºè§£èª¬ ãã®...
2007/8/2521:27 ãSQLãDISTINCTå¥ã®è¨è¿°ä½ç½®ã«ããå®è¡çµæã®éãã«ã¤ã㦠DISTINCTã®ä½¿ãæ¹ã«ã¯ã以ä¸ã®2種é¡ãããã 1.åå¾ãã鏿ãªã¹ãï¼é ç®ãªã¹ãï¼ã®åã«DISTINCTãè¨è¿°ãã ä¾ï¼SELECT DISTINCT COUNT(Column_Name) ... 2.éè¨é¢æ°å ã«DISTINCTãè¨è¿°ãã ä¾ï¼SELECT COUNT(DISTINCT Column_Name) ... ä¸è¨ã®å®è¡çµæã§ã¯ãéè¤ãæé¤ãã対象ã«å·®ç°ãçºçããã ãã®å·®ç°ã¯ã以ä¸ã®éãã§ããã 1.DISTINCT COUNT(Column_Name)ã®å ´åã鏿é ç®ã®çµã¿åãããéè¤ããªãã¬ã³ã¼ãä»¶æ°ã表示ããã 2.COUNT(DISTINCT Column_Name)ã®å ´åãåä½ã®é ç®ï¼Column_Nameï¼ã®éè¤ãã¦ããªãä»¶æ°ï¼ç¨®é¡æ°ï¼ãåå¾ããã 以ä¸ãå®è¡çµ
ãã¦ã§ããªããã°ã㯠2023å¹´1æ31æ¥ ããã¡ã¾ãã¦ãµã¼ãã¹æä¾ãçµäºãããã¾ããã 2004å¹´3æã®ãµã¼ãã¹éå§ãã19å¹´è¿ããã®éãæ²¢å±±ã®çãã¾ã«ãæç¨ããã ãã¾ãããã¨ãå¿ããã礼ç³ãä¸ãã¾ããä»å¾ã¨ããBIGLOBEããæé¡§è³ãã¾ãããããããããé¡ãç³ãä¸ãã¾ãã â»å¼ã£è¶ãå ããã°ã¸ã®ãªãã¤ã¬ã¯ããµã¼ãã¹ã¯2024å¹´1æ31æ¥ã§çµäºãããã¾ããã â»10ç§å¾ã«BIGLOBEã®ãããããã¼ã¸ã«é·ç§»ãã¾ã
ãã®è¨äºã¯æ¤è¨¼å¯è½ãªåèæç®ãåºå ¸ãå ¨ã示ããã¦ããªãããä¸ååã§ãã åºå ¸ã追å ãã¦è¨äºã®ä¿¡é ¼æ§åä¸ã«ãååãã ãããï¼ãã®ãã³ãã¬ã¼ãã®ä½¿ãæ¹ï¼ åºå ¸æ¤ç´¢?: "ã¹ãã¢ãããã·ã¼ã¸ã£" â ãã¥ã¼ã¹Â · æ¸ç±Â · ã¹ã«ã©ã¼Â · CiNii · J-STAGE · NDL · dlib.jp · ã¸ã£ãã³ãµã¼ã · TWL (2017å¹´9æ) ã¹ãã¢ãããã·ã¼ã¸ã£ï¼è±: Stored Procedureï¼ã¯ããªã¬ã¼ã·ã§ãã«ãã¼ã¿ãã¼ã¹ç®¡çã·ã¹ãã ï¼RDBMSï¼ã«ã¢ã¯ã»ã¹ããã¢ããªã±ã¼ã·ã§ã³ã§å©ç¨ã§ãããµãã«ã¼ãã³ã§ããããã®ãããªããã·ã¼ã¸ã£ã¯ããã¼ã¿ãã¼ã¹ã®ãã¼ã¿è¾æ¸ã«æ ¼ç´ããã¦ããã ã¹ãã¢ãããã·ã¼ã¸ã£ã®ç¨éã¨ãã¦ã¯ããã¼ã¿ã®æ¤è¨¼ï¼ãã¼ã¿ãã¼ã¹ã¸ã®çµ±åï¼ãã¢ã¯ã»ã¹å¶å¾¡ã®ä»çµã¿ãªã©ããããããã«ãã¹ãã¢ãããã·ã¼ã¸ã£ã¯ããã¨ãã¨ã¢ããªã±ã¼ã·ã§ã³ã«å®è£ ããã¦ãããã¸ãã¯ãçµ±åããä¸å å
SQLå®è¡ã¨ã©ã¼æã®ãã¼ã«ããã¯ã«ã¤ã㦠ã¯ã¨ãªã¢ãã©ã¤ã¶ã使ç¨ãã以ä¸ã®ãããªè¤æ°ã®ã¹ãã¼ãã¡ã³ããå®è¡ããã¯ã¨ãªãæµãã¾ãã ãBEGIN TRANSACTION TRAN_X INSERTæ1; INSERTæ2; UPDATEæ3; â¦ã æçµçã«æåããã commitãéä¸ã§ã¨ã©ã¼ãåºããrollbackãããã¨èãã¦ãã¾ãã @@ERRORã§ãªãJAVAã§ãããtryï½catchãã¾ãã¯VBã§ãããON ERRORãæ§æã®ãããªãã®ã¯ãªãã®ã§ããããï¼ ã©ãªãããææãé¡ããã¾ãã ãã¡ã¤ã«ã«æ¸ãããSQLã®å®è¡æ¹æ³(oracleã¨ã®éã) ãä¸è©±ã«ãªãã¾ãã SQLServer2000ãã¯ã¨ãªã¢ãã©ã¤ã¶ã§è³ªåãããã¾ãã ãã¡ã¤ã«ã«æ¸ãããä¸é£ã®SQLã®å®è¡ãããã¨ãã ORACLEã§ã¯ãSQL*PLUSãã ãã¡ã¤ã«åã®åã«@ãã¤ãã¦å®è¡ã§ãã¾ããã ã¾ããSQLã¹ã¯ãªã
ãµã¼ãã¹çµäºã®ãç¥ãã ãã¤ãYahoo! JAPANã®ãµã¼ãã¹ããå©ç¨ããã ãèª ã«ãããã¨ããããã¾ãã ã客æ§ãã¢ã¯ã»ã¹ããããµã¼ãã¹ã¯æ¬æ¥ã¾ã§ã«ãµã¼ãã¹ãçµäºãããã¾ããã ä»å¾ã¨ãYahoo! JAPANã®ãµã¼ãã¹ããæé¡§ãã ããã¾ãããããããããé¡ããããã¾ãã
âã»ãã¥ã¢ãªWebã¢ããªâã«ç«ã¡ã¯ã ãã課é¡ï¼ã»ãã¥ãªãã£ãããããæ¬é³ã§èªããªããï¼4ï¼ï¼1/3 ãã¼ã¸ï¼ SQLã¤ã³ã¸ã§ã¯ã·ã§ã³ã«ããæ å ±æ¼ããäºä»¶ãã¯ãã¼ãºã¢ããããã¦ãã¾ãã対çã¯ç°¡åãªãã¨â¦â¦ã¨è¨ããç¶ãã¦ããã®ã§ããããªãWebã¢ããªã±ã¼ã·ã§ã³ã®èå¼±æ§ã¯ç¡ããªããªãã®ã§ããããã第4åã§ã¯ãã®çç±ã«è¿«ãã¾ãï¼ç·¨éé¨ï¼ ç§ã¯åè·ã§ãWebã¢ããªã±ã¼ã·ã§ã³ã®èå¼±ï¼ãããããï¼æ§ã«ããå人æ å ±ã®æ¼ããã®è å¨ãåºãç¥ã£ã¦ãããããã«å®å¨ã®ãµã¤ãã®èå¼±æ§ãå ¬éãããã¨ãããã¨ããã¦ãã¾ãããæåã®ã¬ãã¼ãã2001å¹´10æã§ãæããæ¥æ¬ã§æåã§ã¯ãªããã¨è¨æ¶ãã¦ãã¾ãã ããããä½å¹´ããã¡ã¾ããããç¸å¤ãããWebã¢ããªã±ã¼ã·ã§ã³ã®èå¼±æ§ã¯ãªããªããããã¾ããã¾ãã¾ãªå¯¾çã½ãªã¥ã¼ã·ã§ã³ãçºè¡¨ããã¦ãã¾ãã Webã¢ããªã±ã¼ã·ã§ã³ã®èå¼±æ§å¯¾çã¯ããããã以ä¸ã®ããã«åé¡ã§ãã¾ãã éçºæã«
ç±³ Yahoo! ã Yahoo! Pipes ã¿ããã«èªç±åº¦ãé«ãã¦ãã¾ãã¡ãã£ã¨æ¯è²ãéããµã¼ãã¹ãåºã¦ãããé¡ãã¦ãYahoo! Query LanguageãYQL ã¨å¼ã¶ããã ãSQL 風ã®è¨èªã REST ã§æãã¦ãçµæã XML ã JSON ã§åãåããã¨ãã§ãããå ·ä½çã«ãã£ã¦ã¿ãªãã¨åããã«ããã®ã§ãã¨ãããã試ãã¦ã¿ããRSS ãããã¼ã¿åå¾YQL ã使ã£ã¦ RSS ããææ°ã®ã¿ã¤ãã«10åãåã£ã¦ãã¦ã¿ãããã㪠YQL ã«ãªããããã select title from rss where url='http://d.hatena.ne.jp/nitoyon/rss' rss ãã¼ãã«ã«å¯¾ã㦠select ãçºè¡ãã¦ãããå®éã«ãã® YQL ã試ãã«ã¯ YQL ç¨ã® console ãå©ç¨ããã¨ãããï¼â»è¦ãã°ã¤ã³ï¼console ã®å·¦ä¸ã« YQL ãå ¥åãã¦
æè¿ã®Webãµã¼ãã¹éçºã§ã¯ãªã¼ãã³ã½ã¼ã¹ã®ãã¼ã¿ãã¼ã¹ãå©ç¨ãããã¨ãå¤ããªã£ã¦ãããããã ãä¿¡é ¼æ§ãå®å®æ§ãåä¸ãã¦ããã¨ãããã¨ã ããã以åã¯PostgreSQLã®æ¹ã人æ°ããã£ãããæè¿ã§ã¯MySQLãé¸ã°ããæ¹ãå¤ãããã ã mk-parallel-dumpã®ãã«ã ããããä¸ã§ãå¿ è¦ã«ãªã£ã¦ããã®ãMySQLã®ç®¡çãã¼ã«ã ãç¹ã«è¦æ¨¡ã®å¤§ããªéçºãé²ããä¸ã§ãããã©ã«ãã®ãã¼ã«ã ãã§ã¯ç©è¶³ããªãã¨æãã¦ãã人ã¯ããã¡ãã®ããã«æ´ç·´ããããã¼ã«ã使ã£ã¦ã¿ããã ä»åç´¹ä»ãããªã¼ãã³ã½ã¼ã¹ã»ã½ããã¦ã§ã¢ã¯MaatkitãMySQLåãã®ã³ãã³ãã©ã¤ã³ãã¼ã«ç¾¤ã ã Maatkitã¯Perlã§ä½ãããã½ããã¦ã§ã¢ã§ãMySQLã®é«åº¦ãªæä½ãå¯è½ã«ãããã¼ã«ãå¹¾ã¤ãæä¾ããã¦ããããããã¯mk-ã§ã¯ãã¾ãååã®ã³ãã³ãåã«ãªã£ã¦ãããå·çæç¹ã§ã¯19ã®æ©è½ãããã ã³ãã³ãä¸è¦§ 主ãªã³ãã³
ã1æ¥1åãä»äºãåå¼·ã«å½¹ç«ã¤ITç¥èãå é»ï¼ ãªã¯ã«ã¼ããéå¶ãããITãã£ããã£ã¼ã¸ãã¯ãæåã«ä¼å¡ç»é²ãå¿ è¦ã§ãããç¡æã§ä»äºããæ å ±å¦çæè¡è 試é¨ã¾ã§å¹ åºãæ´»ç¨ã§ããWebãµã¤ãã§ããITæ å½è ã®ã¹ãã«ã¢ããã«å½¹ç«ã¤æ å ±å¦çã«é¢ããåé¡ããæ¯æ¥ï¼åãã¤ãã¡ã¼ã«ããµã¤ãä¸ã§æä¾ãããµã¼ãã¹ã§ããè§£çãã¼ã¸ã¯ITåå¿è ã§ãåããä¸å¯§ãªè§£èª¬ã¤ãã§ããµã¤ãä¸ã§ã¯éå»ã®åé¡ã«ãææ¦ã§ãã¾ãã ã¾ããITç¨èªã調ã¹ãããITåèªå¸³ã¯ã説æã詳ããç°¡åã«èª¿ã¹ãããããã¸ã便å©ã§ãããã²ãä¼å¡ç»é²ãã¦æ´»ç¨ããããµã¤ãã§ãã LEFT JOINã¨RIGHT JOIN 表çµåãæå®ããã¨ãã«WHEREå¥ã¨INNER JOINã®ã»ãã«LEFT JOINã¨RIGHT JOINã§è¡¨ãçµåãããã¨ãã§ãããããã¯ã表ã®çµåããã¨ãã«æå®ãããå·¦å³ããããã®è¡¨ãåªå ãã¦è¡¨ç¤ºãè¡ãæå®ã§ããã ä¾é¡1ã¯å£²ä¸è¡¨ã¨é¡§
æ¬è¨äºã«èª¤ã£ã表ç¾ããããã¾ãããæ¬è¨äºãåèã«ãã¦ããã ããæ¹ã ã誤ã£ã表ç¾ã§ç³ã訳ãããã¾ããã§ããããè©«ã³ãã¦è¨æ£ãããã¾ããã¾ãã誤ãããææãã ãã£ãå²©æ¬æ§ãèª ã«ãããã¨ããããã¾ããã[MySQL]è¤åUNIQUEãã¼ã§ããINSERT ⦠ON DUPLICATE KEY UPDATEãæ§æã¯ä½¿ãã è°·å£ã§ãã ãã¼ã¿ãã¼ã¹ã®ç®¡çããã¦ããã¨ããæåã§ãã¼ã¿ã®èª¿æ´ãªã©ããããã¨ããããã¨æãã¾ãã ä»åã¯ãããªã¨ãã«ä¾¿å©ãªMySQLã®æ§æãããã¤ããç´¹ä»ãããã¨æãã¾ãã ãã¡ããã¢ããªã±ã¼ã·ã§ã³ã«çµã¿å ¥ãã¦ä½¿ç¨ãã¦ãåé¡ãªãæ§æãããã¾ããã使ç¨ããå±é¢ã¯éããã¦ããã¨æãã¾ãã INSERT ⦠SELECT æ§æ CREATE TABLE ⦠SELECT æ§æ REPLACE æ§æ INSERT ⦠ON DUPLICATE KEY UPDATE INSERT
ããã°ã©ãã³ã°å¦ç¿ãµã¼ãã¹ã®éå¶ãGTDã®ç£è¨³ãå°ç²ãªiOSã¢ããªã®éçºãã¨ãã©ãã©ã¤ãããã¯ãæç« ã¯AIã§æ¸ãã¦ã¾ããï¼è©³ãããããã£ã¼ã«ï¼ã
GT Nitro: Car Game Drag Raceã¯ãå ¸åçãªã«ã¼ã²ã¼ã ã§ã¯ããã¾ãããããã¯ã¹ãã¼ãããã¯ã¼ãã¹ãã«å ¨éã®ã«ã¼ã¬ã¼ã¹ã²ã¼ã ã§ãããã¬ã¼ãã¯å¿ãã¦ãããã¯ãã©ãã°ã¬ã¼ã¹ããã¤ãã¼ï¼å¤å ¸çãªã¯ã©ã·ãã¯ããæªæ¥çãªãã¼ã¹ãã¾ã§ãæãã¯ã¼ã«ã§éãè»ã¨ã«ã¼ã¬ã¼ã¹ã§ãã¾ããã¹ãã£ãã¯ã·ããããã¹ã¿ã¼ããããããè³¢ã使ã£ã¦ç«¶äºãæã¡ç ´ãå¿ è¦ãããã¾ãããã®ã«ã¼ã¬ã¼ã¹ã²ã¼ã ã¯ãã®ãªã¢ã«ãªç©çå¦ã¨ç´ æ´ãããã°ã©ãã£ãã¯ã¹ã§ããªãã®å¿ãççºããã¾ããããã¾ã§ãã¬ã¤ãããã¨ã®ãªããããªãã®ã§ãã GT Nitroã¯ããªãã¬ãã¯ã¹ã¨ã¿ã¤ãã³ã°ã試ãã«ã¼ã¬ã¼ã¹ã²ã¼ã ã§ããæ£ããç¬éã«ã®ã¢ãã·ããããã¬ã¹ãæãåãè¸ãå¿ è¦ãããã¾ããã¾ãã大ç©ãã¡ã¨ç«¶ãã¤ã¤ãè»ã®ãã¥ã¼ãã³ã°ã¨ã¢ããã°ã¬ã¼ããè¡ããªããã°ãªãã¾ãããä¸çä¸ã§æé«ã®ãã©ã¤ãã¼ã¨è»ã¨ã«ã¼ã¬ã¼ã¹ã«æããã¨ã«ãªãããã©ãã°ã¬ã¼ã¹ã®çå
ãã®ææ¸ã¯ãosCommerceã§ä½¿ç¨ãã¦ãããã¼ã¿ãã¼ã¹MySQLã®åºæ¬çãªä½¿ãæ¹ã«ã¤ãã¦è§£èª¬ãã¦ãã¾ããããã«ãã¼ã¿ãã¼ã¹ã®ç®¡çè ããããã¦ã¼ã¶ã«åãã¦æ¸ããã¦ãã¾ãã ã¯ããã« ããã§ã¯ãMySQLãµã¼ãã¯èµ·åãã¦ãããã®ã¨ãã¦èª¬æãã¾ãã MySQLã®æåã«ã¤ã㦠MySQLã§ã¯ããã¼ã¿ãã¼ã¹åããã¼ãã«åã®å¤§æåã¨å°æåãåºå¥ãã¦ãã¾ãããã以å¤ã¯åºå¥ãã¾ããã MySQLã®ãã£ã¼ã«ãåããã¼ãã«åã«ä½¿ããæåã¯ãè±æ°åã¨_ï¼ã¢ã³ãã¼ãã¼ï¼ã$ããµã¼ãã®ãã£ã©ã¯ã¿ã»ããã«ããæåã§ãã ç¥ã£ã¦ããããã³ãã³ã mysqladminï¼ãã¼ã¿ãã¼ã¹ã®ä½æã»åé¤ããMySQLãµã¼ãã®æ å ±ãå¾ãï¼ mysqlshowï¼ãã¼ã¿ãã¼ã¹ããã¼ãã«ã®æ å ±ã表示ããï¼ mysqlï¼MySQLã¯ã©ã¤ã¢ã³ãã®èµ·åï¼ mysqldumpï¼ãã¼ã¿ãã¼ã¹ããã¼ãã«ããã³ãããï¼ myisamchkï¼ãã¼ãã«
ãªãªã¼ã¹ãé害æ å ±ãªã©ã®ãµã¼ãã¹ã®ãç¥ãã
ææ°ã®äººæ°ã¨ã³ããªã¼ã®é ä¿¡
å¦çãå®è¡ä¸ã§ã
j次ã®ããã¯ãã¼ã¯
kåã®ããã¯ãã¼ã¯
lãã¨ã§èªã
eã³ã¡ã³ãä¸è¦§ãéã
oãã¼ã¸ãéã
{{#tags}}- {{label}}
{{/tags}}