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

MYSQL´æ´¢¹ý³Ì¼Ç¼ÈçºÎ²åÈëÒ»¸öбí

ͳһ·ç¸ñ£¬Ê×ÏÈÌù´úÂë
SQL code:


call SP_Ping_Dialtest('NetWork_Type',8,6,'2GG','G','3','Ping Test','2009-01-02 12:00:00','2009-12-02 12:01:00')



µÃµ½¼Ç¼ NÌõ

ÏÖÔÚÏë°ÑÕâNÌõ¼Ç¼²åÈëµ½±íTÖУ¬Ôõô´¦Àí£¿£¿
¸Ï½ô×Ô¼º×øÉ³·¢£¬Òª²»Âí¿Ë˼ÓÖÀ´ÁË¡£

ÔÚÏߵȡ£

´óºú×ÓÀ´ÁË!

ÒýÓÃ
¸Ï½ô×Ô¼º×øÉ³·¢£¬Òª²»Âí¿Ë˼ÓÖÀ´ÁË¡£

ÔÚÏߵȡ£


ÎÞÂÛʲôÑùµÄSQL,²åÈ뵽бíÎÞ·ÇÊÇSelect intoºÍInsert into
ÄãÄDZßÓпͻ§¶Ë¹¤¾ß,¿´ÕâÁ½ÖÖÓï¾äµÄ°ïÖú¼´¿É
ÎʱðÈËÒ²Êǰ״î


ÒýÓÃ
ÎÞÂÛʲôÑùµÄSQL,²åÈ뵽бíÎÞ·ÇÊÇSelect intoºÍInsert into
ÄãÄDZßÓпͻ§¶Ë¹¤¾ß,¿´ÕâÁ½ÖÖÓï¾äµÄ°ïÖú¼´¿É
ÎʱðÈËÒ²Êǰ״î



µÈÓÚû˵¡£

ÄÇÄã¾ÍµÈןßÈ˸øÄãд°É

ÒýÓÃ
ÒýÓà 3 Â¥ getemail µÄ»Ø¸´:
ÎÞÂÛʲôÑùµÄSQL,²åÈ뵽бíÎÞ·ÇÊÇSelect intoºÍInsert into
ÄãÄDZßÓпͻ§¶Ë¹¤¾ß,¿´ÕâÁ½ÖÖÓï¾äµÄ°ïÖú¼´¿É
ÎʱðÈËÒ²Êǰ״î


µÈÓÚû˵¡£


ÒýÓÃ
ÄÇÄã¾ÍµÈןßÈ˸øÄãд°É

ÒýÓà 4 Â¥ zuoxingyu µÄ»Ø¸´:
ÒýÓà 3 Â¥ getemail µÄ»Ø¸´:
ÎÞÂÛʲôÑùµÄSQL,²åÈ뵽бíÎÞ·ÇÊÇSelect intoºÍInsert into
ÄãÄDZßÓпͻ§¶Ë¹¤¾ß,¿´ÕâÁ½ÖÖÓï¾äµÄ


Ïà¹ØÎÊ´ð£º

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

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

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

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

MySQLÊý¾Ý°ü¹ý´ó

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


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

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 µ¼ÖÂËÀ»ú

»·¾³£ºwin2003 apache2 resin3 php5 mysql5
mysql´íÎóÀï³öÏÖÕâ¸ö£¬·þÎñÆ÷Ö±½ÓËÀµ½ÄÇÀï¡£
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_log ......

mysqlµÄÇý¶¯³ÌÐò

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