Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Àí½âÓÖÉîÁËЩ


Ïà¹ØÎÊ´ð£º

c,c++Á¬½Ómysql ÕÒ²»µ½Í·²¿Îļþ£¨ÐÂÊÖ£©

±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......

PHP ²åÈë´óÁ¿mysql¼Ç¼µÄÎÊÌâ

for($i=1;$i <=10000;$i++){
$sql="insert into l(name,age,info) values('Ãû×Ö$i',$i,'½éÉÜ$i')";
mysql_query($sql);
}

ÎÒÕâÑùµÄ²åÈë·½·¨..´ó¸Å²åÈë300Ìõ×óÓҾͣº ......

¹ØÓÚphp»ñÈ¡mysqlµÄÖ¸¶¨¼Ç¼

ÈçÉÏ
phpÈç¹û»ñÈ¡mysql±í¼Ç¼µÄÖ¸¶¨ÐÅϢѽ£¿
±ÈÈçÏëÒª»ñÈ¡±ítableµÄpw_num×ֶεļǼ·Ö±ðΪ0£¬11£¬8£¬3£¬9
Ôõô²ÅÄÜ»ñµÃ×Ö¶Îpw_numÀïÃæ´óÓÚ5µÄֵѽ£¿£¨11£¬8£¬9£©

Çë¸ßÊÖ°ïæ½â¾öÒ»ÏÂ
лл

Òý ......

Çë½ÌÒ»¸öjsp¼òµ¥µÄmysqlÎÊÌâ

ÊÇÒ»Ìõ¸üвÙ×÷£º
Java code:

¡­¡­
private Integer bonus = 0;
public Integer getBonus() {
return bonus;
}
public void setBonus(Integer bonus) {
this.bonus = bonus;
}
String SQL = ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ