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]