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

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±í,¾ÍÓÐÊý¾ÝÁË¡£


Ïà¹ØÎĵµ£º

MySQL×Ö·û¼¯ÎÊÌâ

¡¾×ª×Ô£ºhttp://tdcq.javaeye.com/blog/363955£¬·Ç³£¸Ðлԭ×÷Õß¡¿
ÕâÆªÎÄÕÂÊÇÍøÉϸ÷ÖÖ½â¾ömysqlÖÐÎÄÂÒÂëÎÊÌâµÄ¼¯´ó³ÉÕߣ¬Ò»°ã¿ÉÒÔ½â¾öÎÊÌâ¡£
mysql ´´½¨
Êý¾Ý¿âʱָ¶¨±àÂëºÜÖØÒª£¬ºÜ¶à¿ª·¢Õß¶¼Ê¹ÓÃÁËĬÈϱàÂ룬µ«ÊÇÎÒʹÓõľ­ÑéÀ´¿´£¬Öƶ¨Êý¾Ý¿âµÄ±àÂë¿ÉÒԺܴó³Ì¶ÈÉϱÜÃâµ¹Èëµ¼³ö´øÀ´µÄÂÒÂëÎÊÌâ¡£
ÎÒÃÇ×ñÑ­µÄ±ê×¼ÊÇ£¬Êý ......

mysqlÊý¾ÝÒÆÖ²


 
1.   ÔÚÆäËü»úÆ÷ÉÏÊ×ÏȰ²×°ºÃÐèÒªµÄmysql ºÍ¶ÔÓ¦µÄ¹ÜÀíÈí¼þ£¨ÉèÖõÄÃÜÂëºÍÔ´Êý¾Ý¿âÃÜÂëÒ»Ö£©
2.   ½«Ô´»úÆ÷ÉÏdataϵÄÊý¾Ý¿âÎļþ¼Ð£¨ÒÔÎҵĻúÆ÷ΪÀý£¬¾ÍÊÇrubberFactoryÎļþ¼Ð£¬ÆäÖУ¬
      Õâ¸öÎļþ¼ÐϵÄÊý¾ÝÎļþ¶¼ÊÇһЩ±í½á¹¹¶¨Ò壩¿½±´µ½Ä ......

mysql´æ´¢¹ý³Ì

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
)
......

Ò»¸ö¼òµ¥µÄASP.NET·ÃÎÊMySqlÊý¾Ý¿â

ÏÂÔØ ADO.NET Driver for MySQLMySql.Data.dll
°²×°ºó£¬ÔÚ°²×°Ä¿Â¼ÏÂÃæÕÒµ½Assemblies
Îļþ¼Ð£¬ÕÒµ½ MySql.Data.dll
(´ËÎļþÊÇ.Net·ÃÎÊMySQLÊý¾Ý¿âµÄÒ»¸öÇý¶¯£¬ÍêÈ«ADO.NETÊý¾Ý·ÃÎÊģʽ£¬ÓÉMySQL¹Ù·½Ìṩ£¬Óжà¸ö°æ±¾¿ÉÑ¡Ôñ¡£)
 Ñ§Ï°µÄÒ»¸öÁ´½Ó£ºhttp://www.cnblogs.com/wcfgroup/articles/1242256.html
´´½¨Ò»¸ö ......

python mysqlµ¼ÈëÊý¾Ý

[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,     ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ