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Êý¾Ý¿âÖС£
Ïà¹ØÎÊ´ð£º
´úÂëÈçÏ£º $sql = "select count(*) from admin"; $result = mysql_query($sql); $num=mysql_num_rows($result); echo $num; Ϊʲô²»¹ÜÎҵļǼÓжàÉÙÌõ£¬¶¼ÊÇÊä³ö1£¬ ÎÒÏëÊä³ö²éѯµÄ ......
ÏÖÔÚÓÐÒ»¸öÍøÕ¾£¬ÏëÔÚÁíÍâһ̨·þÎñÆ÷ÉÏ×öÒ»¸öÕâ¸öÍøÕ¾µÄ¾µÏñ¡£ ÔÚÖ÷ÍøÕ¾ÉϵÄÊý¾Ý¸üÐÂҪͬ²½µ½¾µÏñ·þÎñÆ÷ÉÏ Í¬Ê±Óû§·ÃÎʾµÏñ·þÎñÆ÷ʱµÄÊý¾Ý¸üÐÂҲҪͬ²½µ½Ö÷ÍøÕ¾ÉÏ ÆäÖÐÊý¾Ý¸üРÖ÷Òª°üÀ¨ MysqlÊý¾Ý¿âµ ......
ÎÒ°²×°ºÃmysqlºó,ĬÈϵÄÊý¾Ý¿â·¾¶ÊÇÔÚCÅÌÏÂ,ÎÒÏë°ÑËü¸Äµ½EÅÌÀï: ÎÒÏȰÑmysql·þÎñÍ£Ö¹,ÔÙÔÚmysql°²×°Ä¿Â¼(Ò²ÊÇÔÚEÅÌ)ÏÂÕÒµ½my.iniÎļþ,¾Í¸ÄÁËÏÂÃæÄÇô¶à: #Path to the database root datadir="E ......
if(mysql_init(&mysql)==NULL) { sprintf(ErrMsg,"We are outof Memory"); return(false); } if(!mysql_real_connect(&mysql,"localhost","test" ......
ÎÒÓÃÒ»¸öÑ»·ÍùÊý¾Ý¿âÀïÃæ´æÎļþ£¬±¾À´¿ÉÒÔ×÷ΪÎļþ´æ·ÅÊý¾Ý¿âÀïÃæÖ»·ÅÎļþµÄλÖõ쬵«ÊÇûÓа취×âµÄ·þÎñÆ÷ÍøÒ³¿Õ¼ä´óСÓÐÏÞÖÆÊý¾Ý¿âûÓÐÏÞÖÆ¡£Óï¾äÊÇÕâÑùµÄ public static final DataBase.MAXSIZE=102 ......