mysql eventµ÷Óô洢¹ý³Ì
mysql event (ÓÃÀ´ÊµÏÖ¶¨Ê±ÈÎÎñ)¡£mysql
´Ó
5.1.16
¿ªÊ¼ÓµÓеÄй¦ÄÜ¡£
ÏÂÃæÎÒдһ¸ö¼òµ¥µÄʾÀý¡£
ÏÈ´´½¨Êý¾Ý¿âºÍÁ½¸ö±í£º
drop database dep;
create database dep;
use dep;
create table aa
(id int AUTO_INCREMENT primary key,
remark varchar(20)
);
create table bb
(id int AUTO_INCREMENT primary key,
remark varchar(20)
);
ÏÈÍùa±íÖвåÈëÊý¾Ý
insert aa values(null,'aa');
insert aa values(null,'bb');
´´½¨´æ´¢¹ý³Ì£¬Æä¹¦ÄÜÊǰÑa±íµÄÄÚÈݸ´ÖƵ½b±íÖÐ.
drop PROCEDURE if exists aapro;
create PROCEDURE aapro()
begin
insert into bb (remark) select remark from aa;
commit;
end;
´´½¨mysql event,
´Ó
2010
Äê1
ÔÂ
14
ÈÕ
15
µã
24
·Ö
59
ÃëÆðÿ1·ÖÖÓµ÷ÓÃÒ»´Î
procedure aapro
¡£
drop event if exists aa_event;
create event aa_event
on SCHEDULE
EVERY 1 MINUTE STARTS '2010-01-14 15:24:59'
ON COMPLETION PRESERVE
DO call aapro();
Æð³õÎÒÖ´ÐÐÉÏÃæµÄ
aa_event¡£b±íÖÐһֱûÓÐÊý¾Ý£¬µ¥¶ÀÔËÐд洢¹ý³ÌÏÔʾÓÐÊý¾Ý£¬
ºóΪ²é×ÊÁϲÅÖªµÀûÓÐÆô¶¯mysql event,
Æô¶¯Óï¾ä:set global event_scheduler =1;
ÔÚÔËÐÐaa_event֮ǰÔËÐС£
Ôٴβéѯb±í,¾ÍÓÐÊý¾ÝÁË¡£
Ïà¹ØÎĵµ£º
¡¾×ª×Ô£ºhttp://tdcq.javaeye.com/blog/363955£¬·Ç³£¸ÐлÔ×÷Õß¡¿
ÕâÆªÎÄÕÂÊÇÍøÉϸ÷ÖÖ½â¾ömysqlÖÐÎÄÂÒÂëÎÊÌâµÄ¼¯´ó³ÉÕߣ¬Ò»°ã¿ÉÒÔ½â¾öÎÊÌâ¡£
mysql ´´½¨
Êý¾Ý¿âʱָ¶¨±àÂëºÜÖØÒª£¬ºÜ¶à¿ª·¢Õß¶¼Ê¹ÓÃÁËĬÈϱàÂ룬µ«ÊÇÎÒʹÓõľÑéÀ´¿´£¬Öƶ¨Êý¾Ý¿âµÄ±àÂë¿ÉÒԺܴó³Ì¶ÈÉϱÜÃâµ¹Èëµ¼³ö´øÀ´µÄÂÒÂëÎÊÌâ¡£
ÎÒÃÇ×ñѵıê×¼ÊÇ£¬Êý ......
1. ÔÚÆäËü»úÆ÷ÉÏÊ×ÏȰ²×°ºÃÐèÒªµÄmysql ºÍ¶ÔÓ¦µÄ¹ÜÀíÈí¼þ£¨ÉèÖõÄÃÜÂëºÍÔ´Êý¾Ý¿âÃÜÂëÒ»Ö£©
2. ½«Ô´»úÆ÷ÉÏdataϵÄÊý¾Ý¿âÎļþ¼Ð£¨ÒÔÎҵĻúÆ÷ΪÀý£¬¾ÍÊÇrubberFactoryÎļþ¼Ð£¬ÆäÖУ¬
Õâ¸öÎļþ¼ÐϵÄÊý¾ÝÎļþ¶¼ÊÇһЩ±í½á¹¹¶¨Ò壩¿½±´µ½Ä ......
1¡¢Ð½¨±ítest create table test1( field1 int not null ) ENGINE=MyISAM DEFAULT CHARSET=gbk; insert into test1(field1) values(1); 2¡¢É¾³ýÒÑ´æÔڵĴ洢¹ý³Ì -- ɾ³ý´¢´æ¹ý³Ì delimiter // -- ¶¨Òå½áÊø·ûºÅ drop procedure p_test; 3¡¢mysql´æ´¢¹ý³Ì¶¨
1¡¢Ð½¨±ítest
create table test1(
field1 int not null
)
......
ÏÂÔØ ADO.NET Driver for MySQLMySql.Data.dll
°²×°ºó£¬ÔÚ°²×°Ä¿Â¼ÏÂÃæÕÒµ½Assemblies
Îļþ¼Ð£¬ÕÒµ½ MySql.Data.dll
(´ËÎļþÊÇ.Net·ÃÎÊMySQLÊý¾Ý¿âµÄÒ»¸öÇý¶¯£¬ÍêÈ«ADO.NETÊý¾Ý·ÃÎÊģʽ£¬ÓÉMySQL¹Ù·½Ìṩ£¬Óжà¸ö°æ±¾¿ÉÑ¡Ôñ¡£)
ѧϰµÄÒ»¸öÁ´½Ó£ºhttp://www.cnblogs.com/wcfgroup/articles/1242256.html
´´½¨Ò»¸ö ......
[root@pku-fan MySQL]# cat limbs.sql
CREATE DATABASE cookbook;
USE cookbook;
DROP TABLE IF EXISTS limbs;
CREATE TABLE limbs
(
thing VARCHAR(20), # what the thing is
legs INT, ......