MySQL·þÎñ£¨sever£©²»ÄÜÆô¶¯
µÚÒ»´Î°²×°MySQLºóÐ¶ÔØÁË£¬µÚ¶þ´Î°²×°ºó MySQL·þÎñ£¨sever£©²»ÄÜÆô¶¯
״̬ÊÇ£¨×Ô¶¯£© ¿ªÊ¼ºóÌáʾ¡°Ïß³ÌÒâÍâÖÕÖ¹¡£(°²×°Á˶à´Î»¹ÊÇÄÇÑù)ÆäËû·½·¨Ò²ÊÔ¹ý£¬Í¬ÑùµÄÌáʾ¡£
Çë¸ßÊÖÖ¸½Ì¡£
MYSQLµÄ»°,Äã¾ÍÀ´´íµØ·½ÁË.
»¹ÕæµÄ·¢´íµØ·½ÁË5
°ï¶¥ µÈPÁºÀ´½â¾ö
¸ßÊÖÔÆ¼¯£¬ÇëÖ¸½ÌÏ£¬
±¨1067ºÅ´íÎ󣺽ø³ÌÒâÍâÖÕÖ¹
ÊÇʲôÔÒòa£¿
basedirµÄ·¾¶²»¶Ô
ÎʹÈÀÏʦ°É——
End_rbody_60778711//-->
¸Ã»Ø¸´ÓÚ2009-10-30 14:37:44±»¹ÜÀíԱɾ³ý
¶ÔÎÒÓÐÓÃ[0]
¶ª¸ö°åש[0]
ÒýÓÃ
¾Ù±¨
¹ÜÀí
TOP
Love_baba_mama
(Love_baba_mama)
µÈ¡¡¼¶£º
#8Â¥ µÃ·Ö£º0»Ø¸´ÓÚ£º2009-10-30 18:09:37
»¹ÊDz»ÐÐ
¹ÈÀÏʦÊÇÄÇλ£¿£¿
Äã¿´Ò»ÏÂÄãµÄMYSQL ж¸É¾»Ã»£¿ MYSQL¶Ë¿Ú±»Õ¼ÓÃû£¿
¿´Ï´íÎó´úÂëÊDz»ÊÇ1064£¬Èç¹ûÊǵϰ£¬¾ÍÊÇÒòΪÄãÉϴΰ²×°Ð¶Ôز»ÍêÈ«£¬°²×°ÈÕÖ¾»¹Ã»ÓÐɾ³ý£¬ÕÒµ½°²×°ÈÕÖ¾£¬É¾³ýÁ˾ͿÉÒԸ㶨¡£
Ïà¹ØÎÊ´ð£º
ÓÃjsp×ö¶«Î÷¸øÍêÈ«²»¶®mysqlµÄÈËÓ㬿ÉÊDZ¸·ÝʱֻÓпÕÎļþ£¬ÕâÊÇʲôÇé¿ö£¬
×îºÃÓÐÔ´´úÂ룬лл
Æäʵ±¸·ÝµÄ¹ý³ÌÎÒÏë´ó¸ÅÊÇÕâÑùµÄ£º
½«±íAÖеÄÊý¾Ý·Åµ½ArrayListÖУ¬È»ºó½«Õâ¸öArrayListÖеÄÊý¾ÝÔÙ´æµ½±íBÖС£ ......
Ò»¸öÐÐÒµÍøÕ¾£¬ÒªÊµÏֵŦÄÜÒªÇóΪ£º
Ò»ËÑË÷±íµ¥¿ÉÑ¡ËÑË÷ ²úÆ·/×ÊѶ/É̼ң¬ËÑË÷ʱϣÍûÏÈËѱêÌâºóÈ«ÎÄ£¬µ±Ç°µÄÊý¾ÝÁ¿¹À¼Æ3Íò¶à£¬¶¨Î»ÆÚÍûÔÚ°ÙÍò¼¶Ò²¿ÉÓá£
Êý¾ÝÀàÐÍΪinnodb£¬µ±Ç°µÄ·½·¨ÊǶԹؼü´Ê½øÐÐ ......
MySQLÈëÃÅ
¿ÉÒÔÏÈ¿´Ê²Ã´Êé¼®°¡£¿
ÏȶÁÈý±é¡¶Êý¾Ý¿âϵͳ¸ÅÂÛ¡·,ÕÆÎÕÊý¾Ý¿âµÄ»ù´¡ÀíÂÛ¡£
È»ºóÔÙ´Ö¿´Ò»±éMYSQLµÄ¹Ù·½Îĵµ¡£ MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc/refman/5.1/zh/index.html
¾ÍÕÒÒ»±¾ºÜ»ù´ ......
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. ......
select * from table where '123456789' like '%'+×ֶαí+'%'
Õâ¾äsqlÔÚsqlserverÏÂͨ¹ý£¬ÔÚmysqlÏÂÓб¨´í£¬mysqlÏÂÈçºÎʵÏÖÕâÑùµÄ²éÑ¯ÄØ
SQL code:
select * from table whe ......