ÕÒ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Àí½âÓÖÉîÁËЩ
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
Èç¹ûmysqlÔÚ¹¤×÷µÄʱºò³öÏÖÒì³££¬µ¼ÖÂphp³ÌÐòûÓзµ»ØÖµ£¬php»áÈçºÎ´¦Àí£¿ »¹ÊÇÒªÊÖ¶¯Ð´ÈÝ´í´¦Àí
ÅжÏmysqlº¯ÊýµÄ·µ»ØÖµ php×Ô¼ºµ±È»²»»áÈÝ´íÁË ÄãÐèÒª×Ô¼ºÐ´
µ±È»ÒªÊÖ¶¯À´Ð´
×Ô¼ºÐ´°¡
ÄǾÍÒª¶ÔÄã ......
ÈçÉÏ
phpÈç¹û»ñÈ¡mysql±í¼Ç¼µÄÖ¸¶¨ÐÅϢѽ£¿
±ÈÈçÏëÒª»ñÈ¡±ítableµÄpw_num×ֶεļǼ·Ö±ðΪ0£¬11£¬8£¬3£¬9
Ôõô²ÅÄÜ»ñµÃ×Ö¶Îpw_numÀïÃæ´óÓÚ5µÄֵѽ£¿£¨11£¬8£¬9£©
Çë¸ßÊÖ°ïæ½â¾öÒ»ÏÂ
лл
Òý ......
ÏÖÓÐÈçÏÂÒ»´æ´¢¹ý³Ì£º
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 ......
ÊÇÒ»Ìõ¸üвÙ×÷£º
Java code:
¡¡
private Integer bonus = 0;
public Integer getBonus() {
return bonus;
}
public void setBonus(Integer bonus) {
this.bonus = bonus;
}
String SQL = ......