Question

【iDesktop】创建mysql数据库型数据源报错：ENGINE = MyISAM-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 '-basic.SmRegister(SmDatasetID INT NOT NULL primary key,SmDatasetName VarChar(64)' at line 1。

Answer 1

【问题原因】表名或列名中包含了连字符（-）。 【解决办法】创建数据源时命名不要带有特殊字符。