解决下拉框替换输入框或调整位置导致数据重复提交的问题
错误处理 370
输入框换成下拉框,或者调下位置点发布会报数据重复
-
### 界面设计器发布报错提示数据重复的修复sql
## 查出异常记录
SELECT id,version from designer_ui_designer_view_layout AS a
WHERE a.version!=(
SELECT MAX(b.version)+1
FROM designer_ui_designer_view_layout_history AS b
WHERE b.layout_id = a.id
);## 修正异常记录
UPDATE designer_ui_designer_view_layout AS a
SET version = (
SELECT MAX(b.version)+1
FROM designer_ui_designer_view_layout_history AS b
WHERE b.layout_id = a.id
)
WHERE a.version!=(
SELECT MAX(b.version)+1
FROM designer_ui_designer_view_layout_history AS b
WHERE b.layout_id = a.id
);8个月前