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

mysqlÎÞ·¨Æô¶¯

ÓôÃÆ£¡CSDNµÄ²©¿Í±à¼­Æ÷ÓÒ±ßÔõôûÓÐÏÔʾ³öÀ´Íê°¡£¬¸ã¸öʲô“ÈçºÎʹÓÿͻ§¶Ëд²©¿Í”£¬º¦ÎÒÊäÈëµÄ×Ö¶¼±»ÄǸöÌáʾµ²×¡ÁË£¡
תÈëÕýÌ⣺
½ñÌìÒ»´óÔçÆðÀ´£¬´ò¿ªeclipseÆô¶¯tomcat£¬×òÍí»¹Õý³£ÔËÐеÄÒ»¸öÏîĿȴ±¨´í£¬¸øÎÒµÄÐÄÇéÕæÊÇÒ»¸ö´ò»÷ѽ~~ÐÂÄêµÚÒ»Ìì¾Í²»Ì«Ë³Àû£¡
¾­¹ý¼ì²é²ÅÖªµÀʹÓõÄÊý¾Ý¿âmysqlûÓÐÆô¶¯£¬Í¨¹ýWINXPµÄϵͳ·þÎñÀ´Æô¶¯mysql¸øÎÒÌø³öÒ»¸ö´íÎóÀ´£¬“´íÎó 1067: ½ø³ÌÒâÍâÖÕÖ¹”
¾­¹ýÍøÉÏËÑË÷£¬²ÅÖªµÀÊÇûÓÐmy.iniÕâ¸öÅäÖÃÎļþ£¬Ò²ÕÒµ½ÁËһЩ½â¾öÕâ¸öÎÊÌâµÄ°ì·¨£¬±ÈÈçн¨Ò»¸ömy.iniÎļþ£¬ÊäÈëһЩÅäÖÃÐÅÏ¢µÈ
ÕâÑù´¦Àí¹ýºóµ¹ÊÇ¿ÉÒÔÕý³£Æô¶¯mysql£¬²»¹ýÔÚÔËÐÐÏîÄ¿µÄʱºò£¬ÎÒ»¹ÊÇÓöµ½Á˲»¿ÉÖªµÄÊý¾Ý¿âÒì³£
×îºóÕÒµ½ÁËÒ»¸ö×î¼òµ¥°²È«²¢ÓÐЧµÄ·½·¨£º
ÔËÐÐmysql°²×°Ä¿Â¼ÏµÄbinĿ¼ÏµÄMySQLInstanceConfig.exeÖ´ÐÐÎļþ£¬Í¨¹ýËü¿ÉÒÔ´ÓÐÂÅäÖÃÒ»¸ömysqlʵÀý
һ·nextÏÂÈ¥£¬¾ÍÍòÊ´ó¼ªÁË£¬mysql³É¹¦Æô¶¯£¬ÏîĿҲÕý³£ÔËÐУ¡
ÁíÍ⣬ΪʲôÍùÌ컹Õý³£Æô¶¯µÄmysql½ñÌìÎÞ·¨Æô¶¯£¬ÅäÖÃÎļþΪºÎ»á¶ªÊ§£¬ÎÒ»¹²»ÖªµÀÔ­Òò£¬Ï£ÍûÓÐÖªµÀµÄÅóÓѸøÎÒ½âÊÍÒ»ÏÂ


Ïà¹ØÎĵµ£º

mysql 5.1ʼþµ÷¶ÈÆ÷²âÊÔ

Î塢ʼþµ÷¶ÈÆ÷²âÊÔ
5.1¡¢²âÊÔÄ¿µÄ
5.1.1  ÅäÖ÷½·¨
5.1.2  ÊÇ·ñÕý³£¹¤×÷
5.1.3  ÈÕ³£µÄά»¤
5.2¡¢Ê¼þµ÷¶ÈÆ÷½éÉÜ
×ÔMySQL5.1.6Æð£¬Ôö¼ÓÁËÒ»¸ö·Ç³£ÓÐÌØÉ«µÄ¹¦ÄÜ
–ʼþµ÷¶ÈÆ÷(Event Scheduler)£¬¿ÉÒÔÓÃ×ö¶¨Ê±Ö´ÐÐÄ³Ð©ÌØ¶¨ÈÎÎñ£¨ÀýÈ磺ɾ³ý
¼Ç¼¡¢¶ÔÊý¾Ý
½øÐлã×ܵȵȣ©£¬À´È¡´ ......

Mysql ÊÂÎñ´¦Àí

¡¡¡¡ÊÂÎñÊÇDBMSµÃÖ´Ðе¥Î»¡£ËüÓÉÓÐÏÞµÃÊý¾Ý¿â²Ù×÷ÐòÁÐ×é³ÉµÃ¡£µ«²»ÊÇÈÎÒâµÃÊý¾Ý¿â²Ù×÷ÐòÁж¼ÄܳÉΪÊÂÎñ¡£Ò»°ãÀ´Ëµ£¬ÊÂÎñÊDZØÐëÂú×ã4¸öÌõ¼þ£º£¨ACID£©
¡¡¡¡Ô­×ÓÐÔ£¨Autmic£©£ºÊÂÎñÔÚÖ´ÐÐÐÔ£¬Òª×öµ½“Ҫô²»×ö£¬ÒªÃ´È«×ö£¡”£¬¾ÍÊÇ˵²»ÔÊÐíÊÂÎñ²¿·ÖµÃÖ´ÐС£¼´Ê¹ÒòΪ¹ÊÕ϶øÊ¹ÊÂÎñ²»ÄÜÍê³É£¬ÔÚrollbackʱҲҪÏû³ý¶ÔÊ ......

ʹÓÃmysqlµÄreplaceº¯ÊýÌæ»»×Ö·û´®

×î½üÔÚÑо¿CMS£¬ÔÚÊý¾Ýת»»µÄʱºòÐèÒªÓõ½mysqlµÄreplaceº¯Êý£¬ÕâÀï¼òµ¥½éÉÜһϣ¡
±ÈÈçÄãÒª½« ±í tb1ÀïÃæµÄ f1×ֶεÄabcÌæ»»Îªdef
UPDATE tb1 SET f1=REPLACE(f1, 'abc', 'def');
REPLACE(str,from_str,to_str)   
ÔÚ×Ö·û´®   str   ÖÐËùÓгöÏÖµÄ×Ö·û´®   from_str&nbs ......

[MySQL 5.1 ÌåÑé]MySQL ʼþµ÷¶ÈÆ÷(Event Scheduler)

http://hi.baidu.com/tianxia_1209/blog/item/a2613822fec7e7f6d6cae267.html
MYSQLµÄʼþÊÇ5.1ÐÂÔö¼ÓµÄ£¬Èç¹ûÏëÌåÑ飬½¨ÒéÉý¼¶°æ±¾¡£
ÖÁÓÚÓï·¨ÎҾͲ»¶à˵ÁË£¬ÊÖ²áÉϽ²µÄºÜÏêϸ£¬ÎÒÀ´ËµËµ¼¸¸öÒªµãÒÔ¼°Ò»Ð©ÊµÀý¡£
×¢ÒâÊÂÏ
1¡¢EVENTȨÏÞÊÇÕë¶ÔģʽµÄ£¨ÔÚMYSQLÖÐÒ²¾ÍÊÇ¿âµÄ¼¶±ð£©£¬²»ÄܶԵ¥¶À±íÀ´¸³ÓèȨÏÞ¡£
2¡¢±ØÐëÔÚ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ