Re: Materialized view on mysql replica.

[Peter Brawley]

Something like this?

drop trigger if exists ttry;
delimiter go
create trigger ttry before insert on test for each row
begin
  if exists( 
             select table_name from information_schema.tables 
             where table_name='myspecialtable' 
           )
    then
    update myspecialtable set thiscol='yes';
  end if;
end;
go
delimiter ;