Hello, there is two tables “position” (position_id, position_name) and “employee”(employee_id, position_id(FK), name). When i want to add a new record to employee, i get error: “Failed to execute SQL. Error: Cannot add or update a child row: a foreign key constraint fails (dbname.employee, CONSTRAINT employee_ibfk_1 FOREIGN KEY (position_id) REFERENCES position (position_id) ON DELETE NO ACTION ON UPDATE NO ACTION) (1452)”
But when I try add a record in phpmyadmin-there is no any errors. Where is the problem? “Referential Integrity” is off.
Make sure that the value inserted/updated in the position field exists in the position table, or the foreign key constraint will fail.
arbei wrote:
Make sure that the value inserted/updated in the position field exists in
the position table, or the foreign key constraint will fail.
Thnx for answer. I use lookup table here. And check “position name”, but when i manually insert position_id-it works