[dreamincodehamza]

my triggeR

DELIMITER // 
	CREATE TRIGGER test
	FOR EACH ROW 
	
BEGIN
 
 #CALL update_pro();
 IF NEW.username != 'admin' THEN
  UPDATE users SET new.username = 'admin' WHERE old.id = '4';
 END IF;
 
END
	END//
DELIMITER ;

# AFTER UPDATE ON products 
# FOR EACH ROW

getting error
site:forums.mysql.com 1442 - Can't update table 'users' in stored function/trigger because it is already used by statement which invoked this stored function/trigger.mysql>

Pleas help ,,
any solution

[e_i_pi]

AFAIK, it's not possible to update a row of a table that is calling the trigger, otherwise the trigger can become recursive.

It looks like all you're doing is setting the username to 'admin' when the id is '4'. Is it necessary to do this as a trigger? Why don't you just use a run-once script?

[dreamincodehamza]

e_i_pi, on 17 December 2012 - 07:41 PM, said:

AFAIK, it's not possible to update a row of a table that is calling the trigger, otherwise the trigger can become recursive.

It looks like all you're doing is setting the username to 'admin' when the id is '4'. Is it necessary to do this as a trigger? Why don't you just use a run-once script?

basically i just want to do this using trigger because as we know triggers activated on add, update, delete