powerdesigner设计的表,出错行在下面这里:/*==============================================================*/
/* INDEX: "REFERENCE_7_FK" */
/*==============================================================*/
CREATE INDEX REFERENCE_7_FK
(
MEMBERID
);错误提示如下:
错误
SQL 查询: /*==============================================================*//* INDEX: "REFERENCE_7_FK" *//*==============================================================*/ CREATE INDEX REFERENCE_7_FK(MEMBERID
);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 '(
MEMBERID
)' at line 6
/* INDEX: "REFERENCE_7_FK" */
/*==============================================================*/
CREATE INDEX REFERENCE_7_FK
(
MEMBERID
);错误提示如下:
错误
SQL 查询: /*==============================================================*//* INDEX: "REFERENCE_7_FK" *//*==============================================================*/ CREATE INDEX REFERENCE_7_FK(MEMBERID
);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 '(
MEMBERID
)' at line 6
修改方法:
1.打开 PowerDesigner 12\Resource Files\DBMS\mysql40xdb文件
找到: Sql代码
/*==============================================================*/
/* Index: "%referenceCode%_FK" */
/*==============================================================*/
create index %referenceCode%_FK
(
%fkColumns%
);
/*==============================================================*/
/* Index: "%referenceCode%_FK" */
/*==============================================================*/
create index %referenceCode%_FK
(
%fkColumns%
);