Quick BI数据填报点击管理数据报错：" You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mod, `creator`, `modifier`, `create_time`, `modify_time` FROM `clumn_number` OR' at line 1"

问题描述

Quick BI数据填报点击管理数据报错：" You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mod, `creator`, `modifier`, `create_time`, `modify_time` FROM `clumn_number` OR' at line 1 "。

问题原因

数据填报中创建的表字段名mod是MySQL数据库关键字导致的。

解决方案

删除该组件，重新更换表字段名即可。

适用于

• Quick BI 公共云