MySQLµ¼³öÏà¹Ø - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql
ÎÒµÄMySQLÊý¾Ý¿âÖÐÓÐ±í£¬Óд洢¹ý³Ì£¬ÓÃsqlyogµ¼³öµÄʱºò£¬·¢ÏÖ½öÄܵ¼³ö±í½á¹¹
ÔõÑù²ÅÄܰѱí½á¹¹ºÍ´æ´¢¹ý³ÌÒ»²¢µ¼³ö£¿ÇÒÄÜÎ޷컹ԣ¨Ã²ËÆÓÐʱºòÎÒÄܵ¼³öÁ½¸öÁË£¬µ«ÊÇ»¹ÔµÄʱºò£¬MySQLÓÖ±§Ô¹´æ´¢
¹ý³ÌÖÐÓÐÓï·¨´íÎ󣬲»¿Ïµ¼È룩
mysqldump²»Í¦ºÃÓõÄÂð£¿
SQLYOGµ¼³öʱ»áÓÐÑ¡Ôñ£¬½á¹¹¡¢Êý¾Ý¡¢½á¹¹ÓëÊý¾Ý£¬Äã¼ì²éÒ»ÏÂÉèÖÃ
½¨ÒéÖ±½ÓʹÓà mysqldump ±ê×¼¹¤¾ß¡£ µÚÈý·½¹¤¾ßÓÐʱ²¢²»¿É¿¿¡£
mysqldump µÄ¾ßÌå²Ù×÷Äã¿ÉÒԲο¼¹Ù·½ÊÖ²áÖеÄ˵Ã÷ºÍÀý×Ó¡£
MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc/refman/5.1/zh/index.html
ÓÃmysqldump¹¤¾ß,¼Ó²ÎÊý -R ¼´¿Éµ¼³ö´æ´¢¹ý³Ì
Ïà¹ØÎÊ´ð£º
ÎÒµÄMysql ʹÓõÄʱºò ÓÃdos½¨Á¢µÄÊý¾Ý±í ÔÚdosÖÐÄÜÏÔʾ³öÖÐÎÄ
µ«ÊÇÔÚ ÆäËûµÄ¿ÉÊÓÒ³Ãæ ºÍÍøÒ³Öж¼ÏÔʾÂÒÂë ÈçºÎ½â¾ö£¿
ÔÚmysql¿ØÖÆÌ¨:show variables like 'char%';Ìù½á¹û³öÀ´¿´¿´¡£
mysqlÃüÁîÐÐģʽÏÂ: ......
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ
ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£
ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......
¸÷λÐÖµÜÇë½Ì Ï£¬ÔÚmysqlÖÐÄܲ»ÄÜʵÏÖÕâÑùÒ»¸ö¹¦ÄÜ£¬
Ò»¸ö×Ö¶ÎAÊÇ´¢´æÒ»´ó¶ÎÎÄ×ÖÄÚÈݵģ¬ÊÇÓ¢ÎÄ£¬Äܲ»ÄÜͨ¹ýMYSQLµÄ²éѯ֮ÀàµÄ¹¦ÄÜ£¬À´»ñµÃÕâ¸ö×Ö¶ÎÖÐ ³öÏÖÆµÂÊ×î¸ßµÄÊ®¸öµ¥´Ê£¬²¢½«ÕâÊ®¸öµ¥´Ê×öΪеÄ×ֶδ¢´æ
a ......
ÔõôÑù²éѯÁ¬½Ó2¸ö±íÖ®ºó µÃ³öµÄбí
ÀýÈç A±í£º·¢¼þÈËID Óʼþ±àºÅ ÓʼþÄÚÈÝ ÊÕ¼þÈËID ·¢¼þʱ¼ä
B±í£ºÊÕ¼þÈËID Óʼþ±àºÅ ÊÕ¼þʱ¼ä
Ê×ÏÈ×öA BµÄÁ¬½Ó²éѯ ¼´ Óʼþ±àºÅÏàµÈ
²é³ö£ ......
1¡¢ÊDz»ÊÇPHPÖÐÖ»ÄÜʹÓÃmysql_query("update user_aa set money=money2-".$bpanmm." where uid=".$userppp);¸üÐÂÊý¾Ý£¿£¿£¿
2¡¢PHP¸üÐÂmysql_fetch_row($res)Óëmysql_fetch_array($res)ÖеÄÊý¾ ......