ErrorSQL query:ALTER TABLE `departm

Error
SQL query:

ALTER TABLE `department` ADD CONSTRAINT `FK3` FOREIGN KEY ( `ma_staff` ) REFERENCES `project_management1`.`staff` (

`code_staff`
) ON DELETE RESTRICT ON UPDATE RESTRICT ;

MySQL said: Documentation

#1452 - Cannot add or update a child row: a foreign key constraint fails (`project_management1`.`#sql-1168_584`, CONSTRAINT `FK3` FOREIGN KEY (`ma_staff`) REFERENCES `staff` (`code_staff`))

Kết quả (Anh) 1:

ErrorSQL query:ALTER TABLE ' department ' ADD CONSTRAINT ' FK3 ' FOREIGN KEY (' ma_staff ') REFERENCES ' project_management1 '. ' staff ' (' code_staff ') ON DELETE RESTRICT ON UPDATE RESTRICT;MySQL said: Documentation# 1452-Cannot add or update a child row: a foreign key constraint fails (the ' project_management1 '. ' #sql -1168 _ 584 ', CONSTRAINT ' FK3 ' FOREIGN KEY (' ma_staff ') REFERENCES ' staff ' (' code_staff '))

Kết quả (Anh) 2:

Error
SQL query: ALTER TABLE ADD CONSTRAINT `` department` FK3` FOREIGN KEY (`ma_staff`) REFERENCES` project_management1`.`staff` ( `code_staff` ) ON DELETE RESTRICT ON UPDATE RESTRICT; MySQL said: Documentation # 1452 - Can not add or update a child row: a foreign key operation constraint fails (`project_management1`.` # sql-1168_584`, CONSTRAINT` FK3` FOREIGN KEY (`ma_staff`) REFERENCES` staff` (`code_staff`))