¼±¡£¡£ÔÚÏߵȡ£¡£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±íÔÚÊý¾Ý¿â·þÎñÒâÍâÖÕÖ¹µÄÇé¿öÏ£¬Êý¾Ý»áͳͳ¶ªÊ§
ËùÒÔ±ØÐ
Ïà¹ØÎÊ´ð£º
ÈçÌ⣬ÕâÈý¸öÔÚwin7ÏÂʹÓûáÓÐʲô¼æÈÝÐÔÎÊÌâÂð£¿
ÓÉÓÚÎÒ×î½üÔÚʹÓÃwin7£¬¾ÍÀÁµÃ½øxpÁË£¡
×Ô¼ºÓÃwindows 2008ÓÐÒ»Äê¶àÁË£¬Ã»³öÏÖÈκÎÎÊÌâ¡£
win7²âÊÔ°æÒ²Óùý£¬²»»áÓÐʲôÎÊÌâµÄ£¬·ÅÐÄ¡£
µ±È»Äã×î ......
ÎÒÓÃÒ»¸öÑ»·ÍùÊý¾Ý¿âÀïÃæ´æÎļþ£¬±¾À´¿ÉÒÔ×÷ΪÎļþ´æ·ÅÊý¾Ý¿âÀïÃæÖ»·ÅÎļþµÄλÖõ쬵«ÊÇûÓа취×âµÄ·þÎñÆ÷ÍøÒ³¿Õ¼ä´óСÓÐÏÞÖÆÊý¾Ý¿âûÓÐÏÞÖÆ¡£Óï¾äÊÇÕâÑùµÄ
public static final DataBase.MAXSIZE=102 ......
Óиöwinform³ÌÐò,ʹÓÃc#+mysql,ÐèÒªÔÚÒ»¸ö´°ÌåÉèÖÃmysql×Ô¶¯É¾³ý¹¦ÄÜ,°üÀ¨×Ô¶¯É¾³ý¶àÉÙÌì֮ǰµÄÊý¾ÝÒÔ¼°ÊÇ·ñ¿ªÆô×Ô¶¯É¾³ý¹¦ÄÜ,ÎÒ³ÌÐòÍ˳öºó,»¹Ôõô¿ØÖÆMysql×Ô¼ºÉ¾³ý°¡?ÊDz»ÊÇÒªÓÃmysqlµÄeventÀ´ÊµÏÖ?c#¿ÉÒÔµ÷ÓÃmysq ......
²»ÖªµÀÊDz»ÊÇÎÒµÄxamppÓÐÎÊÌ⣬mysqlÊÇͼÐλ¯µÄ£¡
Ò»¸öID×éÔÚÎÒµÄmysqlµÄ±íÀïÃæ 2£¬5£¬8£¬7
µãÁËÅÅÐò£¬È»ºóÓÃPHPÎļþÁ¬½ÓÕâ¸ö±íÏÔʾ±íµÄÐÅϢʱ£¬IDµÄ˳Ðò»¹ÊDz»±ä£¡Ó¦¸ÃÊÇ2£¬5£¬7£¬8µÄ°ÉÉýÐòÅÅÐòºó£¡
ÔÚPHPÎļþÀï ......
½¨±í£º²å¼Ç¼
SQL code:
create table tablename (id int,RQ1 datetime,RQ2 datetime)
-- select * from tablename
insert into tablename
select 1,'2009-01-01 10:00:00','2009-01-02 11:00:00' union
......