Create a table dept (dno, dname)
Table emp (eno, ename, dno)
Want to delete the dept department number in the dno after remove emp in personnel information, the department and create a trigger:


I don't know the problem there,,,

CodePudding user response:

The field is the dno, obviously typo

CodePudding user response:

Prompt obvious don field no, should be the dno

CodePudding user response:

Can only laugh it off!