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

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

http://hi.baidu.com/tianxia_1209/blog/item/a2613822fec7e7f6d6cae267.html
MYSQLµÄʼþÊÇ5.1ÐÂÔö¼ÓµÄ£¬Èç¹ûÏëÌåÑ飬½¨ÒéÉý¼¶°æ±¾¡£
ÖÁÓÚÓï·¨ÎҾͲ»¶à˵ÁË£¬ÊÖ²áÉϽ²µÄºÜÏêϸ£¬ÎÒÀ´ËµËµ¼¸¸öÒªµãÒÔ¼°Ò»Ð©ÊµÀý¡£
×¢ÒâÊÂÏ
1¡¢EVENTȨÏÞÊÇÕë¶ÔģʽµÄ£¨ÔÚMYSQLÖÐÒ²¾ÍÊÇ¿âµÄ¼¶±ð£©£¬²»ÄܶԵ¥¶À±íÀ´¸³ÓèȨÏÞ¡£
2¡¢±ØÐëÔÚÈ«¾Ö¿ªÆô¡£
3¡¢ÐÔÄÜÉϵÄËðʧһ¶¨µÃ¿¼Âǵ½¡£
mysql> show variables like '%event%';
+-----------------+-------+
| Variable_name   | Value |
+-----------------+-------+
| event_scheduler | OFF   |
+-----------------+-------+
1 row in set (0.00 sec)
mysql> set global event_scheduler = on;
Query OK, 0 rows affected (0.00 sec)
mysql> use event;
Database changed
Àý×Ó£º
ÎÒÃÇÀ´´´½¨Ò»¸ö¼òµ¥µÄÎÄÕÂ±í£º
mysql> create table article (id serial,title varchar(64) not null, author_name varchar(64),content mediumtext not null, create_time datetime not null,update_time datetime not null);
Query OK, 0 rows affected (0.01 sec)
ÒÔ¼°Í³¼Æ±í£º
mysql> create table report (id int not null auto_increment primary key, r_date date not null,aid int not null,total int not null);
Query OK, 0 rows affected (0.01 sec)
mysql> ²åÈë²âÊÔÊý¾Ý¡£¡£¡£
ÎÒÃÇÀ´½¨Á¢Ò»¸ö´æ´¢¹ý³Ì¡£
mysql> delimiter ||
mysql> create procedure sp_report()
     -> begin
     -> insert into report(r_date,aid,total) select date(update_time) as r_date, id,count(1) from article group by date(create_time) order by r_date asc;
     -> end||
Query OK, 0 rows affected (0.00 sec)
mysql> delimiter ;
´´½¨EVENT;
ÔÚÒ»·ÖÖÓºóÖ´ÐÐÕâ¸ö´æ´¢¹ý³Ì¡£
mysql> create event report_dawn on schedule at date_add(now(),interval 1 minute) on completion preserve do call sp_report();
Query OK, 0 rows affected (0.00 sec)
mysql> show processlist;
| 7 | event_scheduler | localhost         | NULL   | Daemon |     5 | Waiting for next activation | NULL 


Ïà¹ØÎĵµ£º

MySQLѧϰ±Ê¼Ç£ºInnoDBºÍMyISAMµÄ²î±ð


InnoDB
ºÍMyISAM
ÊÇÔÚʹÓÃMySQL
×î³£ÓõÄÁ½¸ö±íÀàÐÍ£¬¸÷ÓÐÓÅȱµã£¬ÊÓ¾ßÌåÓ¦Óöø¶¨¡£»ù±¾µÄ²î±ðΪ£ºMyISAM
ÀàÐͲ»Ö§³ÖÊÂÎñ´¦ÀíµÈ¸ß¼¶´¦Àí£¬¶øInnoDB
ÀàÐÍÖ§³Ö¡£MyISAM
ÀàÐ͵ıíÇ¿µ÷µÄÊÇÐÔÄÜ£¬ÆäÖ´ÐÐÊý¶È±ÈInnoDB
ÀàÐ͸ü¿ì£¬µ«ÊDz»ÌṩÊÂÎñÖ§³Ö£¬¶øInnoDB
ÌṩÊÂÎñÖ§³ÖÒѾ­Íⲿ¼üµÈ¸ß¼¶Êý¾Ý¿â¹¦ÄÜ¡£
MyIASMÊÇIASM± ......

LinuxÏÂMySQL¿ª·ÅrootµÄÔ¶³Ì·ÃÎÊȨÏÞ

»·¾³£ºRHEL 5.3
°²×°ÁËMySQLÖ®ºó£¬MySQLµÄrootÓû§Ä¬ÈÏÊDz»¿ª·ÅÔ¶³Ì·ÃÎÊȨÏ޵ġ£ÎªÁË¿ª·ÅËü£¬Ö»ÐèÒªÁ½²½£º
ÓÃLinuxϵͳµÄrootÓû§µÇ¼ϵͳ£¬È»ºó£º
£¨1£©¿ª·Å3306¶Ë¿ÚµÄÔ¶³ÌÁ¬½ÓȨÏÞ£º
ÔÚ“-A RH-Firewall-1-INPUT -j REJECT --reject-with icmp-host-prohibited”ÕâÒ»ÐеÄÉÏÃæ£¨×¢Ò⣬һ¶¨ÊÇÉÏÃæ£©£¬Ìí¼ÓÈçÏ ......

Windowsϰ²×°×îеÄApache+PHP+MySQLÖ¸ÄÏ



   ´ËÎÄյݲװ·½·¨ÊÊÓÃÓÚWindows XP
쵀Apache+PHP+MySQL
°²×°£¬Í¬Ê±Ò²ÊÊÓÃÓÚWindows 2003
ϵͳϵݲװºÍÅäÖá£
1.
°²×°»·¾³
²Ù×÷ϵͳÊÇ Windows XP
ÖÐÎİæ, Apache,
PHP, MySQL
µÄ×îа汾ÊǽØÖ¹µ½ 2007.09.07
£¬·Ö±ðÔÚÆä¹ÙÍøÏÂÔØµÄ:
* Apache 2.2.6
£ºhttp://apache.mirror.phpchina.c ......

ʹÓÃ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Óû§ÈÏ֤ЭÒé¸ü»»£¨mysqlʹÓÃÎÊÌâ)

°²×°ºÃmysqlºó£¬ÔÚʹÓÃmysqʱ£¬³öÏÖÁËÈçÏÂÎÊÌâ.
java.sql.SQLException: Communication failure during handshake. Is there a server running on localhost:3306?
at org.gjt.mm.mysql.MysqlIO.init(MysqlIO.java:327)
at org.gjt.mm.mysql.Connection.connectionInit(Connection.java:261)
at org.gjt.mm.mysql.jdbc2 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ