ãçç¶ã»ç¾æ£ãããã¯æ°ã«ãªãçç¶ã»ç¾æ£ã®åå ã¨å¯¾å¦æ³ãããããããã解説ãã¦ãã¾ãã ã¾ããã»ã«ããã§ãã¯ã§èªåã®ä½èª¿ã確èªããããçæ´»ç¿æ £ãæ¯ãè¿ããã¨ãã§ãã¾ãã
ãçç¶ã»ç¾æ£ãããã¯æ°ã«ãªãçç¶ã»ç¾æ£ã®åå ã¨å¯¾å¦æ³ãããããããã解説ãã¦ãã¾ãã ã¾ããã»ã«ããã§ãã¯ã§èªåã®ä½èª¿ã確èªããããçæ´»ç¿æ £ãæ¯ãè¿ããã¨ãã§ãã¾ãã
tatamilab.jp
ANDæ¤ç´¢ ãCSS+HTML+JavaScriptãã§æ¤ç´¢ããå ´åã¯ä»¥ä¸ã®ããã«ãã¾ãã SELECT * FROM `delicious` WHERE tags LIKE "%CSS%" AND tags LIKE "%HTML%" AND tags LIKE "%JavaScript%" ORæ¤ç´¢ ãCSS|HTML|JavaScriptãã§æ¤ç´¢ããå ´åã¯ä»¥ä¸ã®ããã«ãã¾ãã SELECT * FROM `delicious` WHERE tags LIKE "%CSS%" OR tags LIKE "%HTML%" OR tags LIKE "%JavaScript%" å¼ãç®æ¤ç´¢ ãCSS+HTML-JavaScriptãã§æ¤ç´¢ããå ´åã¯ä»¥ä¸ã®ããã«ãã¾ãã SELECT * FROM `delicious` WHERE tags LIKE "%CSS%" AND tags LI
GROUP BY å¥ã使ç¨ããã¨æå®ããã«ã©ã ã®å¤ãåºæºã«ãã¼ã¿ãã°ã«ã¼ãåãããã¨ãã§ãã¾ããã°ã«ã¼ãåãããã¨ã§ãã¼ã¿ã®æ°ãæ°ãã COUNT 颿°ããã¼ã¿ã®å¹³åãè¨ç®ãã AVG 颿°ãã°ã«ã¼ãæ¯ã«è¡ããã¨ãã§ãã¾ããããã§ã¯ MySQL ã§ GROUP BY å¥ã使ã£ã¦ãã¼ã¿ãã°ã«ã¼ãåããæ¹æ³ã«ã¤ãã¦è§£èª¬ãã¾ãã
åããæè¿æããã¦ããã®ã¯ãã¨ã¦ãå¤§è¦æ¨¡ãªã³ã³ã·ã¥ã¼ãåããµã¼ãã¹ã ã 100ä¸äººã®å¥ç´ã¦ã¼ã¶ã使ãã1ãã¼ãã«ã«1åã¬ã³ã¼ã以ä¸ã®ãã¼ã¿ã貯ãã24æéæ¢ãããã¨ã許ãããã è¦æ±ããå¿çã¾ã§ã®ã¿ã¼ã³ã¢ã©ã¦ã³ãã¿ã¤ã ã1ç§ä»¥å ã¨ããå³ããSLAã®ãµã¼ãã¹ã§ããã ä¸ã§ãåã¯RDBããã¬ã¼ã ã¯ã¼ã¯ãæ å½ãã¦ããã åããã®ç¾å ´ã«æ¥ã¦ã驿ããæåã2ã¤ãã ããã¯ãJoinç¦æ¢ãã¨ãåºå®é·DBãã ã ããããªãã ã¨ã¯ãããæ£ç´ã«è¨ãã°ãã¾ããããããã¨ããææ³ã§ãããã RDBãç¥ããªãã¬ã¬ã·ã¼ãªäººãã¡ãè¨è¨ããDBã§ã¯ãããããã¡ãªè¨è¨ã ããã ã ã¨åã¯æ©ã ã«ãã®æåã¨æ¦ã£ã¦ã絶対ã«è¦ãã¦ãããã¨èãã¦ãã éå»ã®çµé¨ä¸ããã¯ããããããºã ã£ãã ãããããã®æåã¨æ¦ããã¨3ã¶æéã å±ãããåãã¦å±ããããããå±ããã¨ããããã¯çè§£ããã å¤§è¦æ¨¡ã³ã³ã·ã¥ã¼ãåããµã¼ãã¹ã®RDBã¨ãã
ããã¶ãæéãããã¦ãã¾ã£ããã©ãå¤§è¦æ¨¡ã³ã³ã·ã¥ã¼ãåããµã¼ãã¹RDBè¨è¨ã®ç¶ãã åã¯ãã®ããã¸ã§ã¯ããèªåã®RDBã®ç¥èã使ã£ã¦é©æ°ãã¦ãããã¨æã£ã¦è¨ãã ã ãããçµæã¨ãã¦éã«ãã³ã³ã·ã¥ã¼ãåããµã¼ãã¹ã«æé©åãããRDBã®ä½¿ãæ¹ã«ã¤ãã¦æãããã¨ã«ãªã£ãã â» ãã¨ãKVSã§ãããããã£ã¦è¨ã£ã¦ã人ããããã©ãããã¯KVSå°å ¥ã®è¦å´ãç¥ããªã人ã ã¨æããKVSã®è¦å´ã¯å¾ã§æ¸ãã åããæè¿æããã¦ããã®ã¯ãã¨ã¦ãå¤§è¦æ¨¡ãªã³ã³ã·ã¥ã¼ãåããµã¼ãã¹ã ã 100ä¸äººã®å¥ç´ã¦ã¼ã¶ã使ãã1ãã¼ãã«ã«1åã¬ã³ã¼ã以ä¸ã®ãã¼ã¿ã貯ãã24æéæ¢ãããã¨ã許ãããã è¦æ±ããå¿çã¾ã§ã®ã¿ã¼ã³ã¢ã©ã¦ã³ãã¿ã¤ã ã1ç§ä»¥å ã¨ããå³ããSLAã®ãµã¼ãã¹ã§ããã ä¸ã§ãåã¯DBããã¬ã¼ã ã¯ã¼ã¯ã®è¨è¨ã¨ã¢ã¼ããã¯ãã£ã½ããã¨ãæ å½ãã¦ããã åããã®ç¾å ´ã«æ¥ã¦ã驿ããæåã2ã¤ãã ããã¯ãJoinç¦æ¢
JOIN ç¦æ¢ã®è©±ã«ããã¾ã ã«çµ¡ãã§ããã人ãããã â ãè¦ããããããã½ã¼ã·ã£ã«ç³»ã®ãµã¼ãæ§æãèãã - SQLer çå³¶åå¯ ã®æ¥è¨ åã以åã«æ¸ããæ¬ãã¼ãã«é¢ããã¨ã³ããªã¯ä»¥ä¸ã®ï¼ã¤ã â ä¿¡ããããªãDBæåãJoinç¦æ¢ãã«ãåºå®é·DBãããã§ããåããã§ããå¤§è¦æ¨¡ã³ã³ã·ã¥ã¼ãåããµã¼ãã¹ã®RDBè¨ â ä¿¡ããããªãDBæåãåºå®é·DBãã§ããããã§ããå¤§è¦æ¨¡ã³ã³ã·ã¥ã¼ãåããµã¼ãã¹ã®RDBè¨è¨ â ãã³ãä¿¡ããããªãDBæåã ãã©ãçµ±è¨æ å ±åºå®åã¯ãã¸ã§ã¢ãª ã¡ããã©æãããã¦ãã®ä¼ç¤¾ã®ãªã©ã¯ã«å¥³åãæ¸ããã¨ã³ããªã®ç¶ããå ¬éããã¾ããã â ä¸ç·ã«ã¾ãªã¼ï¼ãhiromi ã¨æ¥½ããOracleããã©ã¼ãã³ã¹ãã¥ã¼ãã³ã°ï¼ããVol.2 Statspackãè¦ã¦ã¿ããã ã¨ãããã¨ã§åã®ä¸ã§DBç±ãçãä¸ãã£ã¦ããã®ã§è¿ççãªã¨ã³ããªãæ¸ãã¾ãã ãã¨ããããã¡ã¢ãªã ãæ°ã«ãã¦ããã
ãµã¼ãã¹çµäºã®ãç¥ãã ãã¤ãYahoo! JAPANã®ãµã¼ãã¹ããå©ç¨ããã ãèª ã«ãããã¨ããããã¾ãã ã客æ§ãã¢ã¯ã»ã¹ããããµã¼ãã¹ã¯æ¬æ¥ã¾ã§ã«ãµã¼ãã¹ãçµäºãããã¾ããã ä»å¾ã¨ãYahoo! JAPANã®ãµã¼ãã¹ããæé¡§ãã ããã¾ãããããããããé¡ããããã¾ãã
æã話 ãã®1 çµãããªããããå¦ç ã¤ã³ãã°ã¬ã¼ã¿å¤åãAãã ãæ£ææ°åãæãã¦ããå¬ã®ããæ¥ï¼æ®æ®µã¨åãããã«ä»äºããã¦ããã¨ï¼çªç¶é¨é·ããå¼ã³åºããããããããã¸ã§ã¯ãã§ã·ã¹ãã ã®ç¨¼åéå§ã1ã«æå¾ã«æ§ãã¦ããã®ã ãï¼éçºãé ãã¦ããã®ã§æ¯æ´ãã¦ã»ããã¨è¨ããã¨ã ã£ãã ãã®ã·ã¹ãã ã¯è£½é æ¥ã®ããä¸å 伿¥åãã§ï¼å ¨å½ã®å£²ãä¸ããéè¨ãã¦è²©å£²åæãè¡ãã¨ããæ®éã«ãããããã®ã§ãã£ãã3é±éåã«ããã°ã©ãã³ã°ä½æ¥ã«çæãï¼äºå®ã§ã¯ãã§ã«ã·ã¹ãã ã»ãã¹ãã«å ¥ã£ã¦ããã¯ããªã®ã«ï¼ã¾ã ä¿®æ£ãç¶ãã¦ãããããã ããã¯ããªã¼ãã³ç³»RDBã¯ä½¿ããªãï¼ã èãã¦ã¿ãã¨ï¼å¤éã®6æéã§çµãããªããã°ãªããªããããå¦çãï¼12æéãã£ã¦ãçµãããªãã®ã ã¨è¨ããã¡ãªã¿ã«ï¼ãã®ãããå¦çã¯ï¼Oracleã®ã¹ãã¢ãããã·ã¸ã£ã使ã£ã¦è¨è¿°ãã¦ããã売ãä¸ãã®å ãã¼ã¿ã®ä»¶æ°ã¯100ä¸ã¬ã³ã¼ã以ä¸ããã¼ã¿éãå¤
ãµã¼ãã¹çµäºã®ãç¥ãã ãã¤ãYahoo! JAPANã®ãµã¼ãã¹ããå©ç¨ããã ãèª ã«ãããã¨ããããã¾ãã ã客æ§ãã¢ã¯ã»ã¹ããããµã¼ãã¹ã¯æ¬æ¥ã¾ã§ã«ãµã¼ãã¹ãçµäºãããã¾ããã ä»å¾ã¨ãYahoo! JAPANã®ãµã¼ãã¹ããæé¡§ãã ããã¾ãããããããããé¡ããããã¾ãã
ãµã¼ãã¹çµäºã®ãç¥ãã ãã¤ãYahoo! JAPANã®ãµã¼ãã¹ããå©ç¨ããã ãèª ã«ãããã¨ããããã¾ãã ã客æ§ãã¢ã¯ã»ã¹ããããµã¼ãã¹ã¯æ¬æ¥ã¾ã§ã«ãµã¼ãã¹ãçµäºãããã¾ããã ä»å¾ã¨ãYahoo! JAPANã®ãµã¼ãã¹ããæé¡§ãã ããã¾ãããããããããé¡ããããã¾ãã
ãµã¼ãã¹çµäºã®ãç¥ãã ãã¤ãYahoo! JAPANã®ãµã¼ãã¹ããå©ç¨ããã ãèª ã«ãããã¨ããããã¾ãã ã客æ§ãã¢ã¯ã»ã¹ããããµã¼ãã¹ã¯æ¬æ¥ã¾ã§ã«ãµã¼ãã¹ãçµäºãããã¾ããã ä»å¾ã¨ãYahoo! JAPANã®ãµã¼ãã¹ããæé¡§ãã ããã¾ãããããããããé¡ããããã¾ãã
ãã©ã¦ã¶ ãã©ã¦ã¶ã®ããã©ã«ãã¹ã¿ã¤ã«ããªã»ãããã WINGSããã¸ã§ã¯ããããããéº»ç¢ [è]ã å±±ç° ç¥¥å¯ [ç£ä¿®] æ¬é£è¼ã§ã¯ããã¯ãã¹ãã©ã¦ã¶ã«å¯¾å¿ãããã¶ã¤ã³ãã¯ããã¯ãããã¼ãã«ãä¿å®æ§ãäºææ§ã«åªããXHTML+CSSã®æ¸ãæ¹ãç´¹ä»ãã¦ããã¾ããä»åã¯ããã®ãã©ã¦ã¶ã®ããã©ã«ãã¹ã¿ã¤ã«ã«ã¤ãã¦è§£èª¬ãããããåæåãã¦ãåãã©ã¦ã¶ã®ããã©ã«ãã¹ã¿ã¤ã«ã®å·®ç°ãåããæ¹æ³ãç´¹ä»ãã¾ããã ï¼»2008å¹´10æ03æ¥ï¼½ ã¬ãã¼ã ã»ãã·ã§ã³ã¬ãã¼ããã¨ã³ãã«ããã»ãã¯ããã¸ã¼ãº DatabaseGearãããã¯ããªã¼ãã¼ãã¥ã¼ã CDNç·¨éé¨ [è] å»ã9æ9æ¥ã¨11æ¥ãæ±äº¬ã大éªã®2æ ç¹ã§10åç®ã¨ãªãã¨ã³ãã«ããã»ãããããã¼ãã£ã³ããéå¬ããããã¤ãã³ãåé ã«ç´¹ä»ããããã¨ã³ãã«ããã»ãã¯ããã¸ã¼ãºã®ç¾å¨ã®ç¶æ³ã¨ãæ¥æ¬ã«ããã¦ã¯æ°ãã«ç»å ´ãããã¨ã¨ãªãDatabaseGe
æ¥é ããæ¥½å¤©ã®ãµã¼ãã¹ããå©ç¨ããã ãã¾ãã¦ãããã¨ããããã¾ãã ãµã¼ãã¹ããå©ç¨ããã ãã¦ããã¾ãã¨ãã大å¤ç³ã訳ãããã¾ããããç¾å¨ãç·æ¥ã¡ã³ããã³ã¹ãè¡ããã¦ããã ãã¦ããã¾ãã ã客æ§ã«ã¯ãç·æ¥ã®ã¡ã³ããã³ã¹ã«ããããè¿·æãããããã¦ãããèª ã«ç³ã訳ãããã¾ããã ã¡ã³ããã³ã¹ãçµäºæ¬¡ç¬¬ããµã¼ãã¹ã復æ§ãããã¾ãã®ã§ã ä»ãã°ãããå¾ ã¡ããã ãã¾ãããããé¡ãç³ãä¸ãã¾ãã
ãã®ææ¸ã¯ãosCommerceã§ä½¿ç¨ãã¦ãããã¼ã¿ãã¼ã¹MySQLã®åºæ¬çãªä½¿ãæ¹ã«ã¤ãã¦è§£èª¬ãã¦ãã¾ããããã«ãã¼ã¿ãã¼ã¹ã®ç®¡çè ããããã¦ã¼ã¶ã«åãã¦æ¸ããã¦ãã¾ãã ã¯ããã« ããã§ã¯ãMySQLãµã¼ãã¯èµ·åãã¦ãããã®ã¨ãã¦èª¬æãã¾ãã MySQLã®æåã«ã¤ã㦠MySQLã§ã¯ããã¼ã¿ãã¼ã¹åããã¼ãã«åã®å¤§æåã¨å°æåãåºå¥ãã¦ãã¾ãããã以å¤ã¯åºå¥ãã¾ããã MySQLã®ãã£ã¼ã«ãåããã¼ãã«åã«ä½¿ããæåã¯ãè±æ°åã¨_ï¼ã¢ã³ãã¼ãã¼ï¼ã$ããµã¼ãã®ãã£ã©ã¯ã¿ã»ããã«ããæåã§ãã ç¥ã£ã¦ããããã³ãã³ã mysqladminï¼ãã¼ã¿ãã¼ã¹ã®ä½æã»åé¤ããMySQLãµã¼ãã®æ å ±ãå¾ãï¼ mysqlshowï¼ãã¼ã¿ãã¼ã¹ããã¼ãã«ã®æ å ±ã表示ããï¼ mysqlï¼MySQLã¯ã©ã¤ã¢ã³ãã®èµ·åï¼ mysqldumpï¼ãã¼ã¿ãã¼ã¹ããã¼ãã«ããã³ãããï¼ myisamchkï¼ãã¼ãã«
indexã¯ã第1弿°STRã®å é ãã第2弿°SUBSTRãæåã«è¦ã¤ãã£ãä½ç½®ãè¿ãã¾ãã 第3弿° POSITIONã§æ¤ç´¢ããä½ç½®ãæå®ãããã¨ãã§ãã¾ãã第3弿°POSITIONã«ã¯æåã®æåã 0 ã¨ãã¦æå®ãã¾ãã è¿å´å¤ã¯ 0ããããã¯å¤æ°$[ã«è¨å®ããå¤ã§ããSURSTRãè¦ã¤ãããªãã£ãå ´å㯠-1 ãè¿ãã¾ãã indexã®ä½¿ãæ¹ $str = "How you always hurt the one you love."; print index($str,'you'); > 4
ã©ã³ãã³ã°
ã¡ã³ããã³ã¹
ã©ã³ãã³ã°
ãªãªã¼ã¹ãé害æ å ±ãªã©ã®ãµã¼ãã¹ã®ãç¥ãã
ææ°ã®äººæ°ã¨ã³ããªã¼ã®é ä¿¡
å¦çãå®è¡ä¸ã§ã
j次ã®ããã¯ãã¼ã¯
kåã®ããã¯ãã¼ã¯
lãã¨ã§èªã
eã³ã¡ã³ãä¸è¦§ãéã
oãã¼ã¸ãéã
{{#tags}}- {{label}}
{{/tags}}