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

mysqlµÄcloseÓÐûÓбØÒª£¿

RT
лл
µ±½Å±¾Ö´ÐÐÍê±Ïºó£¬»á×Ô¶¯ÊÍ·Å×ÊÔ´
ËùÒÔµ±ÄãûÓÐʹÓÃmysql_close()¹Ø±ÕÁ´½Ó×ÊԴʱ Ò²²»»á±¨´í
µ±ÄãÓжà¸öÁ´½Ó×ÊԴʱ ¿ÉÒÔʹÓÃmysql_close($link)À´Ñ¡Ôñ¹Ø±Õ

×îºÃÊÇÓÃÉÏ£¡

ÓÐÀûÓÚ¸üР´Ó·þÎñÆ÷¶ø·µ»ØÒ³Ãæ

ÔÚ³ÌÐò±È½Ï¸´ÔÓʱ£¬Ð´²»ºÃÈÝÒ×±¨´í¡££¨close³öÏÖ¶à´Î£©

ËùÒÔ×îºÃ²»ÒªÐ´£¬Ò²Ã»ÓбØÒªÐ´¡£

дµÄ»°Ç°Ãæ¼ÓÉÏÅжÏif($conn!=null){mysql_close($conn);}

ѧϰ

×ۺϿ¼ÂÇÁËһϣ¬²»ÓÃcloseÁË¡£
лл´ó¼Ò£¡

ÎÒÈÏΪ±ØÐëÓÃÉÏ ÕâÊǸöÁ¼ºÃµÄϰ¹ß ²¢ÇÒ¿ÉÒÔ½ÚÊ¡²»ÉÙϵͳ×ÊÔ´  ¼°Ê±Êͷſռä

Ò³Ãæ×ªÊ±¼º¾­ÊÍ·ÅÁË£¬²»ÓÃÒ²ÐУ¬ÎÒÒ²²»ÓõÄ

mei yong guo

phpÒýÇæ»á×Ô¶¯´¦Àí,²»¹Ø±ÕҲûÊÂ

×îºÃÓÃÉÏ£¬ÄܽÚÊ¡×ÊÔ´
Èç¹û·ÃÎÊÁ¿²»´ó¾ÍÎÞËùνÁË

СÊý¾Ý¿âûɶ£¬´óµÄ¾ÍÈÝÒ׿´³öÀ´¿©

²»ÓÃ.......ÈÝÒ×±¨´í..

ÒÔǰɵµÄʱºò..°ÑËüдÈëÀàÀïÃæ.... ÔÎÁ˺þÃ,²Å·¢ÏÖÎÊÌâËùÔÚ...

дÉϴ˺¯ÊýÊǸöÁ¼ºÃµÄϰ¹ß¡£

ű¨´í¾ÍÓ¦¸Ã¼Ó²ÎÊý¡£

È¥¿´¿´ÊÖ²á°É

¸öÈ˾õµÃÒªÓÃÉÏ£¬ÕâÑù²ÅÄܳä·ÖÀûÓÃÄãµÄϵͳ×ÊÔ´£¡


Ïà¹ØÎÊ´ð£º

Çómysql+php ÖÐÎÄÈ«ÎÄËÑË÷

×ö¸öÕ¾ÄÚËÑË÷£¬ÏÖÔÚÓÃlike ÕâÑùµÄЧÂÊʵÔÚÌ«µÍÁË£¬Ïë¸Ä³ÉÈ«ÎÄËÑË÷·½Ê½¡£

µ«¿´ÁËÍøÉÏ˵µÄÖÐÎÄÖ§³Ö²»ºÃ£¬ÏëÎÊһϸ÷λÐÖµÜÊÇÈçºÎ½â¾öÕâ¸öÎÊÌâµÄ£¿
µ¥¶À½¨Á¢Ö÷Ìâ±íºÍÄÚÈÝ±í ¼ìË÷Ö÷Ìâ

È»ºó¸ù¾ÝÖ÷Ìâ¼ìË÷Ä ......

MySQLÊý¾Ý°ü¹ý´ó

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


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

MYSQL Êý¾Ý½ØÈ¡

MYSQL ½ØÈ¡Ò»¸öÊý¾Ý±íÖÐ,ijһ¸ö×Ö¶Î(fulltext) µÄǰÈý°Ù¸ö×Ö·û,·Åµ½¸Ã±íÏÂÁíÒ»¸ö×Ö¶Î(introtxt)Àï.
ÇóʵÏÖÕâ¸öЧ¹ûµÄÃüÁî
SQL code:
update ±í set introtxt=left(`fulltext`,300);

¶¥£¬Ñ§Ï°

SQL code: ......

mysqlÓï¾äÓÅ»¯ÎÊÌâ ´ó¼Ò¸øÓÅ»¯¸öSQLÓï¾ä

SELECT a.tguildname ,SUM(a.ct) +  if (SUM(b.ct) IS NULL ,0,SUM(b.ct)) from (
SELECT  tg.tguildname,c.cid, (
cf.fbb + cf.fgjbb + cf.fjybb + cf.fqb + cf.fgjqb + cf.fjyqb + cf.fqib + cf. ......

mysqlµÄÇý¶¯³ÌÐò

ÎÒÓÐÒ»¸öjava»·¾³ÏµijÌÐò£¬ÔÚ±¾»úÔËÐÐÕý³££¬µ«·¢²¼µ½ÍøµÄÐéÄâÖ÷»úʱ²»ÄÜÁ¬½ÓÊý¾Ý¿âÁ¬½Ó³Ø
jdk 1.6 tomcat6.0.18 mysql5 mysqljdbc5.1.5
ÐéÄâÖ÷»úµÄ¼¼ÊõÈËԱ˵£¬Ö»ÄÜÅäÖþÖÓòµÄÊý¾Ý¿âÁ¬½Ó³Ø£¬Ò²¾ÍÊÇÔÚM ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ