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

mysql±¸·ÝÎÊÌâ¡£¼±£¡£¡£¡£¡£¡

¸ßÊÖ£¬ÏÖÔÚÓöµ½Ò»¸ömysql±¸·ÝµÄÎÊÌâ¡£

ÎÒµÄÊý¾Ý¿âÀïÓÐһЩÓÃcreate function½¨Á¢µÄ×Ô¶¨Ò庯Êý¡£µ±ÎÒÓÃmysqldump±¸·Ý¸ÃÊý¾Ý¿âÈ»ºóµ¼Èëµ½ÁíÍâÒ»¸ö·þÎñÆ÷BÉÏ£¬·¢ÏÖ·þÎñÆ÷BÉÏÖ»ÓÐÊý¾Ý£¬¶øÃ»ÓÐÄÇЩ×Ô¶¨ÒåµÄº¯Êý¡£ÎҸоõmysqldumpÖ»±¸·ÝÊý¾ÝºÍ±í£¬²¢²»±¸·Ý×Ô¶¨Ò庯Êý¡£

ÓÐûÓÐʲômysqlÃüÁî¿ÉÒÔÒ»Æð±¸·ÝÁ˰¢¡£²»Òª¸æËßÎÒÓÃʲô¹¤¾ß£¬ÎÒÏÖÔڵķþÎñÆ÷ÉÏʲô¹¤¾ß¶¼²»Äܰ²×°£¬Ö»ÄÜÓÃÖ´ÐÐmysql×Ô¼ºµÄ±¸·ÝÃüÁî¡£

лл£¡
¼Ó-R²ÎÊý¾ÍÓÐ


-R, --routines      Dump stored routines (functions and procedures).
-E, --events        Dump events.

ÒýÓüÓ-R²ÎÊý¾ÍÓÐ


ÒòΪ´æ´¢¹ý³Ì²¢Ã»ÓдæÔÚÊý¾Ý¿âµÄĿ¼ÖУ¬¶øÔÚ´æÔÚmysqlÊý¾Ý¿âÖС£


Ïà¹ØÎÊ´ð£º

Mysql²éѯÎÊÌâ¡£¡£¡£

  ÎÒÏëÔÚmysqlÖн«t_flow_card_detail±íÖеÄclient_id×ֶθÄΪÍâ¼ü£¬ÒýÓÃt_client±íÖеÄclient_id×ֶΣº
  ÎÒµÄsqlÓï¾äÊÇ£º alter table t_flow_card_detail add constraint FK_flowcard_client foreig ......

¹ØÓÚMySQLµÄ²éѯ½á¹û

´úÂëÈçÏ£º
$sql = "select count(*) from admin";
$result = mysql_query($sql);
$num=mysql_num_rows($result);
echo $num;
Ϊʲô²»¹ÜÎҵļǼÓжàÉÙÌõ£¬¶¼ÊÇÊä³ö1£¬
ÎÒÏëÊä³ö²éѯµÄ ......

Çó¾ÈMySqlÄ£ºý²éѯÎÊÌâ

Java code:

Ä£ºý²éѯÊé°´ÕÕÊéÃû-------------------
java.sql.SQLException: Illegal mix of collations (gb2312_chinese_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'
at com.mys ......

Á½Ì¨Mysql·þÎñÆ÷£¬Êý¾Ýͬ²½

ÏÖÔÚÓÐÒ»¸öÍøÕ¾£¬ÏëÔÚÁíÍâһ̨·þÎñÆ÷ÉÏ×öÒ»¸öÕâ¸öÍøÕ¾µÄ¾µÏñ¡£
ÔÚÖ÷ÍøÕ¾ÉϵÄÊý¾Ý¸üÐÂҪͬ²½µ½¾µÏñ·þÎñÆ÷ÉÏ
ͬʱÓû§·ÃÎʾµÏñ·þÎñÆ÷ʱµÄÊý¾Ý¸üÐÂҲҪͬ²½µ½Ö÷ÍøÕ¾ÉÏ

ÆäÖÐÊý¾Ý¸üРÖ÷Òª°üÀ¨ MysqlÊý¾Ý¿âµ ......

Mysql Êý¾Ý¿âɾ³ý²»ÁËÔõô°ì

ÎÒ֮ǰµ¼ÈëµÄÊý¾Ý¿â£¬ÏÖÔÚɾ³ý²»ÁË£¬ÓÃÁËÃüÁîÐк͹¤¾ß¶¼²»ÐУ¬ÖØÆôÒ²²»ÐУ¬ÕâÊÇÎªÊ²Ã´ÄØ£¿
ÄãÊÇÈçºÎɾ³ýµÄ£¿
ÓÐʲôÌáʾ£¿


ÎÊÌâ˵Ã÷Ô½Ïêϸ£¬»Ø´ðÒ²»áԽ׼ȷ£¡²Î¼ûÈçºÎÌáÎÊ¡££¨ÌáÎʵÄÖǻۣ©

......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ