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

mysql show processlist;ÎÊÌâ

µ±Á¬½ÓÊý¹ý¶àʱ£¬ÎÒÃÇ»áÓÃshow processlist£»ÃüÁî²é¿´¶¼ÔÚÅÜʲô½ø³Ì£¬µ«ÊÇÓÐ1000¸öÁ¬½Ó£¬Ç°ÃæµÄ¶¼±»Ë¢ÆÁË¢µôÁË ¿´²»µ½ £¿  ÎÊ Ôõô²ÅÄÜÕÒµ½×èÈûµÄSQL½ø³ÌÄØ£¿

ÎÒÊÔÊÔ ¡­¡­¡­¡­¡­¡­¡­¡­

OK лл ¿´À´ÎÒµÄ֪ʶ»¹Ã»ÓÐѧϵͳ°¢


Ïà¹ØÎÊ´ð£º

mysqlÁ¬½Ótomcat - Java / Web ¿ª·¢

ÎÒÒѾ­°´Õս̳ÌÉÏÅäÖÃtomcatµÄserver.xml
<Context path = "/POS" docBase = "POS" debug = "5" reloadable = "true" crossContext = "true" workDir = &quo ......

mysqlÖÐÎÄÂÒÂë - C/C++ / C++ ÓïÑÔ

mysqlÊý¾Ý¿âµÄ±àÂë¸ñʽÊÇutf8
ÔÚc++³ÌÐòÖÐʹÓÃC APIÖ±½ÓÁ¬½ÓmysqlÊý¾Ý¿â£¬°ÑÖÐÎı£´æµ½mysqlÊý¾Ý¿âÖУ¬ÖÐÎç±ä³ÉÂÒÂë
ʹÓÃmysqlµÄloadÃüÁîµ¼ÈëÎı¾Îļþ£¬ÎÞÂÛÎı¾ÎļþÊÇANSI»¹ÊÇutf8±àÂ룬¶¼ÊÇÂÒÂë
ÇëÎÊÉÏÃæÁ½¸öÎÊ ......

mysql Îļþ¶ÁÈ¡ - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

ÎÒ¼¸ÕÅmysql±í ·ÖÇø
È»ºó°Ñ·ÖÇø±íµ¥¶À¿½³öÀ´ 
ÀýÈ磺test.MYD test.MYI data.MYD data.MYI user.MYD user.MYI dem.MYD dem.MYI
ÎÒÏë¶ÁÈ¡ÕâËÄÕűíµÄÄÚÈÝ
¹ØÁªÊý¾ÝÕûºÏµ½Ò»ÕűíÖС£Õâ¸öÒªÔõô×öÄØ
ÓóÌÐòÔ ......

¹ØÓÚMySQLɾ³ý¼Ç¼ºóIDÈçºÎÁªÏµ

id INT NOT NULL PRIMARY KEY AUTO_INCREMENT
È»ºóɾ³ýÊý¾Ý¿âÖеÄÈô¸ÉÖØ¸´¼Ç¼ºóID±äµÄ²»Á¬Ðø£¬ÈçºÎ±äµÃÁ¬Ðø£¿£¿
ÔËÐÐ
ALTER TABLE tablename DROP id;
ALTER TABLE tablename ADD id INT NOT NULL PRIMARY KEY ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ