Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

¼±¡£¡£ÔÚÏߵȡ£¡£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±íÔÚÊý¾Ý¿â·þÎñÒâÍâÖÕÖ¹µÄÇé¿öÏ£¬Êý¾Ý»áͳͳ¶ªÊ§
ËùÒÔ±ØÐ


Ïà¹ØÎÊ´ð£º

mysqlµÄÇý¶¯³ÌÐò

ÎÒÓÐÒ»¸öjava»·¾³ÏµijÌÐò£¬ÔÚ±¾»úÔËÐÐÕý³££¬µ«·¢²¼µ½ÍøµÄÐéÄâÖ÷»úʱ²»ÄÜÁ¬½ÓÊý¾Ý¿âÁ¬½Ó³Ø
jdk 1.6 tomcat6.0.18 mysql5 mysqljdbc5.1.5
ÐéÄâÖ÷»úµÄ¼¼ÊõÈËԱ˵£¬Ö»ÄÜÅäÖþÖÓòµÄÊý¾Ý¿âÁ¬½Ó³Ø£¬Ò²¾ÍÊÇÔÚM ......

MYSQL°²×°Ê§°Ü

ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£º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.
¿ÉÊÇÎÒÕÒ ......

ÓÃPHPÅÅÐòmysqlÎÊÌâ

²»ÖªµÀÊDz»ÊÇÎÒµÄxamppÓÐÎÊÌ⣬mysqlÊÇͼÐλ¯µÄ£¡
Ò»¸öID×éÔÚÎÒµÄmysqlµÄ±íÀïÃæ 2£¬5£¬8£¬7
µãÁËÅÅÐò£¬È»ºóÓÃPHPÎļþÁ¬½ÓÕâ¸ö±íÏÔʾ±íµÄÐÅϢʱ£¬IDµÄ˳Ðò»¹ÊDz»±ä£¡Ó¦¸ÃÊÇ2£¬5£¬7£¬8µÄ°ÉÉýÐòÅÅÐòºó£¡
ÔÚPHPÎļþÀï ......

ÈçºÎ¶¨ÆÚɾ³ýmysqlÊý¾Ý - PHP / »ù´¡±à³Ì

ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË

¼Æ»®ÈÎÎñ...php....sql...truncate....OK

Äã¾ÍÕâ½ÓÔÚҳà ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ