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

Çë½ÌÒ»¸ömysql triggerµÄÎÊÌâ

ÇëÎÊÔÚmysqlµÄupdate triggerÖУ¬ÈçºÎ»ñÈ¡µ±Ç°Ö´ÐеÄsqlÓïÖеÄwhereÌõ¼þ£¬Ð»Ð»
ÎÊÌâ±È½ÏÆæ¹Ö£¬ÎªÊ²Ã´ÒªÕâÑù£¿

ÔÚtriggerÖлñÈ¡µ½Óï¾äÒª×öÊ²Ã´ÄØ


ÎÒµÄÕâ¸öupdate trigger¸üеÄÊÇmemcache£¬¶øÎÒ»¹Òª´ÓmemcacheÖÐÈ¡³öÊý¾Ý£¬»¹Ô­µ½oracleÖУ¬ËùÒÔ£¬ÒªÈ¡µÃmysqlÖ´ÐеÄsqlÓï¾äµÄÌõ¼þ

лл£¬ÈçºÎ¿ÉÐеϰ£¬ÕâÊǸö·½·¨£¬ÎÒ¿ÉÒÔÊÔÊÔ£¬»¹ÓиüºÃµÄ·½·¨Âð

ÒýÓÃ
Èç¹ûÊÇ5ÒÔÉÏ£¬¿ÉÒÔ²éѯ
information_schema±íÖеÄinfo×Ö¶Î
SELECT * from information_schema.`PROCESSLIST` P
where and command='Query'
and state='executing'
and info='select ... your sql statement'

²éºóÔÙÈ¡ÄÚÈÝÖÐWHERE¡¡ºóÃæµÄÄÚÈÝ


¶øÎÒ»¹Òª´ÓmemcacheÖÐÈ¡³öÊý¾Ý£¬»¹Ô­µ½oracleÖУº
Äã¿ÉÒÔÓÃÒ»¸ö±í´æ·Å¸üÐÂǰmemcacheµÄÖµ
triggerÖУº
insert into lsb values(old.memcache)

ÒýÓÃ
лл£¬ÈçºÎ¿ÉÐеϰ£¬ÕâÊǸö·½·¨£¬ÎÒ¿ÉÒÔÊÔÊÔ£¬»¹ÓиüºÃµÄ·½·¨Âð

ÒýÓà 3 Â¥ wwwwa µÄ»Ø¸´:
Èç¹ûÊÇ5ÒÔÉÏ£¬¿ÉÒÔ²éѯ
  information_schema±íÖеÄinfo×Ö¶Î
  SELECT * from information_schema.`PROCESSLIST` P
  where and command='Query'
  and state='executing'
  and info='select ... your sql statement'

  ²éºóÔÙÈ¡ÄÚÈÝÖÐWHERE¡¡ºóÃæµÄÄÚÈÝ


Èç¹ûÄãÖ»ÊÇҪȡ¸üÐÂǰmemcacheµÄÖµ£¬ÔÚTRIGGERÖÐÓÃold.memcache¾ÍOKÁË£¬±£´æµ½


Ïà¹ØÎÊ´ð£º

ÎÒÒª°Ñ×¢²áÐÅÏ¢Ìá½»µ½mysqlÖУ¬ÒªÔõô°ìÄØ£¿

ÎÒÔÚ×¢²áÒ³ÃæÐ´ÈëÁËÈçÏ´úÂ룺
<?php
    $conn=mysql_connect("localhost","root","614510")or die("Êý¾Ý¿â·þÎñÆ÷Á¬½Ó´íÎó".mysql_error());
& ......

mysql event scheduleÎÊÌâ

ÈçÌâ, ÎÒдÁËÒ»¸öevent schedule,ûÓÐÆð×÷ÓÃ,ҲûÓÐÈκγö´íÐÅÏ¢,´úÂëÈçÏÂ

delimiter |
create event myevent  on schedule every  2 second
starts current_timestamp
ends  curre ......

MYSQL´æ´¢¹ý³Ìµ÷ÓòÎÊýµÄÎÊÌâ

Ö±½ÓÉÏ´úÂë°É
VB code:

Option Explicit
Private Sub Command1_Click()

Dim MyComm As New ADODB.Command
Dim Rs_GetList As New ADODB.Recordset

With MyComm
.ActiveConn ......

mysqlºÍmssqlÓÐÊ²Ã´Çø±ð£¿

mysqlºÍmssqlÓÐÊ²Ã´Çø±ð£¿ËûÁ©ÊDz»ÊÇÒ»¸ö¶«Î÷£¿
²»ÊÇÒ»¸ö³§¼ÒµÄÊý¾Ý¿â²úÆ·¡¡

µÚ¶þ¸ö×Öĸ²»Ò»Ñù

ËûÃǶ¼ÊÇDBMS£¬Êý¾Ý¿â¹ÜÀíϵͳ£¬Ö»ÊÇÁ½¸ö²»Í¬¹«Ë¾£¨»ò×éÖ¯£©µÄ²úÆ·¡£
MSSQL¹ËÃû˼Òå¾ÍÊÇ΢Èí¹«Ë¾µÄ²úÆ·£¬È«³ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ