获得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 回答
使用以下代码创建第二个表: