Çë½ÌÒ»¸ömysql triggerµÄÎÊÌâ
ÇëÎÊÔÚmysqlµÄupdate triggerÖУ¬ÈçºÎ»ñÈ¡µ±Ç°Ö´ÐеÄsqlÓïÖеÄwhereÌõ¼þ£¬Ð»Ð»
ÎÊÌâ±È½ÏÆæ¹Ö£¬ÎªÊ²Ã´ÒªÕâÑù£¿
ÔÚtriggerÖлñÈ¡µ½Óï¾äÒª×öÊ²Ã´ÄØ
ÎÒµÄÕâ¸öupdate trigger¸üеÄÊÇmemcache£¬¶øÎÒ»¹Òª´ÓmemcacheÖÐÈ¡³öÊý¾Ý£¬»¹Ôµ½oracleÖУ¬ËùÒÔ£¬ÒªÈ¡µÃmysqlÖ´ÐеÄsqlÓï¾äµÄÌõ¼þ
лл£¬ÈçºÎ¿ÉÐеϰ£¬ÕâÊǸö·½·¨£¬ÎÒ¿ÉÒÔÊÔÊÔ£¬»¹ÓиüºÃµÄ·½·¨Âð
¶øÎÒ»¹Òª´ÓmemcacheÖÐÈ¡³öÊý¾Ý£¬»¹Ôµ½oracleÖУº
Äã¿ÉÒÔÓÃÒ»¸ö±í´æ·Å¸üÐÂǰmemcacheµÄÖµ
triggerÖУº
insert into lsb values(old.memcache)
Èç¹ûÄãÖ»ÊÇҪȡ¸üÐÂǰmemcacheµÄÖµ£¬ÔÚTRIGGERÖÐÓÃold.memcache¾ÍOKÁË£¬±£´æµ½
Ïà¹ØÎÊ´ð£º
ÈçÌ⣬ÕâÈý¸öÔÚwin7ÏÂʹÓûáÓÐʲô¼æÈÝÐÔÎÊÌâÂð£¿
ÓÉÓÚÎÒ×î½üÔÚʹÓÃwin7£¬¾ÍÀÁµÃ½øxpÁË£¡
×Ô¼ºÓÃwindows 2008ÓÐÒ»Äê¶àÁË£¬Ã»³öÏÖÈκÎÎÊÌâ¡£
win7²âÊÔ°æÒ²Óùý£¬²»»áÓÐʲôÎÊÌâµÄ£¬·ÅÐÄ¡£
µ±È»Äã×î ......
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ÓÐÊ²Ã´Çø±ð£¿ËûÁ©ÊDz»ÊÇÒ»¸ö¶«Î÷£¿
²»ÊÇÒ»¸ö³§¼ÒµÄÊý¾Ý¿â²úÆ·¡¡
µÚ¶þ¸ö×Öĸ²»Ò»Ñù
ËûÃǶ¼ÊÇDBMS£¬Êý¾Ý¿â¹ÜÀíϵͳ£¬Ö»ÊÇÁ½¸ö²»Í¬¹«Ë¾£¨»ò×éÖ¯£©µÄ²úÆ·¡£
MSSQL¹ËÃû˼Òå¾ÍÊÇ΢Èí¹«Ë¾µÄ²úÆ·£¬È«³ ......
¼ÙÉèÎÒÓÐÒ»Õűí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 ......