Question: i keep getting this error. #1452 - Cannot add or update a child row: a foreign key constraint fails (`cis202920_13`.`titles`, CONSTRAINT `FK_titles` FOREIGN KEY (`emp_no`)
i keep getting this error. #1452 - Cannot add or update a child row: a foreign key constraint fails (`cis202920_13`.`titles`, CONSTRAINT `FK_titles` FOREIGN KEY (`emp_no`) REFERENCES `employees` (`emp_no`))
What am i doing wrong? Here is my coding for creating tables and inserting data into it.This for MySQL for phpMyadmin
create table employees
( emp_no int(11) not null primary key,
birth_date date,
first_name varchar(14),
last_name varchar(16),
hire_date date
)ENGINE=InnoDB;
create table titles
( emp_no int(11),
title varchar(50),
from_date date,
to_date date
)ENGINE=InnoDB;
ALTER TABLE titles ADD PRIMARY KEY (emp_no,title,from_date);
ALTER TABLE titles ADD CONSTRAINT FK_titles
FOREIGN KEY(emp_no) REFERENCES employees (emp_no);
insert into employees
values
(10001,'1953-09-02', 'Georgi','Georgi','1986-06-26'),
(10002,'1964-06-02', 'Bezalel','Simmel','1985-11-21'),
(10003,'1959-12-03', 'Parto', 'Bamford', '1986-08-28');
insert into titles
values
( 1001, 'Engineer','1986-06-26','9999-01-01'),
( 1001, 'Senior Engineer','1995-11-28','9999-01-01'),
( 1002, 'Staff', '1996-08-03','9999-01-01'),
( 1003, 'Senior Enginner', '1995-12-03', '9999-01-01');
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
