¼±¡£¡£ÔÚÏߵȡ£¡£mysqlË÷ÒýÉèÖÃÎÊÌâ
±íÖÐÓÐ31¸ö×ֶΡ£ ÆäÖÐÉèÖÃÁËnumber,statλË÷Òý ALTER TABLE SALES DROP INDEX indes1, ADD INDEX (number,stat) »¹ÓÐÆäËûµÄ ALTER TABLE SALES DROP INDEX indes1, ADD INDEX (uid1,uid2...) Ò»¹²ÓÐ19¸öÉèÖóÉË÷Òý£¨ÕâЩË÷ÒýÄÚÈݶ¼ÊÇÊý×ֵģ© µÚÒ»´Î¡¢Ò»´ÎдÈë1000Êý¾ÝµÄʱºòÐèÒª10Ãë×óÓÒ µÚ¶þ´Î¡¢Ò»´ÎдÈë1000Êý¾Ý²î²»¶à20Ãë¶à¡£ Á¬Ðø...¿ÉÒÔ˵ÊÇÊý¾ÝÔÚ±íÖÐÒ²¶àдÈëµÄʱ¼ä¸ü¾ÃÁË¡£ ´ó¼Ò°ïæ¿´¿´¡£ÊÇ·ñÎÒÉèÖÃË÷ÒýÓÐÎó£¬ÄÄ·½ÃæÐèÒª½øÐÐÓÅ»¯µÄ¡£
ÄãµÄÇé¿öÊDzåÈëÊý¾Ý¿âÂý£¿ Ë÷ÒýÉèÖõö࣬²åÈ뵱ȻÂýÁË£¬¶øÇÒÊý¾ÝÁ¿Ôö´ó£¬Òâζ×Åÿ´Î±éÀú¸üÐÂË÷ÒýÊ÷ÐèÒªµÄʱ¼äÔ½À´Ô½¶à£¬Äãÿ²åÈëÒ»ÌõË÷ÒýÁеÄÊý¾Ý£¬¶¼ÒªÈ¥¸üÐÂÏà¹ØË÷ÒýÐÅÏ¢µÄ¡£ »¹ÊÇÒª¾ßÌå·ÖÎöÄãµÄÒµÎñÓ¦Óã¬ÊDz»ÊÇÓбØÒªÉèÖÃÄÇô¶àË÷Òý. Ë÷Òý¶Ô²éѯËٶȿ졣дÈëÒ²ÄܼӿìÂð¡£Çë½Ìһϡ£ÒýÓà Ë÷Òý¶Ô²éѯËٶȿ졣дÈëÒ²ÄܼӿìÂð¡£Çë½Ìһϡ£ ²éѯ¿ì£¬Ð´È뵱ȻÂý¡£ °ÑË÷ÒýÊ÷Àí½â³É×ֵ䣬Äã·ÔÄ×ÖµäµÄʱºòÊǿ죬ÄãÍù×ÖµäÀï¼ÓÈëµ¥´Ê£¬²»µÃ¿¼ÂÇÕâ¸öµ¥´Ê¼ÓÔÚʲôµØ·½Ã´£¬»¹¿ÉÄÜÓÐÆäËüһЩ¿¼ÂÇ£¿Õâ¸öÊÇÐèҪʱ¼äµÄ¡£ ¼ÓÁËË÷Òý²åÈë¿Ï¶¨»á±äÂý,ÒòΪ²åÈëÊý¾ÝµÄʱºòͬʱ»¹Òª¸üÐÂË÷ÒýÎļþ¡£ ¼ÓË÷Òý¿ÉÒÔÌá¸ß¸üеÄËÙ¶È¡£ Ò»Õűí Ò»°ã²»Òª³¬¹ý3¸öË÷Òý 19¸öÏ൱µÄ¶à°¡ ÒòΪÓÐЩ×Ö¶ÎÐèÒª²éѯ»ã×Ü¸Ã±í¡£Èç¹û²»×öË÷Òý»á²»»áÓ°ÏìËÙ¶ÈÄØ£¿ 100ÍòµÄÊý¾ÝÏ ½ö½ö´ÓÊý¾Ý¿â½Ç¶È¿¼ÂÇ£¬²»·ÖÎö¾ßÌåÒµÎñ ÓÃmemoryÒýÇæ£¬¿ÉÒÔ¸ü¿ìһЩ£¬ ÓÉÓÚmemory±íÔÚÊý¾Ý¿â·þÎñÒâÍâÖÕÖ¹µÄÇé¿öÏ£¬Êý¾Ý»áͳͳ¶ªÊ§ ËùÒÔ±ØÐ
Ïà¹ØÎÊ´ð£º
ÎÒÓÐÒ»¸öjava»·¾³ÏµijÌÐò£¬ÔÚ±¾»úÔËÐÐÕý³££¬µ«·¢²¼µ½ÍøµÄÐéÄâÖ÷»úʱ²»ÄÜÁ¬½ÓÊý¾Ý¿âÁ¬½Ó³Ø jdk 1.6 tomcat6.0.18 mysql5 mysqljdbc5.1.5 ÐéÄâÖ÷»úµÄ¼¼ÊõÈËԱ˵£¬Ö»ÄÜÅäÖþÖÓòµÄÊý¾Ý¿âÁ¬½Ó³Ø£¬Ò²¾ÍÊÇÔÚM ......
ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£º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. ¿ÉÊÇÎÒÕÒ ......
²»ÖªµÀÊDz»ÊÇÎÒµÄxamppÓÐÎÊÌ⣬mysqlÊÇͼÐλ¯µÄ£¡ Ò»¸öID×éÔÚÎÒµÄmysqlµÄ±íÀïÃæ 2£¬5£¬8£¬7 µãÁËÅÅÐò£¬È»ºóÓÃPHPÎļþÁ¬½ÓÕâ¸ö±íÏÔʾ±íµÄÐÅϢʱ£¬IDµÄ˳Ðò»¹ÊDz»±ä£¡Ó¦¸ÃÊÇ2£¬5£¬7£¬8µÄ°ÉÉýÐòÅÅÐòºó£¡ ÔÚPHPÎļþÀï ......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡ лл¸÷λÁË ¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î ±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡ ллÁË ¼Æ»®ÈÎÎñ...php....sql...truncate....OK Äã¾ÍÕâ½ÓÔÚҳà ......