约束条件下的mySQL语法错误

Question

CREATE TABLE MARINA_SLIP
(
SLIP_ID VARCHAR(4),
MARINA_NUM VARCHAR(4),
SLIP_NUM VARCHAR(4),
LENGTH INT,
RENTAL_FEE DECIMAL(8,2),
BOAT_NAME VARCHAR(50),
BOAT_TYPE VARCHAR(50),
OWNER_NUM VARCHAR(4),
CONSTRAINT MARINA_SLIP_SLIP_ID_PK PRIMARY KEY (SLIP_ID),
CONSTRAINT MARINA_SLIP_MARINA_NUM_FK FOREIGN KEY (MARINA_NUM),
CONSTRAINT MARINA_SLIP_OWNER_NUM_FK FOREIGN KEY (OWNER_NUM) REFERENCES OWNER (OWNER_NUM)
);

错误声明：

错误1064 (42000)：您的SQL语法出现了错误；请检查与MySQL服务器版本相对应的手册，以便在第12行使用接近“约束MARINA_SLIP_OWNER_NUM_FK外键(OWNER_NUM)引用所有者”(O‘)的正确语法。

有人知道为什么这行不通吗？

编辑:这是为我想出的，小错误上没有包含外键的参考。

Answer 1

将REFERENCES添加到CONSTRAINT MARINA_SLIP_MARINA_NUM_FK FOREIGN KEY (MARINA_NUM)中，例如CONSTRAINT MARINA_SLIP_MARINA_NUM_FK FOREIGN KEY (MARINA_NUM) REFERENCES OWNER (MARINA_NUM)