數(shù)據(jù)庫(kù)系統(tǒng)報(bào)告五(編輯修改稿)
2025-08-17 11:53 本頁(yè)面
【文章內(nèi)容簡(jiǎn)介】 replace trigger audit_studentafter delete or insert or update on studentfor each rowbeginif deleting thenupdate audit_student set del=del+1where user_name=user and table_name=39。student39。else if inserting thenupdate audit_student set ins=ins+1where user_name=user and table_name=39。student39。elseupdate audit_student set upd=upd+1where user_name=user and table_name=39。student39。end if。end。insert into student valuse(39。00739。,39。jbd39。,39。8039。,39。m39。)。USER_NAME TABLE_NAME DEL INS UPD user1 student 0 1 0delete from student where sno=39。00339。USER_NAME TABLE_NAME DEL INS UPD user1 student 1 1
醫(yī)療健康相關(guān)推薦
鄂ICP備17016276號(hào)-1