![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
MYSQL
吾在水一方
接下来,请为自己new一个对象吧!!!
展开
-
mysql触发器及函数简单使用
new oldinsert,update操作的数据是newdelete操作的数据是old业务修改表数据后需要更新另外表的字段数据BEGIN SET @organizationId = (SELECT organization_id FROM `bn_organization_user` WHERE user_id = NEW.user_id); SET @totalStudent = (SELECT COUNT(0) FROM bn_organizati..原创 2021-09-29 18:12:40 · 142 阅读 · 0 评论 -
mysql和Mapper中批量更新数据写法
mapper写法:<update id="updateOrderStateByOrderId" parameterType="java.util.List"> update t_replace_order set Forder_state = <foreach collection="list" item="item" index="index"翻译 2018-08-24 16:54:05 · 4848 阅读 · 0 评论