Re: Query Help Needed

[irek kordirko]

No, it won't work.

create table a(
  id int primary key,
  name varchar(100)
);

insert into a values( 1, 'name 1' ), ( 2, 'name 2');

delimiter $$
drop procedure if exists upd_a $$
create procedure upd_a( i_name varchar(100))
begin
  update a set name = i_name where id = 1;
end;
$$

create trigger upd_a_trig
after update on a
for each row
begin
  call upd_a( 'new name' );
end;
$$

delimiter ;

mysql> update a set name = 'xx' where id = 2;
ERROR 1442 (HY000): Can't update table 'a' in stored function/trigger because it is already used by statement which invoked this stored function/trigger.