Error 1452 Foreign Key

here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings error number 1452 and policies of this site About Us Learn more about Stack Overflow

Error 1452 Mysql Workbench

the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation

Foreign Key Constraint Fails Mysql

Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it

Error 1452 Sqlstate 23000

only takes a minute: Sign up Mysql error 1452 - Cannot add or update a child row: a foreign key constraint fails up vote 179 down vote favorite 53 I'm having a bit of a strange problem, I'm trying to add a foreign key to one table that references another, but it is failing for some reason. With my limited error 1452 cannot add or update a child row knowledge of MySQL, the only thing that could possibly be suspect is that there is a foreign key on a different table referencing the one I am trying to reference. Here is a picture of my table relationships, generated via phpMyAdmin: Relationships I've done a SHOW CREATE TABLE query on both tables, sourcecodes_tags is the table with the foreign key, sourcecodes is the referenced table. CREATE TABLE `sourcecodes` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(11) unsigned NOT NULL, `language_id` int(11) unsigned NOT NULL, `category_id` int(11) unsigned NOT NULL, `title` varchar(40) CHARACTER SET utf8 NOT NULL, `description` text CHARACTER SET utf8 NOT NULL, `views` int(11) unsigned NOT NULL, `downloads` int(11) unsigned NOT NULL, `time_posted` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `user_id` (`user_id`), KEY `language_id` (`language_id`), KEY `category_id` (`category_id`), CONSTRAINT `sourcecodes_ibfk_3` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `sourcecodes_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `sourcecodes_ibfk_2` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) EN

here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow foreign key error sql the company Business Learn more about hiring developers or posting ads with us Stack Overflow mysql error 1452 foreign key constraint fails Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 error code 1452 mysql workbench million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up MySQL Error Code 1452 Foreign Key Constraint up vote 2 down vote favorite I'm receiving an error when I http://stackoverflow.com/questions/1253459/mysql-error-1452-cannot-add-or-update-a-child-row-a-foreign-key-constraint-fa attempt to create two tables. There was a multivalued dependency, so I separated the tables and came up with this: CREATE TABLE NAME ( NameID Integer NOT NULL AUTO_INCREMENT, Name varChar(255) NOT NULL, CONSTRAINT NAME_PK PRIMARY KEY(NameID) ); CREATE TABLE PHONE ( NameID Integer NOT NULL, PhoneNumber varChar(15) NOT NULL, NumType varChar(5) NOT NULL, CONSTRAINT PHONE_FK FOREIGN KEY(NameID) REFERENCES NAME(NameID), CONSTRAINT PHONE_PK PRIMARY KEY(NameID) ); But when attempting to add values with http://stackoverflow.com/questions/22210461/mysql-error-code-1452-foreign-key-constraint this code: INSERT INTO NAME (NameID, Name) VALUES (default, 'John Doe'); INSERT INTO PHONE (NameID, PhoneNumber, NumType) VALUES (default, '706-782-4719', 'Home'); I receive the infamous 1452 error: Error Code: 1452. Cannot add or update a child row: a foreign key constraint fails (`phone_mcneill`.`PHONE`, CONSTRAINT `PHONE_FK` FOREIGN KEY (`NameID`) REFERENCES `NAME` (`NameID`)) I am not entirely sure what this means as I have NameID autoincrementing in the first table. I can't have it auto_increment in the second one as well as it's a foreign key, correct? Thanks in advance for the help. mysql sql database foreign-keys mysql-error-1452 share|improve this question asked Mar 5 '14 at 22:10 Archibald 272215 add a comment| 1 Answer 1 active oldest votes up vote 2 down vote accepted You have defined a foreign key constraint on NameID column i.e in table PHONE using insert for phone table you have passed default against NameID ,but NameID is pointing to NAME table and expecting to have the inserted record id from NAME table it doesn't have a default value as per the docs When a new AUTO_INCREMENT value has been generated, you can also obtain it by executing a SELECT LAST_INSERT_ID() So your second insert can use the inserted if from NAME table like INSERT INTO NAME (NameID, NAME) VALUES (DEFAULT, 'John Doe'); INS

here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack http://stackoverflow.com/questions/31657372/mysql-foreign-key-error-1452-when-the-key-appears-to-be-ok Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community https://www.experts-exchange.com/questions/28238845/1452-Cannot-add-or-update-a-child-row-a-foreign-key-constraint-fails.html of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up MySQL foreign key error 1452 when the key appears to be ok up vote 0 down error 1452 vote favorite I am using phpMyAdmin. I have dropped all my tables and recreated them using the export from MySQLWorkbench (this has worked fine before). I have repopulated certain tables with data, but get a failure on this one table with: #1452 - Cannot add or update a child row: a foreign key constraint fails (`col8_apps`.`companies`, CONSTRAINT `fk_companies_users1` FOREIGN KEY (`mainadmin`) REFERENCES `users` (`userid`) ON DELETE NO ACTION ON UPDATE NO error 1452 foreign ACTION) The table structures concerned - companies: companyid int(10) UNSIGNED AUTO_INCREMENT client int(10) UNSIGNED name varchar(150) mainadmin int(10) UNSIGNED .... users: userid int(10) UNSIGNED AUTO_INCREMENT .... I have a user in users with userid=1 I am trying to run this SQL: INSERT INTO companies (companyid, client, name, mainadmin, companylogo, active) VALUES (1,1,'Company One', 1, 'default',1); If I use myPhpAdmin to Insert, it will let me select the userid from the dropdown list - so it recognises that that foreign key I'm using exists - for mainadmin but it still then gives me the foreign key error above. Anyone any clues what might be causing this? EDIT: Running SHOW ENGINE INNODB STATUS gave this curious message: Trying to add to index `fk_companies_users1_idx` tuple: DATA TUPLE: 2 fields; 0: len 4; hex 00000001; asc ;; 1: len 4; hex 00000001; asc ;; But the parent table `col8_apps`.`users` or its .ibd file does not currently exist! The table is definitely there, but I've no idea what a .ibd file is? mysql phpmyadmin share|improve this question edited Jul 27 '15 at 16:31 asked Jul 27 '15 at 15:38 AntG 171211 Your companyid is Auto-Increment so you should not need to be explicitly inserting a value - do you already have a row with compan

for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > #1452 - Cannot add or update a child row: a foreign key constraint fails Want to Advertise Here? Solved #1452 - Cannot add or update a child row: a foreign key constraint fails Posted on 2013-09-13 PHP MySQL Server 2 Verified Solutions 9 Comments 15,261 Views Last Modified: 2013-09-13 Whenever I try to create a relationship between one table and another, to create a foreign key, i get the error: #1452 - Cannot add or update a child row: a foreign key constraint fails (`expenses`., CONSTRAINT `#sql-22f8_203_ibfk_1` FOREIGN KEY (`users_id`) REFERENCES `users` (`users_id`)) Any ideas what this could be? Googled this with no useful results. :( Thanks. 0 Question by:LB1234 Facebook Twitter LinkedIn Google LVL 42 Active 3 days ago Best Solution byChris Stanyon You do need to change the values - you can't have a record in a child table that doesn't have a matching record in a parent table - that's the whole point of a FOREIGN KEY. If you have 1 parent record Go to Solution 9 Comments LVL 53 Overall: Level 53 PHP 13 MySQL Server 5 Message Expert Comment by:COBOLdinosaur2013-09-13 Without seeing the structure of the data and the code that is generation the error, it is not likely that we can do much more than speculate. Cd& 0 LVL 1 Overall: Level 1 Message Author Comment by:LB12342013-09-13 Error SQL query: ALTER TABLE `transactions` ADD FOREIGN KEY ( `users_id` ) REFERENCES `expenses`.`users` ( `users_id` ) ON DELETE RESTRICT ON UPDATE RESTRICT ; Select all Open in new window 0 LVL 1 Overall: Level 1 Message Author Comment by:LB12342013-09-13 0 LVL 42 Overall: Level 42 PHP 26 MySQL Server 13 Message Active 3 days ago Expert Comment by:Chris Stanyon2013-09-13 Because you're adding a