Mysql:无法创建表 errno 150

Question

我正在使用 Mysql 命令行创建一些简单的表。我在创建外键时发现了错误号 150。你能帮我解决这个问题吗？我对 SQL 有点陌生。谢谢!

mysql> CREATE TABLE maintenancepersons (ServiceID INT NOT NULL AUTO_INCREMENT, 
MechanicID INT NOT NULL, 
ServiceName VARCHAR(100) NOT NULL, 
PRIMARY KEY ( ServiceID ), CarVIN INT NOT NULL, 
FOREIGN KEY ( CarVIN ) REFERENCES cars , 
CustomerID INT NOT NULL, FOREIGN KEY ( CustomerID ) REFERENCES  customers );
    ERROR 1005 (HY000): Can't create table 'dealership.maintenancepersons' (errno: 150)

Answer 1

您的外键约束中缺少列名称

FOREIGN KEY ( CarVIN ) REFERENCES cars.CarVIN??

和

FOREIGN KEY ( CustomerID ) REFERENCES customers.??