911speedstar
V2EX  ›  问与答

请问 mysql 怎么级联删除?

  •  
  •   911speedstar · Feb 28, 2023 · 1534 views
    This topic created in 1189 days ago, the information mentioned may be changed or developed.

    用的 Navicat Premium 16 ,每次调试删除一条数据的时候,外键会阻止删除。当外键多了,或者外键的表字段还有外键时,这种删除就很麻烦了。请问 Navicat 能在删除一条数据时候,级联删除所有外键数据吗?

    1 replies    2023-02-28 23:44:51 +08:00
    iseki
        1
    iseki  
       Feb 28, 2023   ❤️ 1
    建表时为啥不写 on delete cascade
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Solana   ·   968 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 5414617a · 37ms · UTC 20:40 · PVG 04:40 · LAX 13:40 · JFK 16:40
    ♥ Do have faith in what you're doing.