Hibernate cascade and mysql foreign key

最新推荐文章于 2025-06-12 11:28:50 发布

转载最新推荐文章于 2025-06-12 11:28:50 发布 · 112 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/frankliiu-java/archive/2009/12/16/1625531.html

文章标签：

#java #数据库

本文介绍了一个名为'student'的表结构定义，该表包含id、teacher、name和sex等字段，并设置了外键约束及级联更新和删除。同时提到了Hibernate框架中级联操作的应用场景。

CREATE TABLE student (
    id          INTEGER UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
teacher      INTEGER UNSIGNED NOT NULL,
    name         varchar(12) BINARY NOT NULL,
    sex    TINYINT NOT NULL DEFAULT 0,
    FOREIGN KEY fk_teacher (teacher) REFERENCES teacher(id)
        ON UPDATE CASCADE
        ON DELETE CASCADE

) engine=INNODB;

If we set "ON UPDATE/DELETE CASCADE" on a foreign key, it is the same effect with configure hibernate CASCADE.

But if we set Hibernate cascade and foreign key cascade at the same time, then our project will use hibernate cascade first.

转载于:https://www.cnblogs.com/frankliiu-java/archive/2009/12/16/1625531.html