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

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 ʹÓÃÎÊÌâ - Java / Web ¿ª·¢

ÎÒµÄMysql ʹÓõÄʱºò ÓÃdos½¨Á¢µÄÊý¾Ý±í ÔÚdosÖÐÄÜÏÔʾ³öÖÐÎÄ 
µ«ÊÇÔÚ ÆäËûµÄ¿ÉÊÓÒ³Ãæ ºÍÍøÒ³Öж¼ÏÔʾÂÒÂë ÈçºÎ½â¾ö£¿
ÔÚmysql¿ØÖÆÌ¨:show variables like 'char%';Ìù½á¹û³öÀ´¿´¿´¡£

mysqlÃüÁîÐÐģʽÏÂ: ......

ÓйØmysqlµÄÎÊÌ⣡ - Java / Web ¿ª·¢

ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ

ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£

ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......

mysql×Ö¶ÎÌáÈ¡ - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

¸÷λÐÖµÜÇë½Ì Ï£¬ÔÚmysqlÖÐÄܲ»ÄÜʵÏÖÕâÑùÒ»¸ö¹¦ÄÜ£¬
Ò»¸ö×Ö¶ÎAÊÇ´¢´æÒ»´ó¶ÎÎÄ×ÖÄÚÈݵģ¬ÊÇÓ¢ÎÄ£¬Äܲ»ÄÜͨ¹ýMYSQLµÄ²éѯ֮ÀàµÄ¹¦ÄÜ£¬À´»ñµÃÕâ¸ö×Ö¶ÎÖÐ ³öÏÖÆµÂÊ×î¸ßµÄÊ®¸öµ¥´Ê£¬²¢½«ÕâÊ®¸öµ¥´Ê×öΪеÄ×ֶδ¢´æ
a ......

sqlÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

ÔõôÑù²éѯÁ¬½Ó2¸ö±íÖ®ºó µÃ³öµÄбí
ÀýÈç A±í£º·¢¼þÈËID Óʼþ±àºÅ ÓʼþÄÚÈÝ ÊÕ¼þÈËID ·¢¼þʱ¼ä
  B±í£ºÊÕ¼þÈËID Óʼþ±àºÅ ÊÕ¼þʱ¼ä
  Ê×ÏÈ×öA BµÄÁ¬½Ó²éѯ ¼´ Óʼþ±àºÅÏàµÈ
  ²é³ö£ ......

PHP+MYSQLÊý¾Ý¼¯´¦Àí - PHP / »ù´¡±à³Ì

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)ÖеÄÊý¾ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ