muguazhi的博客

【代码】mybatis-plus笔记。

MySQL、Oracle时间等相关笔记

forupdate可以方便手工修改数据，但是用完一定要记得关闭窗口，不然会造成锁表/行

<![CDATA[ >= ]]>like '%' || #{name,jdbcType=VARCHAR} || '%'

删除重复数据，只保留1一条delete from (select * from tbl_user_authority a where (a.user_account, a.dept_code) in (select b.user_account, b.dept_code ...

MINUS 从前面的结果集中减去后面的结果集select a.* from tab_a a where a.id in ('1','2')MINUSselect a.* from tab_a a where a.id ='1'等价于select a.* from tab_a a where a.id ='2'select 后面必须是结果集，不能是cou...

<!-- 批量插入 主键自增--> <insert id="insertBatch" parameterType="java.util.List"> insert into TAB_A (ID, CODE, NAME) select SEQ_TAB_A.Nextval, t.* from ( <for...

package com.demo.common.interceptor;import com.fasterxml.jackson.databind.DeserializationFeature;import com.fasterxml.jackson.databind.JavaType;import com.fasterxml.jackson.databind.ObjectMapper;import com.google.common.collect.Lists;import com.goog.

DROP TABLE IF EXISTS t_sequence; -- 建t_sequence表，指定seq列为无符号大整型，可支持无符号值：0(default)到18446744073709551615（0到2^64–1）。CREATE TABLE t_sequence ( name VARCHAR(50) NOT NULL, current_value BIGINT UNSIGNED NOT NULL DEFAULT 0, increment ..