Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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±íÔÚÊý¾Ý¿â·þÎñÒâÍâÖÕÖ¹µÄÇé¿öÏ£¬Êý¾Ý»áͳͳ¶ªÊ§
ËùÒÔ±ØÐ


Ïà¹ØÎÊ´ð£º

apache+PHP+mysqlÔÚwin7ÏÂʹÓÃ

ÈçÌ⣬ÕâÈý¸öÔÚwin7ÏÂʹÓûáÓÐʲô¼æÈÝÐÔÎÊÌâÂð£¿
ÓÉÓÚÎÒ×î½üÔÚʹÓÃwin7£¬¾ÍÀÁµÃ½øxpÁË£¡
×Ô¼ºÓÃwindows 2008ÓÐÒ»Äê¶àÁË£¬Ã»³öÏÖÈκÎÎÊÌâ¡£

win7²âÊÔ°æÒ²Óùý£¬²»»áÓÐʲôÎÊÌâµÄ£¬·ÅÐÄ¡£

µ±È»Äã×î ......

MySQLÊý¾Ý°ü¹ý´ó

ÎÒÓÃÒ»¸öÑ­»·ÍùÊý¾Ý¿âÀïÃæ´æÎļþ£¬±¾À´¿ÉÒÔ×÷ΪÎļþ´æ·ÅÊý¾Ý¿âÀïÃæÖ»·ÅÎļþµÄλÖõ쬵«ÊÇûÓа취×âµÄ·þÎñÆ÷ÍøÒ³¿Õ¼ä´óСÓÐÏÞÖÆÊý¾Ý¿âûÓÐÏÞÖÆ¡£Óï¾äÊÇÕâÑùµÄ


public static final DataBase.MAXSIZE=102 ......

c#¿ØÖÆMysql ʵÏÖ×Ô¶¯É¾³ý¹¦ÄÜ - .NET¼¼Êõ / C#

Óиöwinform³ÌÐò,ʹÓÃc#+mysql,ÐèÒªÔÚÒ»¸ö´°ÌåÉèÖÃmysql×Ô¶¯É¾³ý¹¦ÄÜ,°üÀ¨×Ô¶¯É¾³ý¶àÉÙÌì֮ǰµÄÊý¾ÝÒÔ¼°ÊÇ·ñ¿ªÆô×Ô¶¯É¾³ý¹¦ÄÜ,ÎÒ³ÌÐòÍ˳öºó,»¹Ôõô¿ØÖÆMysql×Ô¼ºÉ¾³ý°¡?ÊDz»ÊÇÒªÓÃmysqlµÄeventÀ´ÊµÏÖ?c#¿ÉÒÔµ÷ÓÃmysq ......

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

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

MYSQL 5.0£¬ÊÂÎñ»Ø¹öµÄÎÊÌâ

½¨±í£º²å¼Ç¼
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
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ