为什么创建不成功这错误是怎磨回事

Question

DROP TABLE IF EXISTS authority;
CREATE TABLE authority (
id int(11) NOT NULL AUTO_INCREMENT,
menuId int(11) DEFAULT NULL,
roleId int(11) DEFAULT NULL,
PRIMARY KEY (id),
KEY menuId (menuId),
KEY roleId (roleId),
CONSTRAINT authority_ibfk_1 FOREIGN KEY (menuId) REFERENCES menu (id),
CONSTRAINT authority_ibfk_2 FOREIGN KEY (roleId) REFERENCES role (id)
) ENGINE=INNODB AUTO_INCREMENT=1722 DEFAULT CHARSET=utf8;

1824 - Failed to open the referenced table 'menu'
时间: 0s

Answer 1

KEYmenuId 是个什么语法，key和menuid之间要有空格啊