以下是我建的表:CREATE TABLE user (
name varchar(50) default NULL,
author varchar(50) NOT NULL default '',
PRIMARY KEY (author)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;CREATE TABLE news (
headline varchar(250) NOT NULL default '',
author varchar(50) default NULL,
body longtext,
date varchar(100) default NULL,
PRIMARY KEY (headline),
foreign key (author) references user(author) on delete cascade on update cascade
) ENGINE=MyISAM DEFAULT CHARSET=utf8;给表插入以下数据:
insert into user values('name1','author1');
insert into `news` values('headline1','author1','body1','date1');当我执行delete from user where author='author1'时,user表的记录是删除了,但news表中对应的记录却还在!请问这是什么原因??
name varchar(50) default NULL,
author varchar(50) NOT NULL default '',
PRIMARY KEY (author)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;CREATE TABLE news (
headline varchar(250) NOT NULL default '',
author varchar(50) default NULL,
body longtext,
date varchar(100) default NULL,
PRIMARY KEY (headline),
foreign key (author) references user(author) on delete cascade on update cascade
) ENGINE=MyISAM DEFAULT CHARSET=utf8;给表插入以下数据:
insert into user values('name1','author1');
insert into `news` values('headline1','author1','body1','date1');当我执行delete from user where author='author1'时,user表的记录是删除了,但news表中对应的记录却还在!请问这是什么原因??
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货