[Á°][¼¡][ÈÖ¹æ½ç°ìÍ÷][¥¹¥ì¥Ã¥É°ìÍ÷]

mysql:15711

From: "ochiai" <"ochiai" <s.ochiai@xxxxxxxxxx>>
Date: Thu, 29 Mar 2012 17:58:50 +0900
Subject: [mysql 15711] Re: Left Join¶ç¤òÉÕ¤±¤¿UPDATE½èÍý»þ´Ö¤¬Èó¾ï¤ËŤ¯¤«¤«¤Ã¤Æ

ÃæÀîÍÍ
¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤¹¡£

¼Â¹Ô·ë²Ì¤Ï°Ê²¼¤ÎÄ̤ê¤È¤Ê¤ê¤Þ¤·¤¿¡£

select_type table     type  possible_keys key     key_len ref     rows Extra
SIMPLE     table-a  ALL  NULL           NULL  NULL   NULL 20Ëü
SIMPLE     table-b  index NULL           Kb      63       NULL 14Ëü 
Usingindex

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



> SELECTʸ¤ÎƬ¤Ë¤Ä¤±¤Æ¤¯¤À¤µ¤¤¡Ê¶õÇò¤Ê¤ê²þ¹Ô¤Ç¶èÀڤäơˡ£
> ¤³¤ì¤ÇINDEX¤ò»ÈÍѤ·¤Æ¤¤¤ë¤Î¤«¤É¤¦¤«¤¬Ê¬¤«¤ê¤Þ¤¹¡£
>
> ****************************************
> ¥³¡¼¥×¾ðÊó¥·¥¹¥Æ¥à³ô¼°²ñ¼Ò
> ±¿ÍÑ»ö¶ÈÉô
> ¥³¡¼¥×¥×¥é¥¶¥µ¡¼¥Ó¥¹¥Ç¥¹¥¯¥°¥ë¡¼¥×
> ÃæÀî¡¡µ®
> 175-0094
> ÅìµþÅÔ½Âë¶è½Âë3-29-8 ¥³¡¼¥×¥×¥é¥¶5F
> TEL 03-5778-8010
> E-MAIL takashi.nakagawa@xxxxxxxxxx
> ****************************************
>
> (2012/03/29 17:42), ochiai wrote:
>> ÃæÀîÍÍ
>>
>> ¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤¹¡£
>>
>>> 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
>> ¡á¡á¡á¡á¡á¡á¡á¡á¡á¡á¡á¡á¡á¡á¡á
>>
>
>
>
¡á¡á¡á¡á¡á¡á¡á¡á¡á¡á¡á¡á¡á¡á¡á
³ô¼°²ñ¼Ò ÂçÍβèÃÏ¡¡
ÅÔ»Ô¾ðÊóÉô¡¡µ»½Ñ¸ÜÌä¡¡Íî¹ç¡¡»ÊϺ
¢©332-0031¡¡Àî¸ý»ÔÀÄÌÚ4¡Ý7¡Ý3
­ä¡§048-257-1100
fax¡§048-257-1353
e-mail¡§s.ochiai@xxxxxxxxxx
URL¡§http://www.taiyokakuchi.co.jp
¡á¡á¡á¡á¡á¡á¡á¡á¡á¡á¡á¡á¡á¡á¡á 


[Á°][¼¡][ÈÖ¹æ½ç°ìÍ÷][¥¹¥ì¥Ã¥É°ìÍ÷]

     15703 2012-03-29 15:08 ["ochiai" <s.ochiai@x] Left Join¶ç¤òÉÕ¤±¤¿UPDATE½èÍý»þ´Ö¤¬Èó¾ï¤ËŤ¯¤«¤«¤Ã¤Æ
     15705 2012-03-29 16:56 ¨²[ÃæÀî µ® <takashi.nak]                                       
     15706 2012-03-29 17:01 ¨±[ÃæÀî µ® <takashi.nak]                                       
     15707 2012-03-29 17:12 ¡¡¨±[ÃæÀî µ® <takashi.nak]                                     
     15708 2012-03-29 17:42 ¡¡¡¡¨±["ochiai" <s.ochiai@x]                                   
     15709 2012-03-29 17:46 ¡¡¡¡¡¡¨²[ÃæÀî µ® <takashi.nak]                                 
->   15711 2012-03-29 17:58 ¡¡¡¡¡¡¨­¨±["ochiai" <s.ochiai@x]                               
     15712 2012-03-29 20:25 ¡¡¡¡¡¡¨­¡¡¨²[HIRATSUKA Sadao <hir]                             
     15713 2012-03-30 01:27 ¡¡¡¡¡¡¨­¡¡¨±[ÃæÀîµ® <nora1962@xxx]                             
     15727 2012-04-11 17:03 ¡¡¡¡¡¡¨­¡¡¡¡¨±["ochiai" <s.ochiai@x] Re: Left Join¶ç¤òÉÕ¤±¤¿UPDATE½èÍý»þ´Ö¤¬Èó¾ï¤ËŤ¯¤«¤«¤Ã¤Æ¡ÊĹʸ¡Ë
     15728 2012-04-11 18:24 ¡¡¡¡¡¡¨­¡¡¡¡¡¡¨±[ÃæÀî µ® <takashi.nak]                         
     15729 2012-04-12 09:46 ¡¡¡¡¡¡¨­¡¡¡¡¡¡¡¡¨±[HIRATSUKA Sadao <hir]                       
     15730 2012-04-13 10:32 ¡¡¡¡¡¡¨­¡¡¡¡¡¡¡¡¡¡¨±["ochiai" <s.ochiai@x] Re: Left Join¶ç¤òÉÕ¤±¤¿UPDATE½èÍý»þ´Ö¤¬Èó¾ï¤ËŤ¯¤«¤«¤Ã¤Æ¡Ê²ò·è¸æÎé¡Ë
     15733 2012-04-13 11:13 ¡¡¡¡¡¡¨­¡¡¡¡¡¡¡¡¡¡¡¡¨±[HIRATSUKA Sadao <hir]                   
     15710 2012-03-29 17:47 ¡¡¡¡¡¡¨±[Masaaki Matsuyama <m]