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

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


ÒýÓÃ
¸ßÊÖÔÆ¼¯£¬ÇëÖ¸½ÌÏ£¬
±¨1067ºÅ´íÎ󣺽ø³ÌÒâÍâÖÕÖ¹
ÊÇʲôԭÒòa£¿

»¹ÊDz»ÐÐ

ÒýÓÃ
ÎʹÈÀÏʦ°É——

¹ÈÀÏʦÊÇÄÇλ£¿£¿

Äã¿´Ò»ÏÂÄãµÄMYSQL ж¸É¾»Ã»£¿ MYSQL¶Ë¿Ú±»Õ¼ÓÃû£¿

¿´Ï´íÎó´úÂëÊDz»ÊÇ1064£¬Èç¹ûÊǵϰ£¬¾ÍÊÇÒòΪÄãÉϴΰ²×°Ð¶Ôز»ÍêÈ«£¬°²×°ÈÕÖ¾»¹Ã»ÓÐɾ³ý£¬ÕÒµ½°²×°ÈÕÖ¾£¬É¾³ýÁ˾ͿÉÒԸ㶨¡£


Ïà¹ØÎÊ´ð£º

jsp±¸·ÝmysqlÖ»ÓпÕÎļþ

ÓÃjsp×ö¶«Î÷¸øÍêÈ«²»¶®mysqlµÄÈËÓ㬿ÉÊDZ¸·ÝʱֻÓпÕÎļþ£¬ÕâÊÇʲôÇé¿ö£¬
×îºÃÓÐÔ´´úÂ룬лл
Æäʵ±¸·ÝµÄ¹ý³ÌÎÒÏë´ó¸ÅÊÇÕâÑùµÄ£º
½«±íAÖеÄÊý¾Ý·Åµ½ArrayListÖУ¬È»ºó½«Õâ¸öArrayListÖеÄÊý¾ÝÔÙ´æµ½±íBÖС£ ......

mysqlÈçºÎʵÏÖ¸ßЧµÄËÑË÷£¿

Ò»¸öÐÐÒµÍøÕ¾£¬ÒªÊµÏֵŦÄÜÒªÇóΪ£º

Ò»ËÑË÷±íµ¥¿ÉÑ¡ËÑË÷ ²úÆ·/×ÊѶ/É̼ң¬ËÑË÷ʱϣÍûÏÈËѱêÌâºóÈ«ÎÄ£¬µ±Ç°µÄÊý¾ÝÁ¿¹À¼Æ3Íò¶à£¬¶¨Î»ÆÚÍûÔÚ°ÙÍò¼¶Ò²¿ÉÓá£

Êý¾ÝÀàÐÍΪinnodb£¬µ±Ç°µÄ·½·¨ÊǶԹؼü´Ê½øÐÐ ......

MySQLÈëÃÅ

MySQLÈëÃÅ
¿ÉÒÔÏÈ¿´Ê²Ã´Êé¼®°¡£¿
ÏȶÁÈý±é¡¶Êý¾Ý¿âϵͳ¸ÅÂÛ¡·,ÕÆÎÕÊý¾Ý¿âµÄ»ù´¡ÀíÂÛ¡£
È»ºóÔÙ´Ö¿´Ò»±éMYSQLµÄ¹Ù·½Îĵµ¡£ MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc/refman/5.1/zh/index.html

¾ÍÕÒÒ»±¾ºÜ»ù´ ......

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 like ÎÊÌâ

select * from table where '123456789' like '%'+×ֶαí+'%'


Õâ¾äsqlÔÚsqlserverÏÂͨ¹ý£¬ÔÚmysqlÏÂÓб¨´í£¬mysqlÏÂÈçºÎʵÏÖÕâÑùµÄ²éÑ¯ÄØ
SQL code:
select * from table whe ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ