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ßÓпͻ§¶Ë¹¤¾ß,¿´ÕâÁ½ÖÖÓï¾äµÄ
Ïà¹ØÎÊ´ð£º
×ö¸öÕ¾ÄÚËÑË÷£¬ÏÖÔÚÓÃlike ÕâÑùµÄЧÂÊʵÔÚÌ«µÍÁË£¬Ïë¸Ä³ÉÈ«ÎÄËÑË÷·½Ê½¡£ µ«¿´ÁËÍøÉÏ˵µÄÖÐÎÄÖ§³Ö²»ºÃ£¬ÏëÎÊһϸ÷λÐÖµÜÊÇÈçºÎ½â¾öÕâ¸öÎÊÌâµÄ£¿ µ¥¶À½¨Á¢Ö÷Ìâ±íºÍÄÚÈÝ±í ¼ìË÷Ö÷Ìâ È»ºó¸ù¾ÝÖ÷Ìâ¼ìË÷Ä ......
ÎÒÓÃÒ»¸öÑ»·ÍùÊý¾Ý¿âÀïÃæ´æÎļþ£¬±¾À´¿ÉÒÔ×÷ΪÎļþ´æ·ÅÊý¾Ý¿âÀïÃæÖ»·ÅÎļþµÄλÖõ쬵«ÊÇûÓа취×âµÄ·þÎñÆ÷ÍøÒ³¿Õ¼ä´óСÓÐÏÞÖÆÊý¾Ý¿âûÓÐÏÞÖÆ¡£Óï¾äÊÇÕâÑùµÄ public static final DataBase.MAXSIZE=102 ......
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. ......
»·¾³£º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 ......
ÎÒÓÐÒ»¸öjava»·¾³ÏµijÌÐò£¬ÔÚ±¾»úÔËÐÐÕý³££¬µ«·¢²¼µ½ÍøµÄÐéÄâÖ÷»úʱ²»ÄÜÁ¬½ÓÊý¾Ý¿âÁ¬½Ó³Ø jdk 1.6 tomcat6.0.18 mysql5 mysqljdbc5.1.5 ÐéÄâÖ÷»úµÄ¼¼ÊõÈËԱ˵£¬Ö»ÄÜÅäÖþÖÓòµÄÊý¾Ý¿âÁ¬½Ó³Ø£¬Ò²¾ÍÊÇÔÚM ......