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

·ÖÏíÒ»¸öMysql¸ßЧ±¸·Ý³ÌÐò(´úÂëÈ«¿ªÔ´)

¡°ÈÃMYSQL±¸·Ý¸ü·½±ã¡¢¸ü¸ßЧ¡±ÊÇÎÒÃÇ¿ª·¢µÛ¹ú±¸·ÝÍõµÄ×ÚÖ¼£¬¾­¹ý9¸ö°æ±¾µÄ²»¶ÏÉý¼¶ÓëÍêÉÆ£¬µÛ¹ú±¸·ÝÍõ±¸·ÝÊý¾Ý¸ü¼ÓÎȶ¨¡¢¸ßЧ¡¢·½±ã£¬ÌرðÊÇÔÚ´óÊý¾Ý±¸·Ý·½ÃæÐ§Âʸü¼ÓÍ»³ö¡£

µÛ¹ú±¸·ÝÍõ(Empirebak)¼ò½é
EmpireBakÊÇÒ»¿îÍêÈ«¿ªÔ´Ãâ·Ñ¡¢×¨ÃÅΪMYSQL´óÊý¾ÝµÄ±¸·ÝÓëµ¼Èë¶øÉè¼ÆµÄÎȶ¨¸ßЧÈí¼þ,ϵͳ²ÉÓÃ·Ö¾í±¸·ÝÓëµ¼Èë,ÀíÂÛÉϿɱ¸·ÝÈκδóСµÄÊý¾Ý¿â.

µÛ¹ú±¸·ÝÍõ½â¾öMYSQL±¸·ÝÈý´óÄÑÌ⣺
1¡¢½â¾ö±¸·Ý´óÊý¾ÝÎÊÌ⣬²ÉÓ÷Ö×鱸·Ý£¬±¸·ÝÎȶ¨¸ßЧ£»
2¡¢½â¾ö±¸·ÝÊý¾Ý±àÂëÂÒÂëÎÊÌ⣬±¸·ÝÍõÖÇÄÜʶ±ð±àÂ룻
3¡¢½â¾ö²»Í¬MYSQL°æ±¾Êý¾Ý²»ÄÜ»¥µ¼ÎÊÌ⣬ͨ¹ý±¸·ÝÍõ²»´æÔÚÊý¾Ý°æ±¾Çø±ð¡£

µÛ¹ú±¸·ÝÍõ(EmpireBak)Ö÷ÒªÌØÐÔ
1¡¢·Ö×鱸·Ý£¬×¨Îª´óÊý¾Ý±¸·ÝÉè¼Æ
ÒýÓòÉÓ÷Ö×鱸·Ý£¬ÏµÍ³×Ô¶¯½«Êý¾Ý¿â·Ö³É¶à²¿·Öµ¼³ö½øÈ룮ÀíÂÛÉϲ»ÏÞÊý¾Ý¿â´óС£¬¾ù¿É±¸·ÝÓë»Ö¸´£»
Ö§³Ö°´¡°Îļþ´óС¡±Óë¡°¼Ç¼Êý¡±Á½ÖÖ·Ö×鱸·Ý·½Ê½£¬ÌرðÊÇÕë¶Ô´óÊý¾Ý¿â¶øÉè¼ÆµÄ¡°°´¼Ç¼Êý¡±±¸·ÝËã·¨£¬Ð§Âʼ«¸ß£»
ÿ×鱸·ÝÊý¾Ý´óСºǫֱ́½ÓÉèÖã¬ÒÀ·þÎñÆ÷ÅäÖÃ×ÔÒÑÉ趨¡£

2¡¢²»Í¬MYSQL°æ±¾Æ½»¬×ª»»£¬¿ÉÖ±½Ó±¸·ÝÓë»Ö¸´
ÒýÓÃϵͳ×Ô¶¯Ê¶±ðMYSQL°æ±¾¸ñʽ£¬È»ºó½øÐÐת»»»Ö¸´£»
²»Í¬±àÂëÊý¾Ý¿âÖ®¼ä¿ÉÖ±½Ó±¸·ÝÓë»Ö¸´£¬ÏµÍ³×Ô¶¯Ê¶±ðÊý¾Ý±àÂ룻
ϵͳ֧³ÖÍêÕû±¸·Ý£¬¼´Ê¹±¸·ÝÓë»Ö¸´Á½¸öÊý¾Ý±í½á¹¹²»Ò»Ö£¬Ò²¿É±¸·ÝÓë»Ö¸´£»
Ö§³ÖÊý¾Ý±í±àÂëת»»£»
Ö§³ÖÕý³£Êý¾ÝÓëÊ®Áù½øÖÆÊý¾Ý±¸·Ý¡£

3¡¢°²È«ÐÔ
ÒýÓñ¸·ÝÎļþ¾ùÉú³É*.phpÎļþ£¬²¢ÇÒ²ÉÓõǼÑéÖ¤£¬Ö»ÓеǼµÄ¹ÜÀíÔ±²ÅÄܽøÐÐÊý¾Ý»Ö¸´£»
±¸·ÝĿ¼¡¢Ñ¹ËõĿ¼¿É×


Ïà¹ØÎÊ´ð£º

MYSQL°²×°Ê§°Ü

ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£ºError 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it. 
¿ ......

MYSQLÓëSmartyµÄÓ¦ÓÃ

ÔÚÈýÊ®½²Óöµ½ÕâÑùÒ»¸öÎÊÌâ¾ÍÊÇÔËÐдúÂëʱ³öÏÖ´íÎó Fatal error: Call to undefined method mysql::fetch_array() in D:\WWW\news\index.php on line 12
£¬ÎÒ°Ñmysql::fetch_array() ¸Ä³Émysql::fetch_row() ÓÖ³öÏÖF ......

MYSQL ÊÂÎñµÄÎÊÌâ

SQL code:

create PROCEDURE aa(SqlCMD1 varchar(8000),SqlCMD2 varchar(8000),SqlCMD3 varchar(8000))
begin
declare exit handler for sqlexception rollback;
start TRANSACTION;
EXECUTE SqlCMD1;
EXE ......

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

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

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

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

mysql ÔõÑù²ÅÄܶÔͬһÕűí²éѯºóÔÙ¸üÐÂ?

Çë¸ßÊÖÖ¸µã,ÎÒ¶ÔÒ»Õűí²éѯºóÔÙ¸üÐÂ,²éѯÊÇ×Ó²éѯ,±¨´í:
You can't specify target table 'a_table' for update in from clause
ÍêÕûSQLÓï¾äÊÇ
UPDATE a_table SET STATUS=0 WHERE ID=(SELECT MIN(ID) from a_tab ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ