mysql报错[Err] 1005 - Can't create table '***.#sql-a44_e8' (errno: 150)

常出现在添加约束的时候。例如：
ddl语句为：

CREATE TABLE Person (
    id BIGINT NOT NULL, PRIMARY KEY (id)
);

CREATE TABLE Phone (
    id BIGINT NOT NULL,
    number VARCHAR(255),
    type VARCHAR(255),
    person_id BIGINT,
    PRIMARY KEY (id)
);

ALTER TABLE Phone
ADD CONSTRAINT UK_l329ab0g4c1t78onljnxmbnp6
UNIQUE (number);

ALTER TABLE Phone
ADD CONSTRAINT FKmw13yfsjypiiq0i1osdkaeqpg
FOREIGN KEy (person_id) REFERENCES Person;

后来发现是最后一句错了，REFERENCES Person后面加个id即可：

ALTER TABLE Phone
ADD CONSTRAINT FKmw13yfsjypiiq0i1osdkaeqpg
FOREIGN KEy (person_id) REFERENCES Person(id);

原始语句是来自官网，如图：