Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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µÄ²éѯ½á¹û

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

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

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

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

´óÏÀÃǾÈÃü°¡:MysqlµÄmy.iniÎļþ¸ü¸ÄÊý¾Ý¿â·¾¶ÎÊÌâ

  ÎÒ°²×°ºÃmysqlºó,ĬÈϵÄÊý¾Ý¿â·¾¶ÊÇÔÚCÅÌÏÂ,ÎÒÏë°ÑËü¸Äµ½EÅÌÀï: ÎÒÏȰÑmysql·þÎñÍ£Ö¹,ÔÙÔÚmysql°²×°Ä¿Â¼(Ò²ÊÇÔÚEÅÌ)ÏÂÕÒµ½my.iniÎļþ,¾Í¸ÄÁËÏÂÃæÄÇô¶à:
#Path to the database root
datadir="E ......

CÓïÑÔ Mysql ÒÉÎÊ

if(mysql_init(&mysql)==NULL)
{
sprintf(ErrMsg,"We are outof Memory");
return(false);
}

if(!mysql_real_connect(&mysql,"localhost","test" ......

MySQLÊý¾Ý°ü¹ý´ó

ÎÒÓÃÒ»¸öÑ­»·ÍùÊý¾Ý¿âÀïÃæ´æÎļþ£¬±¾À´¿ÉÒÔ×÷ΪÎļþ´æ·ÅÊý¾Ý¿âÀïÃæÖ»·ÅÎļþµÄλÖõ쬵«ÊÇûÓа취×âµÄ·þÎñÆ÷ÍøÒ³¿Õ¼ä´óСÓÐÏÞÖÆÊý¾Ý¿âûÓÐÏÞÖÆ¡£Óï¾äÊÇÕâÑùµÄ


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