用触发器,插入前判断cno和cpno,如果相同,人为制造一个错误使COURSE插入失败
SQL code
delimiter $$
create trigger tr_tb before insert on course for each row
begin
if new.cno=new.cpno then
insert into tb select 1;
end if;
end
$$
de……
[/Quote]
+1
delimiter $$
create trigger tr_tb before insert on course for each row
begin
if new.cno=new.cpno then
insert into tb select 1;
end if;
end
$$
delimter ;