mysql - 错误1005(HY000): Can't create table 'login' (errno: 150)

Question

我创建了如下寄存器表:

 create table register(rid int,email varchar(30),name varchar(30),phone varchar(12),address varchar(50),primary key(rid,email));

当我尝试创建登录表时，我得到 errno:150

 create table query_login(lid int primary key auto_increment,email varchar(30) not null,salt varchar(100),password varchar(100),foreign key (email)references query_register(email) on delete cascade on update cascade);

Answer 1

我得到了答案。我只是在电子邮件上创建索引