911speedstar
V2EX  ›  问与答

请问 mysql 怎么级联删除?

  •  
  •   911speedstar · Feb 28, 2023 · 1990 views
    This topic created in 1352 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
    iseki
    Feb 28, 2023❤️1
    1
    建表时为啥不写 on delete cascade
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Privacy   ·   Solana   ·   3880 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 25ms · UTC 09:43 · PVG 17:43 · LAX 01:43 · JFK 04:43
    ♥ Do have faith in what you're doing.