|
Keshaba
Yak Posting Veteran
India
52 Posts |
 Posted - 06/21/2011 : 09:37:37
|
Hi i am creating a trigger in mysql as given below but it is giving me errors 'Can't update chat_master in stored function / trigger because it is already used by statement which invoked this stored procedure trigger
delimiter $
CREATE TRIGGER myTrigger
After INSERT ON chat_master
FOR EACH ROW
BEGIN
DECLARE row_count INTEGER;
SELECT COUNT(*)
INTO row_count
FROM chat_master
WHERE UM_master_id=NEW.UM_master_id;
IF row_count > 0 THEN
delete from chat_master where UM_master_id=1;
END IF;
end $$
Can anybody help
Keshab |
|
trigger
