ÓÃmysql¿Í»§¶Ë·ÖÎö¹ýÁË µÚÒ»ÖÖÇé¿ö ÀïÃæÓÐÒ»¸öÌáʾ£ºRange checked for each record (index map: 0x2) ¶øÁíÍâÒ»¸öÊÇuseing where Ìù³öexplain SQLÓï¾äÍêÕû½á¹û²ÅÄܱãÓÚ·ÖÎö
Èç¹ûÔÙÓÐshow create table ±íÃû£»show indexes from ±íÃû µÄ½á¹û¾Í¸üºÃ·ÖÎöÁË explian select a.name ,b.name from tableA a,tableB b where a.id = b.id and ¡£¡£¡£
ÎÒÒÔÇ°°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£ºError 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it. ¿ÉÊÇÎÒÕÒ ......