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

MYSQL Çó¸ßÊÖ°ïÖú

¸÷λ¸ßÊֺá£Ð¡µÜѧϰJAVA²»¾Ã£¬È»ºóÔÙÓÃMYSQLÊý¾Ý¿â¡£
ÓÉÓÚÊÇÓñðÈ˵ĵķ¶Àýѧϰ£¬ËùÒÔ³öÏÖºÜ¶àÆæ¹ÖµÄÎÊÌâ
ÎÒÓÃ×Ô¼ºµÄMYSQL ·þÎñÆ÷£¬È»ºó°Ñ±ðÈ˵ÄÊý¾Ý¿âµ¼½øÀ´¡£È»ºó³öÏÖ°æ±¾ÎÊÌâ¡£
ÎÊÌâÈçÏÂ
Table './db_librarysys/tb_manager' was created with a different version of MySQL and cannot be read
2010-4-28 22:44:00 org.apache.struts.action.RequestProcessor processException
¾¯¸æ: Unhandled Exception thrown: class java.lang.NullPointerException
2010-4-28 22:44:00 org.apache.catalina.core.StandardWrapperValve invoke
ÑÏÖØ: Servlet.service() for servlet action threw exception
java.lang.NullPointerException
 at com.dao.ManagerDAO.checkManager(ManagerDAO.java:75)
 at com.action.Manager.managerLogin(Manager.java:51)
 at com.action.Manager.execute(Manager.java:24)
 at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
 at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
 at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
 at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAd


Ïà¹ØÎĵµ£º

ÁªºÏMySQL Proxy ºÍMySQL Cluster£¬¹¹½¨¸ßÐÔÄÜÊý¾Ý¿â


ÁªºÏMySQL Proxy ºÍMySQL Cluster£¬¹¹½¨¸ßÐÔÄÜÊý¾Ý¿â
Ô­ÎÄ£ºhttp://blogs.mysql.com/kaj/2007/12/10/combining-mysql-proxy-with-mysql-cluster/
       ²»¾Ãǰ£¬ÎÒºÍStewart Smith, Vinay Joosery, Monty Taylor ÒÔ¼°ÆäËûµÄmysqlʹÓÃÕߣ¨ËûÃDZÈÎÒ¸üÊìϤMySQL Cluster £©Õ¹¿ªÁËÒ»´ÎÌÖÂÛ£ ......

¹ØÓÚMySQLµÄLIMIT Ó﷨СÓÅ»¯£¡

   
½ñÌìÓÐÅóÓÑÎÊÆð´ËÀàÓï¾äµÄÓÅ»¯£¬ÎÒ´óÖ¸øËû½éÉÜÁËÏ´ÓSQL½Ç¶È×ö¼òµ¥µÄÓÅ»¯£¬ÖÁÓÚÓ¦ÓóÌÐò·½ÃæµÄ¿¼ÂÇÔÛÔÝʱ²»¿¼ÂÇ¡£
ÏÂÃæÎÒÀ´¾ÙÒ»¸ö
¼òµ¥µÄÀý×Ó¡£
¿¼ÂÇÈçÏÂ
±í½á¹¹£º
/*DDL Information
For - t_girl.t_page_sample*/
----------------------------------------------
Table   ......

ÓÃMySQL´´½¨Êý¾Ý¿âºÍÊý¾Ý¿â±í

1¡¢Ê¹ÓÃSHOWÓï¾äÕÒ³öÔÚ·þÎñÆ÷Éϵ±Ç°´æÔÚʲôÊý¾Ý¿â£º
 
de>de>mysql> SHOW DATABASES; +----------+ | Database | +----------+ | mysql | | test | +----------+ 3 rows in set (0.00 sec)
    2¡¢´´½¨Ò»¸öÊý¾Ý¿âabccs
     mysql> CREATE DATABASE abccs; ......

.netÁ´½ÓmysqlÊý¾Ý¿â£¬²Ù×÷Ôöɾ¸Ä²é¡£

ÁíÍâMySql¹Ù·½³öÁËÒ»¸öÔÚcsharpÀïÃæÁ¬½ÓMySqlµÄConnector£¬¿ÉÒÔÊÔÊÔ
http://dev.mysql.com/downloads/#connector-net
<add name="mysql" connectionString="server=125.46.37.170;uid=root;pwd=;"/>
±¨´í£ºUnable to connect to any of the specified MySQL hosts.
½ñÌì×öÏîĿʱºò¾ÍÓöµ½ÕâÎÊ ......

mysql¼¶ÁªÉ¾³ý Mysql µÄ Cascade Restrict

½ñÌìÓöµ½Êý¾Ý¿âµÄÒ»¸öÎÊÌ⣬¾ÍÊÇÿµ±´ÓÖ÷±íÖÐɾ³ýÒ»¸öÖ÷¼üidʱ£¬ÓÉÓÚÓëËûÏà¹ØÁªµÄ±íÖÐÓÐÏà¹ØµÄ×Ö¶ÎÊý¾Ý£¬ËùÒÔÎÞ·¨É¾³ý¡£²éÁËÒ»´ó¶Ñ×ÊÁÏ£¬·¢ÏÖÎÒ½¨±í¹ØÁªÓõÄÊÇon Restrict.¿ÉÄÜÎÊÌâ¾Í³öÔÚÕâÀï°É¡£ 
Íâ¼üÔ¼Êø¶Ô×Ó±íµÄº¬Òå: 
  Èç¹ûÔÚ¸¸±íÖÐÕÒ²»µ½ºòÑ¡¼ü,Ôò²»ÔÊÐíÔÚ×Ó±íÉϽøÐÐinsert/update 
Íâ¼üÔ¼Êø ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ