Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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ÁË£¬±£´æµ½


Ïà¹ØÎÊ´ð£º

apache+PHP+mysqlÔÚwin7ÏÂʹÓÃ

ÈçÌ⣬ÕâÈý¸öÔÚwin7ÏÂʹÓûáÓÐʲô¼æÈÝÐÔÎÊÌâÂð£¿
ÓÉÓÚÎÒ×î½üÔÚʹÓÃwin7£¬¾ÍÀÁµÃ½øxpÁË£¡
×Ô¼ºÓÃwindows 2008ÓÐÒ»Äê¶àÁË£¬Ã»³öÏÖÈκÎÎÊÌâ¡£

win7²âÊÔ°æÒ²Óùý£¬²»»áÓÐʲôÎÊÌâµÄ£¬·ÅÐÄ¡£

µ±È»Äã×î ......

mysqlÓï¾äÓÅ»¯ÎÊÌâ ´ó¼Ò¸øÓÅ»¯¸öSQLÓï¾ä

SELECT a.tguildname ,SUM(a.ct) +  if (SUM(b.ct) IS NULL ,0,SUM(b.ct)) from (
SELECT  tg.tguildname,c.cid, (
cf.fbb + cf.fgjbb + cf.fjybb + cf.fqb + cf.fgjqb + cf.fjyqb + cf.fqib + cf. ......

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

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

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

ËûÃǶ¼ÊÇDBMS£¬Êý¾Ý¿â¹ÜÀíϵͳ£¬Ö»ÊÇÁ½¸ö²»Í¬¹«Ë¾£¨»ò×éÖ¯£©µÄ²úÆ·¡£
MSSQL¹ËÃû˼Òå¾ÍÊÇ΢Èí¹«Ë¾µÄ²úÆ·£¬È«³ ......

mysql ²éѯµÄÎÊÌâ

¼ÙÉèÎÒÓÐÒ»ÕűíA
Á½¸ö×Ö¶ÎID date

1 2009-10-10 11:11:11
2 2009-10-10 11:11:13
3 2009-10-10 11:11:15
4 2009-10-10 11:11:17

»¹ÓÐÒ»ÕűíB
Èý¸ö×Ö¶ÎID A_id date

1 1 2009-10 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ