标签:

Oracle函数转MySQL常见写法
获取当月第一天Oracle写法：trunc(add_months(last_day(sysdate), -1) + 1)MySQL写法：DATE_ADD(now(),interval -day(now())+1 day)将当前时间添加-1个月Oracle写法：add_months(sysdate,
2022-12-09
/
20 阅读
Oracle转mysql函数相关
获取当月第一天：DATE_ADD(curdate(),interval -day(curdate())+1 day))ADDDATE(NOW(), INTERVAL -#{start} MONTH)%Y-%m-%d %TOracle:(SYSDATE- STR_TO_DATE(b.CREATE_TM
2022-11-29
/
21 阅读
临时查看mysql实时SQL日志
设置临时开关set global general_log='ON'; 查看日志位置show global variables like '%general%'; 输出结果 +------------------+--------
2022-01-11
/
19 阅读
解决Mysql：Incorrect string value: \'\\xF0\\x9F\\x8D\\x83\\xF0\\x9F...\' for column
# 1、异常 ```sh java.sql.BatchUpdateException: Incorrect string value: '\xF0\x9F\x8D\x83\xF0\x9F...' for column 'nickname' at row 1
2023-02-01
/
26 阅读