比如user和student 各有一个ID字段 我想实现当删除user某一条字段，在student表中会根据被删掉的user ID，删除掉对应的数据，建了个触发器老是报错，代码如下 create trigger ssss before delete on student for each ROW BEGIN delete from user where id=old.id; end; 报错信息：[Err] 1235 - This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' 是不是因为我的mysql版本低，只支持update和insert |
1min目标场景问卷
立即参与
