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

ÕÒmysql·þÎñͻȻµ±µôÔ­Òò

linuxÉϵÄmysql·þÎñÔÚ½Ú¼ÙÈÕͻȻµ±µô
ÏÖÔÚÕÒÔ­Òò£¬»³ÒÉÊÇ´ÅÅ̿ռ䲻¹»£¬ÏÖÔÚÐèÒªÕÒµ½È·ÔäµÄÖ¤¾Ý¡£
£±¡¡¾ßÌåÔÚÄĸöÎļþÏ¿ÉÒÔÕÒµ½£¬Ëûµ±µôµÄ¾ßÌåʱ¼äºÍÔ­Òò£¿
£²¡¡windowsÏÂcÅÌ¿ÉÒÔ±¨´ÅÅ̿ռ䲻¹»µÄÔ­Òò£¬²»ÖªµÀlinuxûÓÐÀàËÆwindowsµÄcÅÌ£¨¾ßÌåÊÇÄĸöĿ¼£©¿Õ¼ä²»×㣿
dataĿ¼ÏµÄerrÈÕÖ¾

linux ÏÂûÓÐÕÒµ½errÈÕÖ¾

ûÓÐERRÈÕÖ¾£¬ÔòÔÚMYSQLÕâ¸ö²ã´ÎÉÏûʲô°ì·¨ÁË¡£

½¨ÒéÂ¥Ö÷µ½ LINUX  °æÈ¥ÎÊһϣ¬²Ù×÷ϵͳ²ãÉÏÓÐʲô¼Ç¼¿ÉÒԲ쿴¡£

ÕÒµ½ err
090626 20:26:58 [ERROR] Failed to open the relay log '/var/run/mysqld/mysqld-relay-bin.000010' (relay_log_pos 318)
090626 20:26:58 [ERROR] Could not find target log during relay log initialization
090626 20:26:58 [ERROR]

¿´ÏÂlinuxµÄ´íÎóÈÕÖ¾ÊÇ·ñÓз¢ÏÖ°É:

tail -f /var/log/messages

¸Ðл´ó¼Ò mysqlÀí½âÓÖÉîÁËЩ


Ïà¹ØÎÊ´ð£º

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

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

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

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

mysql php ÎÊÌâ

  Èç¹ûmysqlÔÚ¹¤×÷µÄʱºò³öÏÖÒì³££¬µ¼ÖÂphp³ÌÐòûÓзµ»ØÖµ£¬php»áÈçºÎ´¦Àí£¿ »¹ÊÇÒªÊÖ¶¯Ð´ÈÝ´í´¦Àí
ÅжÏmysqlº¯ÊýµÄ·µ»ØÖµ php×Ô¼ºµ±È»²»»áÈÝ´íÁË ÄãÐèÒª×Ô¼ºÐ´

µ±È»ÒªÊÖ¶¯À´Ð´

×Ô¼ºÐ´°¡

ÄǾÍÒª¶ÔÄã ......

Çë½ÌÒ»PHP¶ÔMySQLµÄ²Ù×÷

ÏÖÓÐÈçÏÂÒ»´æ´¢¹ý³Ì£º

SQL code:

CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_Test`(
in $W_id int
)
BEGIN
DECLARE $type int DEFAULT 0;
DECLARE $preID int;
DECLARE $nextID int;
DECLA ......

jspÁ¬½ÓmysqlÊý¾Ý¿â²éѯ£¬²¢ÔÚÒ³ÃæÏÔʾ

jspÁ¬½ÓmysqlÊý¾Ý¿â²éѯ£¬²¢ÔÚÒ³ÃæÏÔʾ Öм䲻ÓÃstruts£¬ÔõôʵÏÖ£¬ÇóÀý×Ó

javabean ×öÁ¬½Ó
jsp Ò³ÃæÊµÀý»¯Àà
jsp Ò³ÃæÏÔʾÊý¾Ý
<%@ page contentType="text/html;
charset=gb2312" ......

ÈçºÎÓÃjspʵÏÖmysqlÊý¾Ý¿â±àÂ룿

ÔÚphpÖÐÓÃÕâ¾ä¾Í¿ÉʵÏÖ¶Ô¿Í»§¶Ë×Ö·û¼¯µÄÉèÖÃ....

mysql_query("set names gb2312")

ÇëÎÊÔÚjspÖÐÈçºÎʵÏÖÕâ¾ä¹¦ÄÜ£¿£¿£¿
jspÖУº
<%@page language="java" contentType=&q ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ