数据库_级联更新/级联删除_ON UPDATE CASCADE/ON DELETE CASCADE
来源:互联网 发布:js 树形菜单递归函数 编辑:程序博客网 时间:2024/05/12 01:26
ON UPDATE CASCADE / ON DELETE CASCADE
级联更新与级联删除需要设置在从表上,
INSERT INTO Countries (CountryId) VALUES (1)
INSERT INTO Countries (CountryId) VALUES (2)
INSERT INTO Countries (CountryId) VALUES (3)
GO
CREATE TABLE Cities( CityId INT PRIMARY KEY ,CountryId INT REFERENCES Countries ON DELETE CASCADE);
INSERT INTO Cities VALUES(1,1)
INSERT INTO Cities VALUES(2,1)
INSERT INTO Cities VALUES(3,2)
GO
CREATE TABLE Buyers(CustomerId INT PRIMARY KEY ,CityId INT REFERENCES Cities ON DELETE CASCADE);
INSERT INTO Buyers VALUES(1,1),
INSERT INTO Buyers VALUES(2,1)
INSERT INTO Buyers VALUES(3,2)
GO
命令:
DELETE FROM Countries WHERE CountryId = 1
结果:
Countries:
CountryId
2
3
Cities:
CityId CountryId
3 2
Buyers:
CustomerId CityId
ON UPDATE CASCADE的用法和ON DELETE CASCADE差不多
0 0
- 数据库_级联更新/级联删除_ON UPDATE CASCADE/ON DELETE CASCADE
- 数据库级联更新 on update cascade和级联删除 on delete cascade
- ON DELETE CASCADE(级联删除)
- SQL SERVER 主键和外键中的 级联删除(ON DELETE CASCADE)和级联更新(ON UPDATE CASCADE)
- SQL SERVER 主键和外键中的 级联删除(ON DELETE CASCADE)和级联更新(ON UPDATE CASCADE)
- delete cascade 级联删除
- SQL Server 级联删除 ON DELETE CASCADE
- T-SQL级联删除——ON DELETE CASCADE
- 关系表的级联删除(ON DELETE CASCADE的用法)
- mysql级联删除CASCADE
- on delete cascade和on delete set null的级联删除
- cascade 级联
- ON DELETE CASCADE ON UPDATE CASCADE
- ON UPDATE CASCADE ON DELETE CASCADE
- 如何实现关系表的级联删除(ON DELETE CASCADE的用法)
- 如何实现关系表的级联删除(ON DELETE CASCADE的用法)
- 如何实现关系表的级联删除(ON DELETE CASCADE的用法)
- 如何实现关系表的级联删除(ON DELETE CASCADE的用法)
- Android 模仿微信长按录音功能
- Codevs 1074 食物链 2001年NOI全国竞赛
- POJ-2524-Ubiquitous Religions
- String 和StringBuffer,StringBuilder的区别
- 策略模式与状态模式
- 数据库_级联更新/级联删除_ON UPDATE CASCADE/ON DELETE CASCADE
- LeetCode--Binary Tree Traversal ( Inorder, Preorder, PostOrder)
- 编译预处理
- [HihoCoder]#1077 : RMQ问题再临-线段树
- 设计模式之装饰者模式
- Android初学之Handler
- 【Codeforces Round 362 (Div 2)D】【树的遍历 概率均分思想】Puzzles 兄弟节点的等概率遍历下 树的遍历每点期望时间戳
- 收集的博客和文章
- 英语 语法检查网站 小记