Adding multi columns and foreign key

Question

I`m a beginner in structured query language . I want to add multi columns with different foreign key.Like the example:

drop schema humman;

create schema humman;

CREATE TABLE humman.father (
id int not null auto_increment,
firstname varchar(200) not null,
primary key(id)
);

create table humman.mather(
id int not null auto_increment,
FirstName varchar(200),
primary key(id)
);

CREATE TABLE humman.child (
id int not null auto_increment,
firstname varchar(200) not null,
primary key(id)
);

use `humman`;

alter table humman.child 
ADD `parentId` int ,
ADD `motherId` int,
ADD  foreign key (`parentId`) references father(`id`),
ADD foreign key (`motherId`) references mother(`id`);

Error code: 1215 Cannot add foreign key CONSTRAINT

not mather but mother

Barbaros Özhan
– Barbaros Özhan

2018-06-10 22:13:01 +00:00
Commented Jun 10, 2018 at 22:13 — Barbaros Özhan
– Barbaros Özhan, Commented Jun 10, 2018 at 22:13

Aleu · Accepted Answer · 2018-06-10 22:12:02Z

1

Your code is good except for a typo, you spelt "mother" as "mather" in your second table definition;

create table humman.mather(
id int not null auto_increment,
FirstName varchar(200),
primary key(id)
);

correct that and it should work.

answered Jun 10, 2018 at 22:12

Aleu

736 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Adding multi columns and foreign key

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related