Öîλ£ºÔõôÑù²ÅÄÜÖÕÖ¹Ò»¸ö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
Ïà¹ØÎÊ´ð£º
ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂð£¿
Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡
²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
ÈçÌ⣬MySQL²»»áÕâÑù°É
Ö§³Ö£¬Ä㽨Á¢Êý¾Ý¿âµÄʱºòÖ¸¶¨×Ö·û¼¯utf8»òÕßgbk¾ÍÐÐÁË¡£
http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx
MySQL ÖÐÎÄÏÔʾÂÒÂë
Ö§³Ö£¬¼ì²é×Ö·û¼¯ÉèÖÃ
Ö§³Ö£¬¼ì² ......
ÏëÇë½ÌÒ»¸öÎÊÌ⣬ASP+mysql »á²»»áÓÐÁ¬½ÓĬÈÏʱ¼ä¡£
ÎÒÓöµ½Ò»¸öÎÊÌ⣺ÎÒÔÚÒ³ÃæÉϰ´Ò»¸öSave°´Å¥£¬Õâ¸ö°´Å¥ÊÇÑ»·ÔËÐÐ100ƪ insertÊý¾ÝµÄ´æ´¢¹ý³Ì¡£ asp´úÂëÓ¦¸ÃûÓдíµÄ£¬Êý¾ÝÎÒÊÇ·ÅÔÚÒ»¸öÊý×éµÄÈç¹ûÎÒÖ»±£´æ50¸öÊÇ ......