ÃæÀîÍÍ

¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤¹¡£

> EXPLAIN
¤³¤ì¤òSelectʸ¤ÎÁ°¤ËÉÕ¤±¤Æ¼Â¹Ô¤¹¤ë¤ÈSelectʸ¤òɾ²Á¤·¤Æ¤¯¤ì¤ë¤â¤Î¤Ç¤¹¤«¡©
¤½¤ì¤È¤â¡¢Selectʸ¤È¤ÏÆÈΩ¤·¤¿¥³¥Þ¥ó¥É¤Ç
EXPLAIN;
Select ....;
¤ÈÆþÎϤ¹¤ë¤Î¤Ç¤·¤ç¤¦¤«¡©

----- Original Message ----- 
From: "ÃæÀî µ®" <takashi.nakagawa@xxxxxxxxxx>
To: <ml@xxxxxxxxxx>
Sent: Thursday, March 29, 2012 5:12 PM
Subject: [mysql 15707] Re: Left Join¶ç¤òÉÕ¤±¤¿UPDATE½èÍý»þ´Ö¤¬Èó¾ï¤ËŤ¯¤«¤«¤Ã¤Æ 



> ¤¿¤Ó¤¿¤Ó¤¹¤ß¤Þ¤»¤ó
> EXPLAIN
> SELECT `table-a`.`fa`,`table-b`.`fb`
> FROM `table-a` LEFT JOIN `table-b`  USE INDEX ( ¥¤¥ó¥Ç¥Ã¥¯¥¹Ì¾ )
> ON ( `table-a`.`Ka` = `table-b`.`Kb` )
>
> ¤Ç¤·¤¿¡£
>
> ****************************************
> ¥³¡¼¥×¾ðÊó¥·¥¹¥Æ¥à³ô¼°²ñ¼Ò
> ±¿ÍÑ»ö¶ÈÉô
> ¥³¡¼¥×¥×¥é¥¶¥µ¡¼¥Ó¥¹¥Ç¥¹¥¯¥°¥ë¡¼¥×
> ÃæÀî¡¡µ®
> 175-0094
> ÅìµþÅÔ½Âë¶è½Âë3-29-8 ¥³¡¼¥×¥×¥é¥¶5F
> TEL 03-5778-8010
> E-MAIL takashi.nakagawa@xxxxxxxxxx
> ****************************************
>
> (2012/03/29 17:01), ÃæÀî µ® wrote:
>
>
>
>
¡á¡á¡á¡á¡á¡á¡á¡á¡á¡á¡á¡á¡á¡á¡á
³ô¼°²ñ¼Ò ÂçÍβèÃÏ¡¡
ÅÔ»Ô¾ðÊóÉô¡¡µ»½Ñ¸ÜÌä¡¡Íî¹ç¡¡»ÊϺ
¢©332-0031¡¡Àî¸ý»ÔÀÄÌÚ4¡Ý7¡Ý3
­ä¡§048-257-1100
fax¡§048-257-1353
e-mail¡§s.ochiai@xxxxxxxxxx
URL¡§http://www.taiyokakuchi.co.jp
¡á¡á¡á¡á¡á¡á¡á¡á¡á¡á¡á¡á¡á¡á¡á