一.mysql相关
1.触发器:
①.mysql触发器trigger 实例详解:https://www.cnblogs.com/phpper/p/7587031.html
②.https://www.cnblogs.com/lyhabc/p/3802704.html
2.自定义函数:
①.https://www.cnblogs.com/pengyin/p/6395652.html
②.https://www.cnblogs.com/zhangminghui/p/4113160.html
③.oracle中instr()函数(四个参数的)在mysql中的实现:
https://blog.csdn.net/yueliangdao0608/article/details/50186375
3.mysql自带函数:
①.length()函数:https://blog.csdn.net/weixin_42056745/article/details/80772573
②.截取字符串函数:substr(),left(),right()等函数:https://www.cnblogs.com/wjm956/p/7724244.html
③.limit函数:https://blog.csdn.net/lanyang123456/article/details/57522471
④.concat,concat_ws,GROUP_CONCAT函数的用法:https://blog.csdn.net/qq_35211818/article/details/78977276
④.Oracle中TO_NUMBER相当于mysql中cast函数:https://www.cnblogs.com/webttt/p/7764693.html
4.mysql存储过程:https://www.cnblogs.com/geaozhang/p/6797357.html
5.mysql中相关东西:
①.mysql中insert into select from的使用:https://www.cnblogs.com/jpfss/p/6973048.html
二.Oracle相关
1.自定义函数:
①.https://www.cnblogs.com/zhengcheng/p/4220924.html
2.oracle中自带函数:
①.Oracle中的instr()函数详解及应用:https://www.cnblogs.com/dshore123/p/7813230.html
②.Oracle中的substr函数详解:https://www.cnblogs.com/dshore123/p/7805050.html,和mysql中的substr完全一样
③.Oracle中substr()与 substrb()函数的区别:https://blog.csdn.net/u010202304/article/details/44905401
④.Oracle中to_number函数:https://blog.csdn.net/jiangnan2014/article/details/16921985
3.oracle中的存储过程:
①.https://www.cnblogs.com/dc-earl/articles/9260111.html
②.https://www.cnblogs.com/lideng/p/3427822.html
③.https://www.cnblogs.com/liuyp-ken/p/5751550.html
自己总结:
①.对于mysql在触发器中调用存储过程的时候,需要加CALL,如下所示:其中TO_PSS_ITEM为存储过程
DELIMITER $$
CREATE TRIGGER ES_TOPSS_PROJECTS_END_STATE_TR AFTER INSERT ON ES_TOPSS_PROJECTS_END_STATE FOR EACH ROW
BEGIN
DECLARE L_code VARCHAR (10) character set utf8 ;
DECLARE L_msg VARCHAR (1000) character set utf8;
CALL TO_PSS_ITEM (
NEW.ITEMID,
NEW.MANNER,
NEW.PUBLISHMEDIUM,
NEW.BIDAGENCY,
NEW.QUALIFICATIONLEVEL,
NEW.PRICE,
NEW.PREQUALIFICATIONNUM,
NEW.BIDDERNUM,
NEW.SUCCBIDDERNUM,
NEW.PRINCIPLE,
NEW.BIDOPENINGTIME,
NEW.BIDOPENINGPLACE,
NEW.BIDEVALUATIONBEGIN,
NEW.BIDEVALUATIONEND,
NEW.BIDEVALUATIONPLACE,
NEW.METHOD,
NEW.PURRESULTTIME,
NEW.PURRESULTPRICE,
NEW.ATTR1
);
END $$
DELIMITER ;
②.对于mysql,存储过程中调用函数的时候,用下面的SELECT GET_PRI_ID(P_ES_ITEM_ID) INTO P_PRI_ID;其中GET_PRI_ID为函数,P_PRI_ID为需要赋予的值