mysql - 无法在mysql中添加外键约束

Question

create table buys (    
user_id INT(11) not null,    
software_id INT(11) not null,    
associated_id INT(11) not null,    
primary key (associated_id),    
foreign key (software_id) references software,    
foreign key (user_id) references users,    
foreign key (associated_id) references associated);

我有一个三元关系关联表，具有完全参与和键约束，但无法添加外键约束

Answer 1

检查以下查询:

CREATE TABLE products(
   prd_id int not null auto_increment primary key,
   cat_id int not null,
   FOREIGN KEY fk_cat(cat_id)
   REFERENCES categories(cat_id)
)ENGINE=InnoDB;

就您而言:

foreign key (software_id) references software -> here column name is missing in software table