Re: Materialized view on mysql replica.
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 ;
Subject
Views
Written By
Posted
668
November 30, 2020 01:31PM
Re: Materialized view on mysql replica.
308
November 30, 2020 03:09PM
325
December 01, 2020 11:58AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.