MysqlÈÎÎñµ÷¶È£¨Event£©
<!-- [if gte mso 10]>
MySQL5.1.x
°æ±¾ÖÐÒýÈëÁËÒ»ÏîÐÂÌØÐÔ
EVENT
£¬¹ËÃû˼Òå¾ÍÊÇʼþ¡¢¶¨Ê±ÈÎÎñ»úÖÆ£¬ÔÚÖ¸¶¨µÄʱ¼äµ¥ÔªÄÚÖ´ÐÐÌض¨µÄÈÎÎñ£¬Òò´Ë½ñºóһЩ¶ÔÊý¾Ý¶¨Ê±ÐÔ²Ù×÷²»ÔÙÒÀÀµÍⲿ³ÌÐò£¬¶øÖ±½ÓʹÓÃÊý¾Ý¿â±¾ÉíÌṩµÄ¹¦ÄÜ¡£´Ë¹¦ÄÜÊǶÔ
Oracle
µÄ
Job/Schedule
µÄÄ£·Â£¬
5.1.X
°æ±¾ÒÔÉϲÅÖ§³Ö¡£
´´½¨
EVENT
Óï·¨ÈçÏ£º
CREATE
[DEFINER = { user | CURRENT_USER }]
EVENT
[IF NOT EXISTS]
event_name
ON SCHEDULE schedule
[ON COMPLETION [NOT] PRESERVE]
[ENABLE | DISABLE | DISABLE ON SLAVE]
[COMMENT ''comment'']
DO sql_statement;
schedule:
AT timestamp [+ INTERVAL interval]
| EVERY interval
[STARTS timestamp [+ INTERVAL interval]]
[ENDS timestamp [+ INTERVAL interval]]
interval:
quantity {YEAR | QUARTER | MONTH | DAY | HOUR | MINUTE |
WEEK | SECOND | YEAR_MONTH | DAY_HOUR | DAY_MINUTE |
DAY_SECOND | HOUR_MINUTE | HOUR_SECOND | MINUTE_SECOND}
ÀýÈç´´½¨Ò»¸öÿ
30
ÃëÇå¿Õ
tableA
Êý¾ÝµÄÈÎÎñ
CREATE EVENT E_DELETE_ASO_TOKEN ON SCHEDULE
EVERY 30 SECOND DO DELETE from tableA ;
ĬÈÏ
EVENT
Ö§³ÖÊÇûÓÐÆô¶¯µÄ£¬¿ÉÒÔͨ¹ýÏÂÃæµÄÃüÁîÀ´²é¿´×´Ì¬£º
Select @@event_scheduler;
Èç¹û·µ»Ø
OFF
£¬ÔòÐèÒªÖ´ÐÐÏÂÃæµÄÃüÁîÆô¶¯£º
SET GLOBAL event_scheduler = ON;
ºÃÁË£¬ÉÏÃæËäÈ»Æô¶¯ÁË
EVENT
£¬µ«ÊÇÿ´ÎÖØÆô
mysql
Ö®ºó
EVENT
²¢Ã»ÓÐ×Ô¶¯Æô¶¯£¬ÄÇôÈçºÎÈÃËü×Ô¶¯Æô¶¯ÄØ£¿
·½·¨Ò»£ºÕÒµ½µ±Ç°Ê¹ÓõÄ
.cnf
Îļþ£¬ÔÚ
[mysqld]
µÄÏÂÃæ¼ÓÈëÈçÏÂÐÐ
event_scheduler=1
·½·¨¶þ£ºÆô¶¯
mysql
µÄʱºòÔö¼Ó
--event_scheduler=1
mysql start --event_scheduler=1
ʼþÏêϸÓï·¨ÊÂÀý
(EVENT)
1>
´´½¨Ê¼þ
(CREATE
EVENT)
ÏÈÀ´¿´Ò»ÏÂËüµÄÓï·¨£º
CREATE EVENT [IF NOT EXISTS] event_name
ON SCHEDULE schedule
[ON COMPLETION [NOT] PRESERVE]
[ENABLE | DISABLE]
[COMMENT ''comment'']
DO sql_statement;
schedule:
AT TIMESTAMP [+ INTERVAL INTERVAL]
|
EVERY INTERVAL [STARTS TIMESTAMP] [END
Ïà¹ØÎĵµ£º
±¾ÎĽéÉÜÁËÊý¾Ý¿âË÷Òý£¬¼°ÆäÓÅ¡¢È±µã¡£Õë¶ÔMySQLË÷ÒýµÄÌص㡢ӦÓýøÐÐÁËÏêϸµÄÃèÊö¡£·ÖÎöÁËÈçºÎ±ÜÃâMySQLÎÞ·¨Ê¹Óã¬ÈçºÎʹÓÃEXPLAIN·ÖÎö²éѯÓï¾ä£¬ÈçºÎÓÅ»¯MySQLË÷ÒýµÄÓ¦Óᣱ¾ÎÄÕª×Ô¡¶MySQL 5ȨÍþÖ¸ÄÏ¡·(3rd)µÄ8.9½Ú¡£(2007.07.05×îºó¸üÐÂ)
Ë÷ÒýÊÇÒ»ÖÖÌØÊâµÄÎļþ(InnoDBÊý¾Ý±íÉϵÄË÷ÒýÊDZí¿Õ¼äµÄÒ»¸ö× ......
×î½ü¹«Ë¾×¼±¸Ê¹ÓÃÏîÄ¿¹ÜÀíµÄÍøÕ¾DotProject£¬¹«Ë¾ËäÈ»²»´ó£¬µ«ÊÇÇ£Éæµ½µÄÒµÎñÒ²ÊǺܸ´Ôӵģ¬ËùÒÔÐèÒª¶¨Ê±È¥±£´æÊý¾Ý¿âµÄÐÅÏ¢ÒÔ·ÀÖ¹Êý¾Ý¿â±ÀÀ£»òÕßÆäËûµÄÔÒòÔì³ÉµÄÊý¾ÝËðʧ£¬ÕâÑù¾ÍÐèÒª½øÐÐÊý¾Ý¿âµÄ±¸·Ý¡£
DotProjectʹÓõÄÊÇMysqlÊý¾Ý¿â£¬±¸·ÝMysqlÊý¾Ý¿âµÄÒ»¸ö±È½ÏºÃµÄ·½·¨¾ÍÊÇ ......
±àÒëÇ°ÐèÒª°²×°µÄ¿â£º
g++
libmysqlclient15-dev
libglade2-dev
libglib2.0-dev
libgtkmm-2.4-dev
libpcre3-dev
libxml2-dev
È»ºóÖ´ÐÐ
cd mysql-gui-common
./configure
make
sudo make install
cd ../mysql-administrator
./configure
make
sudo make install
°²×°MySQL Administrator
°²×°Íê³Éºómysql- ......
Java´úÂë
mysql> select version(),current_date;
²éѯmysqlµÄ°æ±¾ºÅ ºÍ ÈÕÆÚ
mysql> select version();
²éѯmysqlµÄ°æ±¾ºÅ
select now();
²éѯµ±Ç°ÈÕÆÚºÍ׼ȷµÄʱ¼ä
Java ......
<!-- [if gte mso 10]>
ÒÔÏÂÄÚÈÝÀ´×ÔÍøÂ磬ÒѲâÊÔ¡£
½áÂÛ£º
mysql
ÐÐËø²»°²È«£¬ËæÊý¾ÝµÄ±ä»¯£¬¿ÉÄÜ»á³öÏÖÐÐËøÎÞЧ£¡Òò´Ë£¬·ÇÈ·¶¨Çé¿öÏ£¬²»Òª¶Ô
mysql
±í¼ÓÐÐËøÀ´¿ØÖÆÒµÎñÂß¼¡£
ÓÉÓÚÒµÎñÂß¼µÄÐèÒª£¬±ØÐë¶ÔÊý¾Ý±íµÄÒ»Ðлò¶àÐмÓÈëÐÐËø£¬¾Ù¸ö×î¼òµ¥µÄÀý×Ó£¬Í¼Êé½èÔÄϵͳ¡£¼ÙÉè
id=1
µÄÕâ±¾Êé¿â´æΪ
1
£ ......