mysqlÖд¥·¢Æ÷Öи³ÖµµÄÎÊÌâ
DELIMITER $$;
DROP TRIGGER `test`.`ttt`$$
create trigger `ttt` BEFORE INSERT on `test`
for each row BEGIN
#set @daytemp:=DAYOFWEEK(NEW.timestampNow);
select DAYOFWEEK(NEW.timestampNow) into @daytemp from test where id=new.id;
if @daytemp <7 then
set NEW.canshow=1;
end if;
END;
$$
DELIMITER ;$$
=========================================
ʹÓÃmysqlµÄ´¥·¢Æ÷£¬Ô¶¨¾ÍÊÇÓÐÒ»¸ö×Ö¶ÎÊÇtimestampÀàÐÍ£¬Ä¬ÈÏÊÇCurrent_timestamp¡£
ÔÚ´¥·¢Æ÷ÖÐÅжϣ¬Èç¹ûмͼµÄÈÕÆÚÊÇÖÜÒ»µ½ÖÜÎ壬 set new.canshow=1;
µ«ÊÇÏÖÔÚµÄÎÊÌâÊÇ£¬ÓÃ
set @daytemp:=DAYOFWEEK(NEW.timestampNow); »òÊÇ
select DAYOFWEEK(NEW.timestampNow) into @daytemp from test where id=new.id;
¶¼È¡²»µ½DAYOFWEEK(NEW.timestampNow)µÄÖµ¡£
µ«ÊÇÔÚquery Öе¥¶ÀÖ´ÐÐ select DAYOFWEEK(NEW.timestampNow) from test;ÊÇ¿ÉÒԵġ£
Çë½Ì¸÷λÈçºÎ½â¾ö£¬Ð»Ð»¡£
Ö±½ÓÈ¡NOWÖеÄÐÇÆÚ²»ÐУ¿BEFOREÖУ¬×ֶλ¹Ã»ÓÐÖµ
ллÉÏÃæµÄÁ½Î»£¬½â¾öÁË¡£
Ïà¹ØÎÊ´ð£º
ÎÒÒѾ°´Õս̳ÌÉÏÅäÖÃtomcatµÄserver.xml
<Context path = "/POS" docBase = "POS" debug = "5" reloadable = "true" crossContext = "true" workDir = &quo ......
ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ
javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test
ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......
ÔÚC++³ÌÐòÖÐͨ¹ýmysqlµÄC APIÖ±½ÓÁ¬½ÓÊý¾Ý¿â£¬µ±°ÑÖÐÎIJåÈëmysqlµÄʱºò£¬¾Í±ä³ÉÂÒÂëÁË.
»¹ÓоÍÊÇʹÓÃload°ÑÎı¾Îļþµ¼ÈëmysqlÊý¾Ý¿â£¬ÎÞÂÛÎı¾ÎļþÊÇANSI±àÂ뻹ÊÇutf8±àÂ룬µ¼ÈëÖ®ºó¶¼ÊÇÂÒÂë¡£
ÆäÖÐmysqµÄ±àÂë¸ñʽ ......
mysqlÊý¾Ý¿âµÄ±àÂë¸ñʽÊÇutf8
ÔÚc++³ÌÐòÖÐʹÓÃC APIÖ±½ÓÁ¬½ÓmysqlÊý¾Ý¿â£¬°ÑÖÐÎı£´æµ½mysqlÊý¾Ý¿âÖУ¬ÖÐÎç±ä³ÉÂÒÂë
ʹÓÃmysqlµÄloadÃüÁîµ¼ÈëÎı¾Îļþ£¬ÎÞÂÛÎı¾ÎļþÊÇANSI»¹ÊÇutf8±àÂ룬¶¼ÊÇÂÒÂë
ÇëÎÊÉÏÃæÁ½¸öÎÊ ......
±¾ÈËÏëÖªµÀMySqlÔõôÔÚÊý¾Ý°²×°µÄʱºò¾ÍÄÜ×Ô¶¯È¥Éú³ÉһЩĬÈϵÄÓû§ºÍȨÏÞÄØ£¨Óû§£ºClient£¬ÃÜÂ룺12345£©£¿
±ÈÈçÊDz»ÊÇÐèҪд×Ô¶¯°²×°½Å±¾°¢£¿µÈµÈ£¬Ð»Ð»£¡
MySQLµÄ±ê×¼°²×°£¬»òÕ߷ǰ²×°°æ±¾Öв»»á°ïÄã´´½¨ÕâЩ ......