{"id":11009,"date":"2018-03-08T14:55:59","date_gmt":"2018-03-08T13:55:59","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/mysql-foreign-keys-and-cannot-delete-or-update-a-parent-row-a-foreign-key-constraint-fails-error\/"},"modified":"2018-03-08T14:55:59","modified_gmt":"2018-03-08T13:55:59","slug":"mysql-foreign-keys-and-cannot-delete-or-update-a-parent-row-a-foreign-key-constraint-fails-error","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/mysql-foreign-keys-and-cannot-delete-or-update-a-parent-row-a-foreign-key-constraint-fails-error\/","title":{"rendered":"MySQL &#8211; Foreign keys and \u201cCannot delete or update a parent row: a foreign key constraint fails\u201d error"},"content":{"rendered":"<p>As you know, foreign keys establish a sort of relationship between 2 tables. MySQL requires InnoDB storage engine to support foreign keys.<\/p>\n<p>In our example, we have the following parent table in a MySQL 5.7.21 server:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">mysqld3-(root@localhost) [sakila]&gt; show create table actorG\n*************************** 1. row ***************************\n       Table: actor\nCreate Table: CREATE TABLE `actor` (\n  `actor_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,\n  `first_name` varchar(45) NOT NULL,\n  `last_name` varchar(45) NOT NULL,\n  `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\n  PRIMARY KEY (`actor_id`),\n  KEY `idx_actor_last_name` (`last_name`)\n) ENGINE=InnoDB AUTO_INCREMENT=201 DEFAULT CHARSET=utf8\n1 row in set (0.00 sec)\n<\/pre>\n<p>&nbsp;<\/p>\n<p>and a foreign key is defined on the child table by using the \u201cFOREIGN KEY\u2026 REFERENCES\u201d syntax:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">mysqld3-(root@localhost) [sakila]&gt; show create table film_actorG\n*************************** 1. row ***************************\n       Table: film_actor\nCreate Table: CREATE TABLE `film_actor` (\n  `actor_id` smallint(5) unsigned NOT NULL,\n  `film_id` smallint(5) unsigned NOT NULL,\n  `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\n  PRIMARY KEY (`actor_id`,`film_id`),\n  KEY `idx_fk_film_id` (`film_id`),\n  CONSTRAINT `fk_film_actor_actor` FOREIGN KEY (`actor_id`) REFERENCES `actor` (`actor_id`) ON UPDATE CASCADE,\n  CONSTRAINT `fk_film_actor_film` FOREIGN KEY (`film_id`) REFERENCES `film` (`film_id`) ON UPDATE CASCADE\n) ENGINE=InnoDB DEFAULT CHARSET=utf8\n1 row in set (0.00 sec)\n<\/pre>\n<p>&nbsp;<\/p>\n<p>The \u201cON UPDATE CASCADE\u201d clause means that if we update values in the parent table (\u2018actor\u2019 in our example),<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">mysqld3-(root@localhost) [sakila]&gt; select * from actor where actor_id=1;\n+----------+------------+-----------+---------------------+\n| actor_id | first_name | last_name | last_update         |\n+----------+------------+-----------+---------------------+\n|        1 | PENELOPE   | GUINESS   | 2006-02-15 04:34:33 |\n+----------+------------+-----------+---------------------+\n1 row in set (0.00 sec)\nmysqld3-(root@localhost) [sakila]&gt; select * from film_actor where actor_id=1;\n+----------+---------+---------------------+\n| actor_id | film_id | last_update         |\n+----------+---------+---------------------+\n|        1 |       1 | 2006-02-15 05:05:03 |\n|        1 |      23 | 2006-02-15 05:05:03 |\n|        1 |      25 | 2006-02-15 05:05:03 |\n|        1 |     106 | 2006-02-15 05:05:03 |\n|        1 |     140 | 2006-02-15 05:05:03 |\n|        1 |     166 | 2006-02-15 05:05:03 |\n|        1 |     277 | 2006-02-15 05:05:03 |\n|        1 |     361 | 2006-02-15 05:05:03 |\n|        1 |     438 | 2006-02-15 05:05:03 |\n|        1 |     499 | 2006-02-15 05:05:03 |\n|        1 |     506 | 2006-02-15 05:05:03 |\n|        1 |     509 | 2006-02-15 05:05:03 |\n|        1 |     605 | 2006-02-15 05:05:03 |\n|        1 |     635 | 2006-02-15 05:05:03 |\n|        1 |     749 | 2006-02-15 05:05:03 |\n|        1 |     832 | 2006-02-15 05:05:03 |\n|        1 |     939 | 2006-02-15 05:05:03 |\n|        1 |     970 | 2006-02-15 05:05:03 |\n|        1 |     980 | 2006-02-15 05:05:03 |\n+----------+---------+---------------------+\n19 rows in set (0.00 sec)\nmysqld3-(root@localhost) [sakila]&gt; update actor set actor_id=300 where actor_id=1;\nQuery OK, 1 row affected (0.02 sec)\nRows matched: 1  Changed: 1  Warnings: 0\n<\/pre>\n<p>&nbsp;<\/p>\n<p>then this will cause an automatic update of the matching rows in the child table (\u2018film_actor\u2019):<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">mysqld3-(root@localhost) [sakila]&gt; select * from actor where actor_id=1;\nEmpty set (0.00 sec)\nmysqld3-(root@localhost) [sakila]&gt; select * from film_actor where actor_id=1;\nEmpty set (0.00 sec)\nmysqld3-(root@localhost) [sakila]&gt; select * from actor where actor_id=300;\n+----------+------------+-----------+---------------------+\n| actor_id | first_name | last_name | last_update         |\n+----------+------------+-----------+---------------------+\n|      300 | PENELOPE   | GUINESS   | 2018-02-07 15:41:45 |\n+----------+------------+-----------+---------------------+\n1 row in set (0.00 sec)\nmysqld3-(root@localhost) [sakila]&gt; select * from film_actor where actor_id=300;\n+----------+---------+---------------------+\n| actor_id | film_id | last_update         |\n+----------+---------+---------------------+\n|      300 |       1 | 2006-02-15 05:05:03 |\n|      300 |      23 | 2006-02-15 05:05:03 |\n|      300 |      25 | 2006-02-15 05:05:03 |\n|      300 |     106 | 2006-02-15 05:05:03 |\n|      300 |     140 | 2006-02-15 05:05:03 |\n|      300 |     166 | 2006-02-15 05:05:03 |\n|      300 |     277 | 2006-02-15 05:05:03 |\n|      300 |     361 | 2006-02-15 05:05:03 |\n|      300 |     438 | 2006-02-15 05:05:03 |\n|      300 |     499 | 2006-02-15 05:05:03 |\n|      300 |     506 | 2006-02-15 05:05:03 |\n|      300 |     509 | 2006-02-15 05:05:03 |\n|      300 |     605 | 2006-02-15 05:05:03 |\n|      300 |     635 | 2006-02-15 05:05:03 |\n|      300 |     749 | 2006-02-15 05:05:03 |\n|      300 |     832 | 2006-02-15 05:05:03 |\n|      300 |     939 | 2006-02-15 05:05:03 |\n|      300 |     970 | 2006-02-15 05:05:03 |\n|      300 |     980 | 2006-02-15 05:05:03 |\n+----------+---------+---------------------+\n<\/pre>\n<p>&nbsp;<\/p>\n<p>Sometimes, when we must drop an InnoDB table in MySQL, we could encounter the following error due to foreign keys:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">mysqld3-(root@localhost) [sakila]&gt; drop table actor;\nERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails\n<\/pre>\n<p>&nbsp;<\/p>\n<p>In this example, the \u2018actor\u2019 table is referenced by the \u2018film_actor\u2019 one:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">mysqld3-(root@localhost) [sakila]&gt; SELECT TABLE_NAME,COLUMN_NAME,CONSTRAINT_NAME, REFERENCED_TABLE_NAME,REFERENCED_COLUMN_NAME\n    -&gt; FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE\n    -&gt; WHERE REFERENCED_TABLE_SCHEMA = 'sakila'\n    -&gt; AND REFERENCED_TABLE_NAME = 'actor';\n+------------+-------------+---------------------+-----------------------+------------------------+\n| TABLE_NAME | COLUMN_NAME | CONSTRAINT_NAME     | REFERENCED_TABLE_NAME | REFERENCED_COLUMN_NAME |\n+------------+-------------+---------------------+-----------------------+------------------------+\n| film_actor | actor_id    | fk_film_actor_actor | actor                 | actor_id               |\n+------------+-------------+---------------------+-----------------------+------------------------+\n1 row in set (0.01 sec)\n<\/pre>\n<p>&nbsp;<\/p>\n<p>This foreign key constraint let data being consistent over different tables and that\u2019s also the reason why we could not drop the parent table.<br \/>\nWe can find this same information and the error cause displaying the state of the InnoDB storage engine through the \u201cSHOW ENGINE INNODB STATUS\u201d command:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">mysqld3-(root@localhost) [sakila]&gt; show engine innodb statusG\n*************************** 1. row ***************************\n  Type: InnoDB\n  Name:\nStatus:\n=====================================\n2018-02-07 15:44:34 0x7fb734174700 INNODB MONITOR OUTPUT\n=====================================\nPer second averages calculated from the last 46 seconds\n-----------------\nBACKGROUND THREAD\n-----------------\nsrv_master_thread loops: 84 srv_active, 0 srv_shutdown, 85720 srv_idle\nsrv_master_thread log flush and writes: 85803\n----------\nSEMAPHORES\n----------\nOS WAIT ARRAY INFO: reservation count 1607\nOS WAIT ARRAY INFO: signal count 1552\nRW-shared spins 0, rounds 757, OS waits 384\nRW-excl spins 0, rounds 342, OS waits 11\nRW-sx spins 2, rounds 60, OS waits 1\nSpin rounds per wait: 757.00 RW-shared, 342.00 RW-excl, 30.00 RW-sx\n------------------------\nLATEST FOREIGN KEY ERROR\n------------------------\n2018-02-07 15:42:45 0x7fb734174700  Cannot drop table `sakila`.`actor`\nbecause it is referenced by `sakila`.`film_actor`\n...\n<\/pre>\n<p>&nbsp;<\/p>\n<p>To avoid these constraint errors during table deletion, there are different solutions:<br \/>\n&#8211; Drop table in the correct order (child table first, parent table as the last one)<br \/>\n&#8211; In case of a loop in foreign keys, remove this loop and redefine tables structure before dropping tables<br \/>\n&#8211; You can also temporarily set \u201cFOREIGN_KEY_CHECKS=0\u201d, drop the table and put again \u201cFOREIGN_KEY_CHECKS=1\u201d, but I don\u2019t recommend using this method (especially in a production environment!)<\/p>\n","protected":false},"excerpt":{"rendered":"<p>As you know, foreign keys establish a sort of relationship between 2 tables. MySQL requires InnoDB storage engine to support foreign keys. In our example, we have the following parent table in a MySQL 5.7.21 server: mysqld3-(root@localhost) [sakila]&gt; show create table actorG *************************** 1. row *************************** Table: actor Create Table: CREATE TABLE `actor` ( `actor_id`&hellip;&nbsp;<\/p>\n","protected":false},"author":28,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","neve_meta_reading_time":"","_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[4133,1316],"tags":[],"class_list":["post-11009","post","type-post","status-publish","format-standard","category-database","category-mysql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.8 (Yoast SEO v28.9) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>MySQL - Foreign keys and \u201cCannot delete or update a parent row: a foreign key constraint fails\u201d error - dbi services Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/mysql-foreign-keys-and-cannot-delete-or-update-a-parent-row-a-foreign-key-constraint-fails-error\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySQL - Foreign keys and \u201cCannot delete or update a parent row: a foreign key constraint fails\u201d error\" \/>\n<meta property=\"og:description\" content=\"As you know, foreign keys establish a sort of relationship between 2 tables. MySQL requires InnoDB storage engine to support foreign keys. In our example, we have the following parent table in a MySQL 5.7.21 server: mysqld3-(root@localhost) [sakila]&gt; show create table actorG *************************** 1. row *************************** Table: actor Create Table: CREATE TABLE `actor` ( `actor_id`&hellip;&nbsp;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/mysql-foreign-keys-and-cannot-delete-or-update-a-parent-row-a-foreign-key-constraint-fails-error\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi services Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dbiservices\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-03-08T13:55:59+00:00\" \/>\n<meta name=\"author\" content=\"Open source Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:site\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Open source Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/mysql-foreign-keys-and-cannot-delete-or-update-a-parent-row-a-foreign-key-constraint-fails-error\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/mysql-foreign-keys-and-cannot-delete-or-update-a-parent-row-a-foreign-key-constraint-fails-error\\\/\"},\"author\":{\"name\":\"Open source Team\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/0b4548362cac3eeff8b3eaf329e3530a\"},\"headline\":\"MySQL &#8211; Foreign keys and \u201cCannot delete or update a parent row: a foreign key constraint fails\u201d error\",\"datePublished\":\"2018-03-08T13:55:59+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/mysql-foreign-keys-and-cannot-delete-or-update-a-parent-row-a-foreign-key-constraint-fails-error\\\/\"},\"wordCount\":273,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\"},\"articleSection\":[\"Database\",\"MySQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/mysql-foreign-keys-and-cannot-delete-or-update-a-parent-row-a-foreign-key-constraint-fails-error\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/mysql-foreign-keys-and-cannot-delete-or-update-a-parent-row-a-foreign-key-constraint-fails-error\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/mysql-foreign-keys-and-cannot-delete-or-update-a-parent-row-a-foreign-key-constraint-fails-error\\\/\",\"name\":\"MySQL - Foreign keys and \u201cCannot delete or update a parent row: a foreign key constraint fails\u201d error - dbi services Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"datePublished\":\"2018-03-08T13:55:59+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/mysql-foreign-keys-and-cannot-delete-or-update-a-parent-row-a-foreign-key-constraint-fails-error\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/mysql-foreign-keys-and-cannot-delete-or-update-a-parent-row-a-foreign-key-constraint-fails-error\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/mysql-foreign-keys-and-cannot-delete-or-update-a-parent-row-a-foreign-key-constraint-fails-error\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQL &#8211; Foreign keys and \u201cCannot delete or update a parent row: a foreign key constraint fails\u201d error\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi services Blog\",\"description\":\"#BeSharing\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\",\"name\":\"dbi services\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"width\":512,\"height\":512,\"caption\":\"dbi services\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/dbiservices\\\/\",\"https:\\\/\\\/x.com\\\/dbiservices\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dbi-services\\\/\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/dbiservices\"],\"description\":\"Swiss IT consulting and services company specialized in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.\",\"email\":\"info@dbi-services.com\",\"telephone\":\"+41 32 422 96 00\",\"legalName\":\"dbi services SA\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/0b4548362cac3eeff8b3eaf329e3530a\",\"name\":\"Open source Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/open-source-author.png\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/open-source-author.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/open-source-author.png\",\"caption\":\"Open source Team\"},\"description\":\"Posts published under the Open source Team account are collective contributions by the dbi services open infrastructure consultants. The practice covers open-source databases and platforms, PostgreSQL first of all, along with MySQL, MariaDB, and Linux, from architecture, replication, and high availability to performance tuning and operations under service level agreements, and contributes actively to the PostgreSQL community.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/open-source-team\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"MySQL - Foreign keys and \u201cCannot delete or update a parent row: a foreign key constraint fails\u201d error - dbi services Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/mysql-foreign-keys-and-cannot-delete-or-update-a-parent-row-a-foreign-key-constraint-fails-error\/","og_locale":"en_US","og_type":"article","og_title":"MySQL - Foreign keys and \u201cCannot delete or update a parent row: a foreign key constraint fails\u201d error","og_description":"As you know, foreign keys establish a sort of relationship between 2 tables. MySQL requires InnoDB storage engine to support foreign keys. In our example, we have the following parent table in a MySQL 5.7.21 server: mysqld3-(root@localhost) [sakila]&gt; show create table actorG *************************** 1. row *************************** Table: actor Create Table: CREATE TABLE `actor` ( `actor_id`&hellip;&nbsp;","og_url":"https:\/\/www.dbi-services.com\/blog\/mysql-foreign-keys-and-cannot-delete-or-update-a-parent-row-a-foreign-key-constraint-fails-error\/","og_site_name":"dbi services Blog","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","article_published_time":"2018-03-08T13:55:59+00:00","author":"Open source Team","twitter_card":"summary_large_image","twitter_creator":"@dbiservices","twitter_site":"@dbiservices","twitter_misc":{"Written by":"Open source Team","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/mysql-foreign-keys-and-cannot-delete-or-update-a-parent-row-a-foreign-key-constraint-fails-error\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/mysql-foreign-keys-and-cannot-delete-or-update-a-parent-row-a-foreign-key-constraint-fails-error\/"},"author":{"name":"Open source Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0b4548362cac3eeff8b3eaf329e3530a"},"headline":"MySQL &#8211; Foreign keys and \u201cCannot delete or update a parent row: a foreign key constraint fails\u201d error","datePublished":"2018-03-08T13:55:59+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/mysql-foreign-keys-and-cannot-delete-or-update-a-parent-row-a-foreign-key-constraint-fails-error\/"},"wordCount":273,"commentCount":0,"publisher":{"@id":"https:\/\/www.dbi-services.com\/#organization"},"articleSection":["Database","MySQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/mysql-foreign-keys-and-cannot-delete-or-update-a-parent-row-a-foreign-key-constraint-fails-error\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/mysql-foreign-keys-and-cannot-delete-or-update-a-parent-row-a-foreign-key-constraint-fails-error\/","url":"https:\/\/www.dbi-services.com\/blog\/mysql-foreign-keys-and-cannot-delete-or-update-a-parent-row-a-foreign-key-constraint-fails-error\/","name":"MySQL - Foreign keys and \u201cCannot delete or update a parent row: a foreign key constraint fails\u201d error - dbi services Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2018-03-08T13:55:59+00:00","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/mysql-foreign-keys-and-cannot-delete-or-update-a-parent-row-a-foreign-key-constraint-fails-error\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/mysql-foreign-keys-and-cannot-delete-or-update-a-parent-row-a-foreign-key-constraint-fails-error\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/mysql-foreign-keys-and-cannot-delete-or-update-a-parent-row-a-foreign-key-constraint-fails-error\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"MySQL &#8211; Foreign keys and \u201cCannot delete or update a parent row: a foreign key constraint fails\u201d error"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi services Blog","description":"#BeSharing","publisher":{"@id":"https:\/\/www.dbi-services.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.dbi-services.com\/#organization","name":"dbi services","url":"https:\/\/www.dbi-services.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","width":512,"height":512,"caption":"dbi services"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/dbiservices\/","https:\/\/x.com\/dbiservices","https:\/\/www.linkedin.com\/company\/dbi-services\/","https:\/\/www.youtube.com\/user\/dbiservices"],"description":"Swiss IT consulting and services company specialized in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.","email":"info@dbi-services.com","telephone":"+41 32 422 96 00","legalName":"dbi services SA"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0b4548362cac3eeff8b3eaf329e3530a","name":"Open source Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/05\/open-source-author.png","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/05\/open-source-author.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/05\/open-source-author.png","caption":"Open source Team"},"description":"Posts published under the Open source Team account are collective contributions by the dbi services open infrastructure consultants. The practice covers open-source databases and platforms, PostgreSQL first of all, along with MySQL, MariaDB, and Linux, from architecture, replication, and high availability to performance tuning and operations under service level agreements, and contributes actively to the PostgreSQL community.","url":"https:\/\/www.dbi-services.com\/blog\/author\/open-source-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/11009","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/28"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=11009"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/11009\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=11009"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=11009"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=11009"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}