Home > database >  MySQL to create trigger unknown that occur when using the delete colom 'dno' in 'the
MySQL to create trigger unknown that occur when using the delete colom 'dno' in 'the

Time:09-24

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!
  • Related