mysql:15709
From: ÃæÀî µ® <ÃæÀî µ® <takashi.nakagawa@xxxxxxxxxx>>
Date: Thu, 29 Mar 2012 17:46:28 +0900
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 > ¡á¡á¡á¡á¡á¡á¡á¡á¡á¡á¡á¡á¡á¡á¡á >
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]