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

Öîλ£ºÔõôÑù²ÅÄÜÖÕÖ¹Ò»¸ömysql²éѯ

¸Õ²ÅÖ´ÐÐÁËÒ»¸ömysql²éѯ£¬·¢ÏÖÊý¾ÝºÜ¶à£¬ºÜ¶à£¬ÇëÎÊ
ÔõôÑù²ÅÄÜÖÕÖ¹Ò»¸ömysql²éÑ¯ÄØ£¿£¿
×î¼òµ¥µÄ°ì·¨£º °Ñ½ø³Ì kill µô

¹Ø±ÕÊý¾Ý¿âÁ¬½Ómysql_close($conn);¾ÍOKÁË $connÊÇÁ¬½ÓÊý¾Ý¿âµÄ¾ä±ú!

¶¥2Â¥£¬É±½ø³Ì
ÈýÂ¥µÄcloseÄÇÒ²ÊDzéÍêÖ®ºóµÄÊÂÁË£¬Ã»Óá£
Èç¹ûÊý¾Ý¶à£¬¿ÉÒÔÓÃlimitÏÞÖÆ²éѯÊýÁ¿
SELECT * from table LIMIT 5,10; // ¼ìË÷¼Ç¼ÐÐ6-15

1Â¥ 2Â¥ ˵³É 2Â¥ 3Â¥ÁË

kill

SHOW PROCESSLIST;
KILL ²é³öÀ´µÄId;

reset apach

ÖØÆôµçÄÔ

1.kill process¡£

2.limited query number£¡£¡

xuexi

ÓÃMS-DOS Èç¹ûÖÕÖ¹µÄ»° Ö±½ÓCTR+C


shutdown -p



Ïà¹ØÎÊ´ð£º

eclipseÓëmySQLµÄÎÊÌâ - Java / Eclipse

ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂð£¿
Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡
²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......

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

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

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

Äã¾ÍÕâ½ÓÔÚҳà ......

ΪʲôMySQL²»Ö§³ÖÖÐÎİ¡£¿£¿

ÈçÌ⣬MySQL²»»áÕâÑù°É
Ö§³Ö£¬Ä㽨Á¢Êý¾Ý¿âµÄʱºòÖ¸¶¨×Ö·û¼¯utf8»òÕßgbk¾ÍÐÐÁË¡£

http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx
MySQL ÖÐÎÄÏÔʾÂÒÂë

Ö§³Ö£¬¼ì²é×Ö·û¼¯ÉèÖÃ

Ö§³Ö£¬¼ì² ......

ASP +Mysql proc

ÏëÇë½ÌÒ»¸öÎÊÌ⣬ASP+mysql »á²»»áÓÐÁ¬½ÓĬÈÏʱ¼ä¡£
ÎÒÓöµ½Ò»¸öÎÊÌ⣺ÎÒÔÚÒ³ÃæÉϰ´Ò»¸öSave°´Å¥£¬Õâ¸ö°´Å¥ÊÇÑ­»·ÔËÐÐ100ƪ insertÊý¾ÝµÄ´æ´¢¹ý³Ì¡£ asp´úÂëÓ¦¸ÃûÓдíµÄ£¬Êý¾ÝÎÒÊÇ·ÅÔÚÒ»¸öÊý×éµÄÈç¹ûÎÒÖ»±£´æ50¸öÊÇ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ