mysql foreign key ... references ... on delete cascade
来源:互联网 发布:php大牛简历 编辑:程序博客网 时间:2024/05/06 19:32
把customerinfo里的customerid映射到orderinfo里的customerid,
任何一条没有合法的customerid的记录不会写到orderinfo里
CREATE TABLE customerinfo
(
customerid INT NOT NULL,
PRIMARY KEY(customerid)
)TYPE = INNODB;
CREATE TABLE orderinfo
(
orderid INT NOT NULL,
customerid INT NOT NULL,
PRIMARY KEY(customerid,orderid),
FOREIGN KEY (customerid) REFERENCES customerinfo
(customerid) ON DELETE CASCADE
)TYPE = INNODB;
注意:'ON DELETE CASCADE',该参数保证当customerinfo表中的一条记录删除的话同时也会删除order
表中的该用户的所有记录,注意使用外键要定义事务安全类型为INNODB;
- mysql foreign key ... references ... on delete cascade
- FOREIGN KEY 约束的ON UPDATE CASCADE 和 ON DELETE CASCADE
- MySQL 设置cascade on delete on update
- MySql 外键约束 FOREIGN KEY REFERENCES 之 空、RESTRICT、NO ACTION、CASCADE、SET NULL 等类型分析和作用解读
- Oracle之外键(Foreign Key)用法详解(二)- 级联删除(DELETE CASCADE)
- 笔记081112 ORACLE 常用系统函数 数字类型 时间类型 大文件数据类型 主键约束 NOT NULL UNIQUE CHECK FOREIGN KEY ON DELETE CASCADE ON DELETE SET NULL USER_C
- mysql的on delete restrict与on ordelete cascade区别
- mysql的on delete restrict与on ordelete cascade区别
- ON DELETE CASCADE ON UPDATE CASCADE
- ON UPDATE CASCADE ON DELETE CASCADE
- foreign key of Mysql
- mysql foreign key(外键)
- mysql foreign key
- mysql foreign key
- MySQL--FOREIGN KEY
- MySQL(Foreign Key)外键
- mysql foreign key
- MySQL Foreign Key练习
- 用混淆器保护你的JAVA(.class)代码(一)
- MyEclipse安装及破解 JDK 6 + TOMCAT 6 + Eclipse 3.3 + Myeclipse 6.0 安装 破解
- php函数get_magic_quotes_gpc详解
- 木马免杀原理详解
- POJ 2299
- mysql foreign key ... references ... on delete cascade
- 金山二十年长青的七种武器(2008-11-17 09:05:11)[转雷军新浪博客]
- NET-密码强度的验证
- DB2存储过程(Merge关键字的使用)
- 获取来电时的电话号码
- TCP的CLOSE_WAIT状态
- CA-NFS:2009存储界的一篇雄文
- 利用Axis2开发WebService(1)---安装配置Axis2
- 使用PLSQL Developer时,“ORA-12154: TNS:无法解析指定的连接标识符”问题的一个解决办法