°Ô½Ã¹° 1,369°Ç
   
Cannot delete or update a parent row: a foreign key constraint fails
±Û¾´ÀÌ : ÃÖ°í°ü¸®ÀÚ ³¯Â¥ : 2016-09-09 (±Ý) 10:50 Á¶È¸ : 4036
±ÛÁÖ¼Ò :
                                
¿Ü·¡Å°(foreign key)¸¦ »ç¿ëÇÏ¿© Á¾¼Ó¼ºÀÌ »ý°åÀ» °æ¿ì ¾Æ·¡¿Í °°Àº ¿¡·¯¸Þ¼¼Áö¸¦ ¶ç¿ì¸é¼­ »èÁ¦°¡ ¾ÈµÇ´Â °æ¿ì
ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails (`glance`.`image_locations`, CONSTRAINT `image_locations_ibfk_1` FOREIGN KEY (`image_id`) REFERENCES `images` (`id`))

:: ¿Ü·¡Å° °Ë»ç ÀϽà Á¾·á
mysql> SET foreign_key_checks = 0;

:: ¿Ü·¡Å° °Ë»ç ½ÃÀÛ
mysql> SET foreign_key_checks = 1;

À̸§ Æнº¿öµå
ºñ¹Ð±Û (üũÇÏ¸é ±Û¾´À̸¸ ³»¿ëÀ» È®ÀÎÇÒ ¼ö ÀÖ½À´Ï´Ù.)
¿ÞÂÊÀÇ ±ÛÀÚ¸¦ ÀÔ·ÂÇϼ¼¿ä.
   

 



 
»çÀÌÆ®¸í : ¸ðÁö¸®³× | ´ëÇ¥ : ÀÌ°æÇö | °³ÀÎÄ¿¹Â´ÏƼ : ·©Å°´åÄÄ ¿î¿µÃ¼Á¦(OS) | °æ±âµµ ¼º³²½Ã ºÐ´ç±¸ | ÀüÀÚ¿ìÆí : mojily°ñ¹ðÀÌchonnom.com Copyright ¨Ï www.chonnom.com www.kyunghyun.net www.mojily.net. All rights reserved.