首页 文章

MySQL:无法使用FK获取表(errno 150)

提问于
浏览
-1

获得ERROR 1005(HY000):无法创建表'at.memdetails'(错误号:150)

create table members 
(UserId varchar(5) primary key, 
Name varchar(30) not null, 
UserName varchar(15) not null unique, 
pwd varchar(20) not null);


create table MemDetails (user_id varchar(5) primary key, 
mobileNo bigint not null unique, 
Email varchar(20) not null, 
City varchar(20) not null, 
State varchar(20) not null, 
constraint FKey1 foreign key (user_id) 
references members(user_id) 
on delete cascade);

1 回答

  • 0

    使用以下代码创建第二个表:

    create table MemDetails (user_id varchar (5) primary key)
    mobileNo BIGINT NOT NULL UNIQUE, 
    Email VARCHAR(20) NOT NULL,
    City VARCHAR(20) NOT NULL,
    State VARCHAR(20) NOT NULL, 
    CONSTRAINT FKey1 FOREIGN KEY (user_id) 
    REFERENCES members(UserId) ON DELETE CASCADE);
    

相关问题