代码如下:php语言
var $score//分数变量
if($score<60){
echo "不及格"
}elseif($score<69 &&$score>=60){
echo "及格"
}else if($score>=70 &&$score<80){
echo "中"
}else if($score>=80 &&$score<90){
echo "良"
}else{
echo "优"
}
1,创建触发器:t_afterinsert_on_tab1作用:增加tab1表记录后自动将记录增加到tab2表中
create
trigger
t_afterinsert_on_tab1
after
insert
on
tab1
for
each
row
begin
if
new.tab1_id
is
not
null
then
insert
into
tab2(tab2_id)
values(new.tab1_id)
end
if
end
2,创建触发器:t_afterdelete_on_tab1
作用:删除tab1表记录后自动将tab2表中对应的记录删去
create
trigger
t_afterdelete_on_tab1
after
delete
on
tab1
for
each
row
begin
delete
from
tab2
where
tab2_id=old.tab1_id
end
2,创建触发器:t_afterupdate_on_a
作用:修改a表age字段后自动将b表中对应的age字段修改
create
trigger
t_afterupdate_on_a
after
update
on
a
for
each
row
update
b
set
age=new.age
where
id=new.id
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)