触发器语句如下:
CREATE TRIGGER users_login AFTER INSERT ON users_online FOR EACH ROW
UPDATE phone_users
SET isdisable = NEW.isdisable
WHERE
phone = NEW.phone;
插入语句如下:
insert into criminal_families_relationship (`user_id`,`user_bind_id`,`user_name`) select '123','456','tom' from dual where exists (select * from criminal_info where criminal_info.criminal_id='1236');
执行插入语句时有如下报错:
1442 - Can't update table 'phone_users' in stored function/trigger because it is already used by statement which invoked this stored function/trigger
插入时不带去重则不会报错,求解是什么问题