2025-04-09 10:50:13 +08:00
|
|
|
|
# 修改mysql
|
|
|
|
|
|
|
|
|
|
|
|
1. my.cnf文件或my.ini文件的sql-mode修改成下面的值
|
|
|
|
|
|
[mysqld]
|
|
|
|
|
|
sql-mode="
|
|
|
|
|
|
STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
|
|
|
|
|
|
|
2025-04-09 11:27:18 +08:00
|
|
|
|
2. 导入sql文件的function失败执行下面命令 set global log_bin_trust_function_creators=TRUE;
|
|
|
|
|
|
|
|
|
|
|
|
# idea配置
|
|
|
|
|
|
|
|
|
|
|
|
idea运行需要把内存修改大一点
|
|
|
|
|
|
|
2025-08-01 18:33:08 +08:00
|
|
|
|
|
|
|
|
|
|
# 兼容达梦（连接mycat代理的达梦）
|
|
|
|
|
|
## 创建函数：
|
|
|
|
|
|
CREATE OR REPLACE FUNCTION TO_DAYS(in_date DATE)
|
|
|
|
|
|
RETURN NUMBER
|
|
|
|
|
|
AS
|
|
|
|
|
|
BEGIN
|
|
|
|
|
|
RETURN TRUNC(in_date) - DATE '1970-01-01';
|
|
|
|
|
|
END;
|
|
|
|
|
|
|
|
|
|
|
|
## 修改server.xml配置
|
|
|
|
|
|
system标签下添加：
|
|
|
|
|
|
<property name="sqlTranslate">true</property>
|
|
|
|
|
|
<property name="sqlTranslateType">dm</property>
|
|
|
|
|
|
|
|
|
|
|
|
<!-- 关键配置：移除反引号 -->
|
|
|
|
|
|
<property name="removeGraveAccent">1</property>
|
|
|
|
|
|
|
|
|
|
|
|
## 修改dm.ini配置
|
|
|
|
|
|
COMPATIBLE_MODE改成mysql的数字
|
