Error 1452 My Sql
Contents |
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 error 1452 mysql workbench Us Learn more about Stack Overflow the company Business Learn more about hiring error 1452 mysql foreign key developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the error number 1452 Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Mysql error 1452 - Cannot add cannot add or update a child row 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 knowledge of MySQL, the only thing that could possibly be suspect is that there is a foreign key
Mysql Error 1452 Foreign Key Constraint Fails
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 ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 CREATE TABLE `sourcecodes_tags` ( `sourcecode_id` int(11) unsigned NOT NULL, `tag_id` int(11) unsigned NOT NULL, KEY `sourcecode_id` (`sourcecode_id`), KEY `tag_id` (`tag_id`), CONSTRAINT `sourcecodes_tags_ibfk_1` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`id`) ON DELETE CASCADE O
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
Mysql Error 1452 23000
About Us Learn more about Stack Overflow the company Business Learn more about error code 1452 mysql workbench hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join a foreign key constraint fails mysql insert the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up MySQL Error: #1452 - http://stackoverflow.com/questions/1253459/mysql-error-1452-cannot-add-or-update-a-child-row-a-foreign-key-constraint-fa Cannot add or update a child row: a foreign key constraint fails up vote 1 down vote favorite I am able to successfully insert a row in the business table but not the business_contact table. Whenever I try to insert a row in the business_contact table I get the following error: #1452 - Cannot add or update a child row: a foreign key constraint fails http://stackoverflow.com/questions/17121405/mysql-error-1452-cannot-add-or-update-a-child-row-a-foreign-key-constraint Although the row that I'm attempting to insert into the business_contact table has a BusinessID that already exists in the business table. business_contact failed insert statement INSERT INTO business_contact(BusinessID, BusinessContactTypeID, BusinessContactData) VALUES (1, 1, '0097336031000'); mysql database foreign-keys foreign-key-relationship share|improve this question edited Jun 15 '13 at 8:13 asked Jun 15 '13 at 7:53 AlGallaf 1073724 add a comment| 1 Answer 1 active oldest votes up vote 2 down vote accepted You should check the following in your business and contact_type_lookup table: 1. business table has BusinessID value that you are trying to insert into business_contact 2.contact_type_lookuptable hasContactTypeIDvalue that you are trying to insert into business_contact This error is related to either missing BusinessID and or missing ContactTypeID. To verify this please select the BusinessID record from business table and ContactTypeID from contact_type_lookup table. For example: If you are executing the following query: insert into business_contact(BusinessContactID, BusinessID, BusinessContactTypeID, BusinessContactData) values ('1', '2', '3', 'This is the business contact data'); Then, ensure that the following queries returns valid results: select BusinessID from business where BusinessID = 2; select ContactTypeID from business_contact_type where ContactTypeID = 3; share|improve this answer answered Jun 15 '13 at 8:11 vee
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss http://stackoverflow.com/questions/5198600/mysql-foreign-key-error-1452 the workings and policies of this site About Us Learn more about http://stackoverflow.com/questions/20024916/mysql-error-1452-23000-cannot-add-or-update-a-child-row Stack 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 of 4.7 million programmers, just like you, helping each error 1452 other. Join them; it only takes a minute: Sign up mysql foreign key error #1452 up vote 3 down vote favorite 1 ALTER TABLE `groups` ADD FOREIGN KEY ( `company_id` ) REFERENCES `summaries`.`companies` ( `id` ) ON DELETE CASCADE ; MySQL said: #1452 - Cannot add or update a child row: a foreign key constraint fails (`summaries/#sql-164a_33c`, CONSTRAINT error 1452 my `#sql-164a_33c_ibfk_1` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`) ON DELETE CASCADE) companies.id is primary auto increment int(11) company_id is index int(11) I don't understand the error message. Can anyone shed some light on this? mysql share|improve this question asked Mar 4 '11 at 19:58 Webnet 23.3k65200345 Paste outputs of both create table groups and summaries.companies ? –Zimbabao Mar 4 '11 at 20:00 add a comment| 4 Answers 4 active oldest votes up vote 22 down vote accepted That means you have at least one row in the child table that references a non-existent row in the parent table. If you are absolutely sure that you are okay with having a data integrity issue like that, you can add the foreign key by disabling foreign key checks before you run the ALTER TABLE command: SET FOREIGN_KEY_CHECKS = 0; share|improve this answer answered Mar 4 '11 at 20:10 Ike Walker 33.4k95278 add a comment| up vote 2 down vote I just had this problem, although in a somewhat more specific scenario. In my ca
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 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 of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up MySQL Error 1452 (23000): Cannot add or update a child row up vote 0 down vote favorite I need a help with this problem. I don't understand how to resolve this problem. I will be happy if you find out why this problem happens. Here is my SQL: Create database Order_Purchase; Use Order_Purchase; Create table Customer ( customerID int(10), cname varchar(30), city varchar(30), Constraint customer_PK Primary Key (customerID)) Engine = innodb; Create table Item ( itemID int(10), description varchar(30), price double, Constraint item_PK Primary Key (itemID)) Engine = innodb; Create table Order_ ( orderID int(10), customerID int(10), orderDate date, Constraint order_PK Primary Key (orderID), Constraint order_FK1 Foreign Key (customerID) references Customer(customerID)) Engine = innodb; Create table Order_Item ( orderID int(10) null default null, itemID int(10) null default null, quantity int, Constraint order_item_PK Primary Key (orderID, itemID), Constraint order_item_FK1 Foreign Key (orderID) references Order_(orderID), Constraint order_item_FK2 Foreign Key (itemID) references Item(itemID)) Engine = innodb; Create table Warehouse ( warehouseID int(10), city varchar(30), Constraint warehouse_PK Primary Key (warehouseID)) Engine = innodb; Create table Shipment ( orderID int(10), warehouseID int(10), shipDate date, Constraint shipment_PK Primary Key (orderID, warehouseID),