关系型数据库Mysql、Oracle

Mysql

SELECT SYSDATE();

# 获得时分秒
SELECT CURTIME();

# 获得日期，不带时分秒
SELECT CURDATE();

# 获得随即id
SELECT UUID();

# 获得创建表语句
SHOW CREATE TABLE t_p_xmzxzt;

# 获得随即id
SELECT REPLACE(UUID(),"-","");

SELECT no FROM T_IOT_SALE_ORDER where no = '"&B2&"'

LIKE CONCAT('%',#{id},'%')
"%"#{id}"%"

Oracle

oracle解锁表
select t.*,t.rowid from T_P_XQTB t
select * from T_P_XQTB for update

@Param("name1") String name2
从request中取出name1。赋值到name2

Java.data存入sql.data时分秒丢失解决
@JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8")
@DateTimeFormat(pattern="yyyy-MM-dd")
javaType='TIMESTAMP'

select lpad(nvl(to_number(substr(max(code),-5))+1,0),5,0) from T_RISK_HAZARD where code like 'WXY' || to_char(sysdate,'yymm')||'%';

拼接单列数据wm_concat()函数

select wm_concat(no) from t_iot_sale_order

下月1号日期

to_date(to_char(add_months(sysdate, 1), 'yyyy-mm'), 'yyyy-mm')

select '@@@' || to_char(sysdate,'yymm') ||lpad((nvl(to_number(max(substr(CODE,-5))),0)+1),5,0) from table
      where table.CODE like '@@@'|| to_char(sysdate,'yymm') || '%'