stringjava_001的博客

<select id="getDeptUrl" parameterType="java.lang.String" resultType="com.tianheng.datacenter.system.model.dto.EmployeeDto"> select e.header_url as url, concat_ws('-',d.name,e.name) as dep...

遇到问题：A表插入数据使B表某个字段+1，按照MYSQL触发器编写SQL脚本CREATE TRIGGER message_num BEFORE INSERT ON wx_push_message_temp FOR EACH ROWUPDATE wx_messageSET num = num + 1 WHERE in_message = message猜想：1、当B表不存在响应...