首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 软件管理 > PowerDesigner >

powerdesigner15.1生成的mysql话语出错

2013-10-25 
powerdesigner15.1生成的mysql语句出错?错误信息如下:1064 - You have an error in your SQL syntax chec

powerdesigner15.1生成的mysql语句出错

?

错误信息如下:

1064 - 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 '"鏀--鍛樺伐"' at line 11064 - 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 '?' at line 1Query OK, 0 rows affected1064 - 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 '?                 int not null,   瀹㈡埛ID                 int not null, ' at line 61064 - 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 '?                 int not null,   鍛樺伐ID                 int not null, ' at line 61064 - 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 '?                 int not null,   鍛樺伐ID                 int not null, ' at line 61064 - 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 '?                char(50),   primary key (鏀鍚嶇О))' at line 7

?

在原sql语句中在那个表名上自动加了双引号,这个该怎么去掉啊?(网上找到了oracle去掉双引号的方法,但是没有mysql的,因为是才开始使用powerdesigner,里边的东西也不敢乱改)

?

我用的powerdesigner是15.1,mysql是5.1.31,而powerdesigner15.1只有mysql5.0这个选项,没有mysql的更高版本了,是不是与数据库版本不匹配的问题?还是因为我的mysql是绿色版的?

?

最后,这个乱码是数据库的编码问题引起的吗?数据库就是utf-8的啊?

热点排行