简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Database > Mysql Tutorial > body text

MySQL外键关联问题

WBOY
Release： 2016-06-07 17:09:33
Original
1321 people have browsed it

继续再看老师给推荐的深入浅出mysql数据库开发这本书，看到innodb数据库的外键关联问题时，遇到了一个问题，书上写的是可以对父表

继续再看老师给推荐的深入浅出mysql数据库开发这本书（下载见  ），看到innodb数据库的外键关联问题时，遇到了一个问题，书上写的是可以对父表进行修改，从而同步到子表的外键上去，可是自己的实验却是没有能够。

 

  • ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails (`test/city`, CONSTRAINT `city_ibfk_1` FOREIGN KEY (`country_id`) REFERENCES `country` (`country_id`))  

    • 上面的问题是说因为有关联的存在，所以无法改变country_id这个字段。

    linux

    ，
    Related labels：
    database
    source：php.cn
    Previous article：Oracle kill session.delete 600w(1.25G)数据 1个多小时无结果 Next article：Oracle表空间(Tablespace)
    Statement of this Website
    The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
    Latest Articles by Author
    Latest Issues
    Unable to receive information from my mySQL database despite having seen tutorials doing the exact same thing So I'm trying to make a program that reads and writes to a MySQL database, which led me to...
    From 2024-04-03 14:46:04
    0
    1
    298
    What are the architectural layers of a Spring Boot + React + MySQL application? I'm trying to write documentation about the application but I'm confused on how to describ...
    From 2024-04-03 10:07:06
    0
    1
    410
    Can't center text using CSS + HTML I'm trying to center text using CSS and HTML. I'm very new to web development so I'm just ...
    From 2024-03-31 15:57:04
    0
    1
    322
    Prisma room management system I'm trying to create a database for a room management system but I'm confused about the re...
    From 2024-03-30 18:46:05
    0
    1
    390
    Why does every time I save my Vite React project, a new canvas element is added to the page body instead of replacing the existing canvas element? I'm trying to start learning ThreeJs (I'm also new to Javascript web development). After w...
    From 2024-03-30 09:57:49
    0
    1
    396
    Related Topics
    More>
    Popular Recommendations
    Popular Tutorials
    More>
    Related Tutorials
    Popular Recommendations
    Latest courses
    Latest Downloads
    More>
    Web Effects
    Website Source Code
    Website Materials
    Front End Template
    About us Disclaimer Sitemap
    php.cn：Public welfare online PHP training，Help PHP learners grow quickly！